MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: ERROR 1153: Got a packet bigger than 'max_allowed_packet' bytes
Posted by: Dan Tasse
Date: July 17, 2007 02:01PM

I had the same problem, with an 8gb .sql file. I didn't have any luck with --max_allowed_packet; it seems like it didn't do anything. I just opened two terminals, connected to mysql on one, set the following:
set global max_allowed_packet=1000000000;
set global net_buffer_length=1000000;
and then ran:
mysql -p < sqldump.sql
from the other terminal.

Navigate: Previous Message• Next Message
Options: Reply• Quote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.