New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Import 50GB database - ERROR 2006 (HY000) at line 20633: MySQL server has gone away
SO i am importing mysql database and always get ERROR 2006 (HY000) at line 20633: MySQL server has gone away on 24GB processed how can i fully import it??
i tried import with --max_allowed_packet=1073741824, but no luck either ....
mysql -u root -p db < db.sql
Comments
Have you tried to do a "LOAD DATA INFILE"? What's your wait_timeout set to?
Split it and then import it, I had a similar issue recently and that is what I ended up doing.
max_allowed_packet = 23536587696776
wait_timeout = 6000000000000000000
Importing once again since i had defined two times max_allowed_packet, once as max_allowed_packet=16M and second as 23536587696776
The split could be an option too, will try that thx
Failing that, check your error logs.
interactive_timeout?
Maybe use something like this: ozerov.de/bigdump/
Also check memory usage. I've seen some cases when I'm importing large data and memory usage burst to maximum before MySQL being killed.
MySQL has gone away also hints the daemon is getting interrupted possible due to memory error, so yes checking logs would be good to trace the problem
no one reads official mysql documentation and manuals ? https://dev.mysql.com/doc/refman/5.7/en/gone-away.html