Results 1 to 2 of 2
Thread: restoring huge database
May 20, 2004, 16:23 #1
restoring huge database
I have a 600mb sql file, trying to restore through command line and I get this error after a minute:
ERROR 1153 at line 339011: Got a packet bigger than 'max_allowed_packet'
we with it has to do with a binary field, I dunno, anyone see this before?Free Science Homework Help
May 25, 2004, 06:38 #2
Originally Posted by dethfire
- Join Date
- May 2004
- Stockholm Sweden
- 0 Post(s)
- 0 Thread(s)
mysql> SET max_allowed_packet = xxx;
If you have used the mysql extended insert format (mysqldump -e) then this problem gets more common since mysql considers everything up until the ending ';' to be one statement for good and bad.
So if you got the memory for it change the max_allowed_packet while you are restoring the file. This will usually suffice but if not you will have to break the extended format into several inserts instead or if you have the ability to redo the dump but without using the extended insert format.