How to check and repair a crashed MySQL table
A table can be damaged after a crash or a full disk. Websites then show errors such as "Table './username_shop/wp_options' is marked as crashed and should be repaired". Check & repair checks every table of a database and repairs the damaged ones where possible.
Steps
- Log in to the control panel (
https://<server>:2083). - Open MySQL Databases (section Databases).
- In the Databases list, click Check & repair next to the database.
- Wait for the result. A large database can take a few minutes (up to 5).
Read the result
username_shop: 42 tables checked. No problems found.— everything is fine.… Repaired: wp_options.— the named tables were damaged and are repaired. Reload your website.… Could not be repaired: wp_posts (…). Restore the database from a backup or ask support.— the named table is damaged beyond what the check can fix.
When a table cannot be repaired
- Restore the database from a backup: Backups (section Advanced), choose a copy, and restore only the database.
- If you have your own export, import it into the database instead.
- Otherwise, contact support with the message.
Good to know
- Repair works for MyISAM and Aria tables, the kinds that are marked "crashed". InnoDB tables (the default for WordPress and most modern software) recover by themselves after a crash; when one is really damaged, the check names it and a backup is the way back.
- The check does not change healthy tables or your data.
- A full disk is a common cause. Check Resource Usage and free space first, or the problem can come back.
Common questions
Should I run Check & repair regularly?
No. Run it when a site reports a damaged table or database errors that started suddenly.
Can I repair a table in phpMyAdmin instead?
Yes: select the table, then Operations → Repair table. Check & repair does the same for every table at once.
Thank you — this helps us improve the article.
Still stuck?
Ask the AI about your exact situation — it answers from this knowledge base — or contact us.
Related articles
- How to export a MySQL database (download a .sql backup)
Download a copy of a MySQL database as a .sql file with phpMyAdmin's Export tab or mysqldump over SSH, for backups or moving to another server.
- How to import a MySQL database (.sql file) and size limits
Import a .sql or compressed .sql.gz backup into a MySQL database with phpMyAdmin (up to 512 MB) or the mysql command over SSH for larger files.
- Error establishing a database connection or access denied
Fix "Error establishing a database connection" and MySQL "Access denied for user" errors: wrong name prefix, password, privileges, host or remote access.
- How to create a backup job (schedule automatic backups)
Schedule automatic backups of files, databases and email — from every 15 minutes to monthly — with how many copies to keep and where to store them.