I have a 2 GB database dump which I am trying to import into mysql. When I run the import, I get the following:
> mysql -u myUser -p < dbDump.sql Warning: option 'max_allowed_packet': unsigned value 104856551424 adjusted to 2147483648 Error 2006 (HY000) at line 2835: MySQL server has gone away
My max_allowed_packet is currently set to
I've googled for this issue and some users reported this issue being fixed by changing the wait_timeout value. The problem is that my dump times out in less than 5 seconds, so I don't think that wait_timeout is the problem.
Any other ideas about why my dump is failing?
[RESOLVED]: At stolsvik's suggestion, I checked the dump file for the contents of line 2835. I found if contained the command set global max_allowed_packet=200 which nullified the larger value I set earlier. I removed the offending line from and now the dump completes successfully.