BLACK FRIDAY DEALS

Knowledge Base

Allows you to search a variety of questions and answers

Search

Search results

MySQL

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.

 

See What Our Customers Say

Leave review
J

Johnny

NC, United States

Hi Guys and Gals, I'll just say you all are top notch and go above and behind with support. I'v...

Read full review
S

Soren

Without doubt the most professional and friendly support team i have ever experienced. These guys ar...

Read full review
S

seoSpaceship.com

NC, United States

AYK Solutions offers unmatched top tier support. They have gone above and beyond time and time agai...

Read full review
J

James

FL, United States

I have been using AYK for about 2 years now and they are always on top of any issues I have. They ha...

Read full review
ARIN Cisco Supermicro cPanel Intel Microsoft