How to Check and Repair Database Tables in Plesk

Database tables can become corrupted after a server crash, unexpected shutdown, or disk issue. Plesk has a built-in tool to check and repair MySQL/MariaDB tables without needing command-line access.

Using the built-in Check and Repair tool

1. Log in to your Plesk control panel.
2. Go to Websites & Domains > Databases.
3. Find the database you want to check.
4. Click Check and Repair in the database tools area.
5. Plesk will scan all tables. If everything is fine, you'll see a confirmation that no problems were found.
6. If problems are found, click See Details and Resolve.
7. You'll see a list of affected tables. Select the tables you want to fix.
8. Click Repair Selected.

Plesk uses the mysqlcheck utility behind the scenes, so this is the same as running a repair from the command line.

Using phpMyAdmin

If you prefer more control, you can check and repair tables through phpMyAdmin:

1. Go to Websites & Domains > Databases.
2. Click phpMyAdmin next to your database.
3. Select your database from the left sidebar.
4. At the bottom of the table list, click Check All to select every table.
5. From the With selected dropdown, choose Check table and click Go.
6. Review the results — look for any status other than OK.
7. To repair: select the problem tables (or all), choose Repair table from the dropdown, and click Go.

Important notes

• Back up your database first. Always export a dump before running repairs — a repair on a severely damaged table could result in data loss.
• The Check and Repair tool works with MySQL and MariaDB databases. InnoDB tables may report as "doesn't support repair" — this is normal, as InnoDB has its own crash recovery.
• If you see "Table is marked as crashed and should be repaired" errors on your website, this tool is exactly what you need.

Troubleshooting

• Repair says OK but site still has errors? The issue may be with your application code or configuration, not the database tables. Check your CMS error logs.
• Table won't repair? Severely corrupted tables may need to be restored from a backup. Export what you can, drop the table, and import your backup.
• Check and Repair option missing? This tool only appears for MySQL/MariaDB databases. PostgreSQL databases use different repair methods.