Restore a big mysqldump

turiyain · 06-02-2010, 08:34 AM

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