LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Restore a big mysqldump (https://www.linuxquestions.org/questions/linux-server-73/restore-a-big-mysqldump-811693/)

turiyain 06-02-2010 08:34 AM
Restore a big mysqldump
 
Dear Experts,

I am having a 1 gb of mysqldump. When i try to restore this dump file, it is giving error " ERROR 1153 (08S01) at line 289: Got a packet bigger than 'max_allowed_packet' bytes". And with this i am not able to restore the database. mysqld version is 5.0.77.

Please help.

Vijay Thakur

ilikejam 06-02-2010 10:03 AM
Hi.

Change the max_allowed_packet setting in /etc/my.cnf to something bigger (I think the default is 25MB) and try again.

Dave

turiyain 06-03-2010 07:28 AM
I have changed the same. But it not worked. Kindly guide. I am doing this in Centos 5.3.

ilikejam 06-03-2010 07:31 AM
What did you change it to?

Steviepower 06-05-2010 08:52 AM
usually you need to restart the deamon for the changes to take effect


All times are GMT -5. The time now is 06:00 PM.