Database Error 1194: Table ‘corrupted_table’ is marked as crashed and should be repaired

Symptoms

• Migration fails with the following error message

  Failed to copy content of database 'example_db'
  Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (203.0.113.2) with non-zero exit code.
  command: MYSQL_PWD="$(cat)" mysqldump --no-defaults -h localhost -P 3306 -uadmin --quick --quote-names --add-drop-table --default-character-set=utf8 --set-charset --routines --events example_db > /root/plesk_migrator/plesk_migrator-r16sv8axxsp6i463ejn5fnus2vsold2m/db-dumps/example_db.sql
  exit code: 3
  stdout:
  stderr: mysqldump: Error 1194: Table 'corrupted_table' is marked as crashed and should be repaired when dumping table `corrupted_table` at row: 8093873

• Backup operations fail

  Unable to create the remote backup: boost::filesystem::file_size: No such file or directory: "/tmp/pmm-de-tmp-repo-nlcOnM/clients/tempebdm/domains/tempestfansub.com/backup_apache-files_2108250416.tgz"

Cause

Corrupted table in the domain's database.

Resolution

1. Log in via SSH (to the source server, in case of migration)

2. Repair the corrupted table mentioned in the error

   • For Plesk on Linux servers:

     # mysql -uadmin -p$(cat /etc/psa/.psa.shadow) -Ne 'REPAIR TABLE example_db.corrupted_table'

   • For non-Plesk servers:

     # mysql -uroot -p -Ne 'REPAIR TABLE example_db.corrupted_table'

3. Sync or try to back up again.