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.
Great Service I was using a dedicated server with AYK for about 6 months untill i sold my website. Their support is outstanding they reply very quickly and helpful. If i ever want another dedicated server i will 100% choose AYK.
Great prices and service! Truly is painless, professional and polite (That's their slogan).
Ayksolutions Customer Reviews Prompt, professional, efficient. I am currently using a shared account and plan on upgrading to a dedicated server...eventually when traffic picks up. The Ayk team is quick to reply to any concerns and does the best they can to correct the situation. I strongly recommend them for hosting.
© 2004 - 2025 AYKsolutions, LLC. All Rights Reserved.
