Problems when repairing or doing any task in my database with phpmyadmin
- Thread starter vtr
- Start date
MySiteGuy
Well-known member
A MySQL "repair table" query is not supported by Innodb table types. It works with MyISAM and Aria table types.
Innodb is better hardened against corruption, and the database engine attempts minor repairs automatically if you restart it. When this doesn't work, copying the table into another, deleting it and renaming the new table to the old table's name will usually work. Backup before you do this. If either of these methods fail, Innodb recovery mode needs to be set in your my.cnf file and the database software restarted.
See:
Innodb is better hardened against corruption, and the database engine attempts minor repairs automatically if you restart it. When this doesn't work, copying the table into another, deleting it and renaming the new table to the old table's name will usually work. Backup before you do this. If either of these methods fail, Innodb recovery mode needs to be set in your my.cnf file and the database software restarted.
See:
