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
B

Bogdan C

iasi, Romania

This is my second time i m using your services, and the main reason i'm doing that, beside your pric...

Read full review
P

Pierre

QC, Canada

My first experience with VPS and I din't really know what to do or what to expect. AykSolutions.com...

Read full review
M

Mathieu L

MD, United States

I love AYK. been with them for over 5 years and the best ever

Read full review
M

Miles S

WA, United States

I had never heard of AYK Solutions before, but they had an awesome deal I couldn't pass up on WHT....

Read full review
ARIN Cisco Supermicro cPanel Intel Microsoft