Claim your Biolink Click Here
1 like 0 dislike
2.3k 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 (830 points) | 2.3k 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 (1.1k 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

1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked Aug 9, 2013 in Education & Reference by Jatin | 631 views
0 like 0 dislike
3 answers
asked Jan 20, 2014 in Education & Reference by Sam (1.6k points) | 1.9k views
1 like 0 dislike
1 answer
2 like 0 dislike
1 answer
1 like 0 dislike
1 answer
0 like 0 dislike
1 answer
asked May 26, 2015 in Education & Reference by Simmi (830 points) | 438 views

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,308 questions
1,469 answers
568 comments
4,809 users