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.
Very courteous, professional, and willing to help. They truly care about client based relationships and satisfaction. I will definitely refer more clients their way, and highly recommend Ayksolutions to anyone seeking truly the best.
Great response time and excellent service. I've been with AYK for nearly a year now and I couldn't be happier. If you're ready to make the step up from budget hosting to someone that can still work with you to spec out a server for your needs at an extremely competitive price, shoot these guys an email and see what they have available. You will not regret it. With datacenters located all ove r the globe they're certain to have something for you.. or they'll just build it
I have been using AYK for about 2 years now and they are always on top of any issues I have. They have gone over and beyond helping me with any problems that come up with the server and they have never said "no" to any of my requests. I would definitely recommend them to anyone looking for a reliable server company.
© 2004 - 2026 AYKsolutions, LLC. All Rights Reserved.
