The storage engine for the table doesn’t support repair. InnoDB or MyISAM?

You cannot repair an InnoDB type table, If you want to repair them you’ll have to change the table engine from InnoDB to MyIsam.
To Do this, follow these simple steps
  • Open your phpmyadmin
  • Select the database you want to repair.
  • Look for the table(s) with InnoDB type storage engine and note down their names.
  • Now you need to perform an SQL command by clicking on the SQL tab that appears on the top section of that page.
  • Now use the command given below
  • Replace the table_name with the name of the table you want to change from InnoDB to MyISAM.
Note: You will have to do the table change one by one. For each time, chose one table and change its engine and so on.

Leave a Comment

Your email address will not be published. Required fields are marked *

Open chat