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.
AYK provide a very good value product, and always in a professional manner. I have used several hosting companies over the past 17 years. During that time I occasionally needed help with a variety of minor setup issues. Only AYK gave quick and helpful answers. I highly recommend them.
I have had my hosting with AYK since 2006, and it has by far been the best experience I have ever had with any hosting company. The support is always spot on and available around the clock, excellent for me since I'm always working on things at odd hours. They make upgrading to fit needs very clean and easy, the cost is excellent for services received, and they have me as a customer for life.
Thanks for the fast sollution, it was my fault since my original e-mail got somehow bugged and I didn't got the invoice mails.
© 2004 - 2024 AYKsolutions, LLC. All Rights Reserved.
