Migration/backup failed: mysqldump: Got error: 145

Refers to:

  • Plesk Onyx for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:01:51 UTC

Modified:

2016-12-21 19:47:27 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Migration/backup failed: mysqldump: Got error: 145

Symptoms

Plesk full backup task got failed with an error in %plesk_dir%/PMM/sessions/<timestamp>/migration.result file:

<execution-result status="error" log-location="/usr/local/psa/PMM/sessions/<timestamp>/migration.result">
<object name="019" type="client">
<object name="domain.tld" type="domain">
<object name="db_name" type="mysql">
<message id="dddba294-8e17-4d09-88c2-939270aef116" severity="error
<description>Failed to execute backup of mysql database &#39;lap
</message>
<message id="78afa08d-35e6-464a-8d7a-88c7ffdf69c7" severity="error
<description>Failed to pack files backup_database_1_1401080148 i
412864 bytes free of 492248408064 bytes total on mount point 0]</description

Manual backup of domain's database results in error:

# mysqldump -u admin -p`cat /etc/psa/.psa.shadow` db_name > db_name_backup.sql
mysqldump: Got error: 145: Table './db_name/toc_whos_online' is marked as crashed and should be repaired when using LOCK TABLES

Or

The following error appears during a migration process:

WARNING:      (mysql object 'db_name')      Not all the data was backed up into /var/cache/<timestamp>/clients/ccia/domains/domain.tld/databases/db_name_1 successfully. Use of chdir('') or chdir(undef) as chdir() is deprecated at Storage/Bundle.pm line 39, <STDIN> line 5.
mysqldump: Got error: 145: Table './db_name/Logs' is marked as crashed and should be repaired when using LOCK TABLES

Cause

Database table corruption.

Resolution

Recover the corrupted database table:

# mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` -r database_name table_name

OR

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> USE <databasename>
mysql> REPAIR TABLE <tablename>;
Have more questions? Submit a request
Please sign in to leave a comment.