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.
AYKsolutions - best solution for small/high business I have several plans with them and i can sleep well because their team watch over my servers. I started with a small shared account and now, after two years i have multiple dedicated boxes. I like the way they treat their customers, even if they have a small or a big plan. Their tehnical support is the best i ever meet ( worked with many hosting pro viders ). In one word: If you need cheap and no headache for your internet bussiness, AYKsolutions it's your best choice
I have been with ayksolutions for around 5 years and have been thoroughly impressed with them. All support tickets are answered within minutes, regardless of the time of day. Prices are very reasonable, especially considering the support and services they provide. They are constantly doing crazy deals for servers as well. If you're looking for someone good and reliable to host with, from shared hosting to dedicated servers, I easily recommend ayksolutions.
© 2004 - 2025 AYKsolutions, LLC. All Rights Reserved.
