Table is marked as crashed and last (automatic?) repair failed – MySQL / MariaDB / Percona

Today we’ll look into repairing a crashed WordPress database table. The error message could appear in one of many ways, some of them below:

A quick look at the error message shows the wp_options table is crashed.

Or it may look something like this in phpMyAdmin if you try to browse the table

phpmyadmin table crash mysql, mariadb, percona

To fix this, simply click on the checkbox next to the name of the table, scroll down and select repair table from the drop down

phpmyadmin repair crashed table mysql, percona, mariadb

 

phpMyAdmin should come back telling you it has successfully repaired the table and that’s it!