Forums

Subscribe via email Subscribe via email
Subscribe via rss
Guest
or Ask a Question
Add a reply View Replies (1) →
anton
anton
Offline

Mysql Error

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
In Database
Sunday, March 20 2011, 06:17 PM
Subscribe via email
Share this post:
Responses (1)

  • Accepted Answer

    janakiraman
    janakiraman
    Offline
    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