MySQL table repair tip "The storage engine for the table doesn't support re...

Little scum · Posted on 2/23/2018 10:16:04 AM

The storage engine for the table doesn't support c...

As shown in the figure above, using phpmyadmin to "check the table" found that many tables have errors.

Check whether the mysql table is corrupted, repaired, or optimized
http://www.itsvse.com/thread-4250-1-1.html
(Source: Architect)

When MySQL repairs a table, it prompts: "The storage engine for the table doesn't support repair"

First look at what the index table is,Only MyISAM can fix it directlyIf it is not MyISAM, you need to change the index of the table to fix it.

The repair steps are as follows, we take "pre_common_process." For example:

Step 1: Export the pre_common_process table as follows:

Login is visible.

Step 2: Use phpmyadmin to delete the pre_common_process table directly.

Step 3:Change ENGINE=MEMORY to ENGINE=MyISAMAs follows:

Login is visible.

Step 4: Click SQL on phpmyadmin, copy and paste the above sql statement and execute it!

We check the table again as shown below:

[Source] MySQL table repair tip "The storage engine for the table doesn't support re...

Related Posts

Sections viewed