[Fix] WordPress Database table doesn’t support repair Error

Welcome To My Website Today I Will Tell You About [Fix] WordPress Database table doesn’t support repair Error

The other day I noticed that my WordPress site (bonusproducts) started responding slow and at times it was giving error connecting database issue. At many instance it was giving me following error “Connection lost. Saving has been disabled until you’re reconnected. We’re backing up this post in your browser, just in case.” while writing a blog post.

It was unusual, as my traffic was consistent and there was n change in server configuration. For the first few time I simply ignored this issue and today I ran into another issue with comment moderation. Even after accepting or trashing the comments, it was re-appearing.

With that I was sure something is wrong with the database and I thought of repairing my database. Instead of using WP DB-manager plugin or WP-optimize plugin, I straight away used PHPMyAdmin to repair and optimise my database.

For the first time . Here is what error message looked like:

Notice the “The storage engine for the table doesn’t support repair” and when I checked my WordPress database overhead, I was stunned as overhead size was about 5320GiB.

I straight away Pinged my hosting support team but they couldn’t any help as this was an issue with database and not the hosting. So I started searching for a solution to this issue and finally I figured out what could be done to fix error “The storage engine for the table doesn’t support repair“.

Convert InnoDB MySQL Engine to MyISAM – SQL Query

I researched about the issue and understood that InnoDB and MyISAM are two popular MySQL Engine. MyISAM is the one which supports mysqlcheck’s repair feature. InnoDB engine is recommended for busy database but in this case I was facing issues with excessive database overhead, so I decided to move my tables back to MyISAM engine.

If you are also facing the similar issue, the solution is to convert the InnoDB to MyISAM engine. Here I’m sharing the SQL query which you need to run to convert the tables one by one.

Replace table name with your database table name which you want to be converted into MyISAM. After repeating that for all the tables, do repair and optimise your database.

For me, this fixed my problem of WordPress database. If you ever run into similar kind of situation, this would help you.  Don’t forget to take your database backup before running any SQL query.

admin

Tanmay arora is the cheif seo expert and the founder of "bonusproducts". He has a very deep interest in all technology topics whatsover.His passion,dedication and quick decision making ability make him stand apart from other

3 thoughts on “[Fix] WordPress Database table doesn’t support repair Error

  • August 29, 2017 at 12:46 pm
    Permalink

    Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why throw away your intelligence on just posting videos to your weblog when you could be giving us something enlightening to read?|

    Reply
  • August 30, 2017 at 1:39 pm
    Permalink

    I’m no longer sure where you are getting your info, but good topic. I must spend a while studying much more or understanding more. Thanks for great info I was searching for this info for my mission.|

    Reply
  • August 31, 2017 at 10:51 am
    Permalink

    I don’t even understand how I finished up here, however I believed this put up used to be great. I do not understand who you might be however certainly you are going to a famous blogger for those who aren’t already. Cheers!|

    Reply

Leave a Reply

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