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.
I had never heard of AYK Solutions before, but they had an awesome deal I couldn't pass up on WHT. So far the service has been exceptional, and the server is rock solid. I'll be moving my other servers here soon!
Hi Guys and Gals, I'll just say you all are top notch and go above and behind with support. I've tested many other companies none compare to the expertise you all. Previously I would just get a ticked bumped up to a higher level of tier support etc. with AYK everyone is knowledgeable and prompt. Thank you for offering a premium hosting solution. Warm Regards, Johnny
I've been a client of AYK Solutions for about six months now. They have provided the best overall experience I have had in over 10 years. I've tried iWeb, SingleHop, and a few others supposed to be the so-called best. Specifically, you are dealing with personal, professionals with AYK Solutions, and they are willing to help when all others want to charge you $** for this and $**/hr for that. I'm happy, and have no plans of going anywhere else; ever.