Allows you to search a variety of questions and answers
If you are getting the following error when trying to dump a large mysql database:
mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table XXX
Then try using the --opt flag and save to a .sql.gz file to reduce the IO and the buffering.
Example command would be something like:
mysqldump --opt --quick --max_allowed_packet=1G -h *host* -u *User* -p*Passwort* *database* | gzip > /path/to/sql.gz
That should fix the issue.
Additionally, you can try to the following in /etc/my.cnf:
1. Raise the max packet value to 100M or higher.
2. Comment out timeout value if it's enabled.
Don't forget to restart the MySQL server.
I very seldom contact support, but if I do, the response is always prompt and issues are always resolved.
AYK Solutions offers unmatched top tier support. They have gone above and beyond time and time again. They are very pompt, highly knowlegeable and curtious. I have been using AYK for 4 years now and yup its easy to say they have earned a customer for life. Thank you so much for helping me and business excell. Regards, Johnny
Great prices and service! Truly is painless, professional and polite (That's their slogan).
© 2004 - 2025 AYKsolutions, LLC. All Rights Reserved.
