PDA

View Full Version : Error 1153 during restore



thewatchdesk
Sat 17th Jun '06, 12:08am
I recieved the following error during after following the failsafe restore directions :) mysql -u db_user -p db_name < path/to/dump.sql

Error 1153 at line 334: got a packet bigger than 'max allowed packet'

Any ideas what I need to tell my provider to fix this or what I am doing wrong?

DB size and permissions

4976007 k0644

the server is set up as follows

General server information:
Operating system Linux
Service Status
Kernel version2.4.26
Machine Typei686
Apache version1.3.36 (Unix)
PERL version5.6.1
PHP version4.4.2
MySQL version4.0.25-standard
cPanel Build10.8.2-
EDGE 6ThemecPanel X v2.5.0
cPanel Pro0.9.9.2 (RC8)

Zachery
Sat 17th Jun '06, 12:28am
You need to ask your host to set a large max_allowed_packet in the my.cnf file and restart the mysql server.

thewatchdesk
Sat 17th Jun '06, 12:36am
Thanks for the quick reply.