Forums

anton
anton
Offline
Resolved
0 votes
Please Help me
I want to dump mysql with large database
i use bigdump
but notice shown


MySQL: Got a packet bigger than 'max_allowed_packet' bytes


Can anyone help me For Fix :(( Please
Sunday, March 20 2011, 06:17 PM
Share this post:
Responses (1)
  • Accepted Answer

    Monday, March 21 2011, 01:24 PM - #Permalink
    Resolved
    0 votes
    Hi,

    Edit the my.cnf file and add the following line below mysqld

    [mysqld]

    max_allowed_packet = 32M

    Save and restart the mysql database.

    Backup:

    mysqldump -u root -p dbname < dbname_$(date -I).dump

    Thank you,
    Regards,
    Jani
    The reply is currently minimized Show
Your Reply