1 like 0 dislike
1.8k views

After repairing table of one of my database I have received the following error:

The storage engine for the table doesn't support repair

in Education & Reference by (620 points) | 1.8k views

1 Answer

0 like 0 dislike

First is you have to understand the difference between MyISAM and InnoDB Engines

 

  • The big difference between MySQL Table Type MyISAM and InnoDB is that InnoDB supports transaction

Most people use MyISAM if they need speed and InnoDB for data integrity. You can use more than one or any combination of these table types in your database. 

You can use this sql statement if you want to convert InnoDB to MyISAM:
 ALTER TABLE table_one ENGINE=MyISAM;

by (820 points)
0 0
They are most probably InnoDB tables, InnoDB tables don't require and/or can't be repaired with the repair function.
Only MyISAM tables can be,

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Aug 8, 2013 in Education & Reference by Jatin | 486 views
0 like 0 dislike
3 answers
asked Jan 20, 2014 in Education & Reference by Sam (1.4k points) | 445 views
0 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked May 25, 2015 in Education & Reference by Simmi (620 points) | 138 views
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer

Where your donation goes
Technology: We will utilize your donation for development, server maintenance and bandwidth management, etc for our site.

Employee and Projects: We have only 15 employees. They are involved in a wide sort of project works. Your valuable donation will definitely boost their work efficiency.

How can I earn points?
Awarded a Best Answer 10 points
Answer questions 10 points
Asking Question -20 points

1,225 questions
1,370 answers
559 comments
2,099 users