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.
Outstanding Customer Service Everytime I have emailed AYKsolutions I have gotten an outstanding response time from the technical support team. Not only that, they are very friendly and very easy to work with. When I initially setup my account I had a small problem and had to delete everything and start over. This was not a problem for AYK and they were able to get me up and running in no time at all
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'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.