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 is thee best hosting solution I have found in 10 years of searching. I'm very grateful of the services they provide. Such a vast variety to host whatever you desire at a great rate. The support team has always been great, always get a reply within 4 Hours of posting, usually way before 4H. I have a range of 1-10gbit machines and they've always kept up with premium standards. Networks they sell are premium, guaranteed. Thank you, AYK :)
This is my second time i m using your services, and the main reason i'm doing that, beside your prices is your customer support. I love the fact that you are fast, you always help me and never get bothered by my endless questions(i'm still a newbie when it comes to server setup) Thank you