Resolved Backup Lost connection to MySQL server

[CGI1979]

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?

 

[IgorG]

Looks like database corruption. Check this KB article https://kb.plesk.com/en/128949

 

[CGI1979]

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

 

[CGI1979]

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