-   Linux - Server (
-   -   Restore a big mysqldump (

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


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


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 01:19 AM.