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
    ALTER TABLE table_name ENGINE=MyISAM;
  • 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.

Comments

Popular posts from this blog

cpanel exam CPSP Answers

How to install zimbra collaboration suite 8.8.11 on CentOS 7

awstats installation