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. Connect to the server 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.