• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Resolved Backup Lost connection to MySQL server

CGI1979

Basic Pleskian
Backup on Plesk 12.5 loses connection to mysql every night, always with different databases.

Not all the data was backed up into /var/lib/psa/dumps/clients/domains/domain.de/databases/ successfully. mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `artikel` at row: 414

How can I debug and solve this problem?
 
Thanks for you quick reply.

This works for the database:
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` --skip-extended-insert db > db.sql`date +%F.%s`.sql

This one says "OK" as well:
mysqlcheck -c db table_name -uadmin -p`cat /etc/psa/.psa.shadow`

We use automysqlbackup on that system, the dump is successful every time:
-- Dump completed on 2016-09-22 3:56:49
 
I have the same problem. mysqlcheck says ok for the table. automysqlbackup runs seamlessly.
How can this be debugged?

Not all the data was backed up into /var/lib/psa/dumps/domains/domainname/databases/dbname_1 successfully. mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `tablename` at row: 84851
 
Back
Top