Unknown storage engine 'InnoDB'

I have this same exact problem…

This just happened to two WordPress websites I’m hosting as a reseller. Both are up-to-date installs of WordPress and are not linked together in any way.. When I exported my database, I received the following errors in the exported .sql file..

— ——————————————————–

—
— Table structure for table wp_options
—
— in use(#1286 – Unknown storage engine ‘InnoDB’)
— in use (#1286 – Unknown storage engine ‘InnoDB’)

— ——————————————————–

—
— Table structure for table wp_postmeta
—
— in use(#1286 – Unknown storage engine ‘InnoDB’)
— in use (#1286 – Unknown storage engine ‘InnoDB’)

— ——————————————————–

—
— Table structure for table wp_posts
—
— in use(#1286 – Unknown storage engine ‘InnoDB’)
— in use (#1286 – Unknown storage engine ‘InnoDB’)

— ——————————————————–

And just to add more info, I ran a repair + optimize on the database.

It came back with a slew of failures like:

Failed to repair the wp_users table. Error: Unknown storage engine ‘InnoDB’

And said to copy and paste this for additional assistance. Why do I feel this doesn’t bode well…

wp_users: Unknown storage engine ‘InnoDB’
wp_usermeta: Unknown storage engine ‘InnoDB’
wp_posts: Unknown storage engine ‘InnoDB’
wp_comments: Unknown storage engine ‘InnoDB’
wp_links: Unknown storage engine ‘InnoDB’
wp_options: Unknown storage engine ‘InnoDB’
wp_postmeta: Unknown storage engine ‘InnoDB’
wp_terms: Unknown storage engine ‘InnoDB’
wp_term_taxonomy: Unknown storage engine ‘InnoDB’
wp_term_relationships: Unknown storage engine ‘InnoDB’
wp_commentmeta: Unknown storage engine ‘InnoDB’

I’ve found some support threads out there for this kind of database error. Someone suggested deleting the InnoDB log files in the mysql data directory (ib_logfile0 and ib_logfile1); this should cause the InnoDB to try and recover after restarting mysqld.

I’m going to give this a go on one of the websites. I’m also trying to contact my web host provider to see if I can get any assistance on that end. I’ll keep everyone updated on any findings or if I find a solution ??

Did your website’s just go down today?? Also who’s your hosting providers?? I’m hosting with HostGator. We should try to determine if this is a WordPress issue or a hosting issue since it’s database related.

Looks like the dns servers are websitewelcome.com – googled it and hostgator?

websitewelcome.com is HostGator! I have a chat window open with them right now. Waiting for them to log on – the wait time is over 30 minutes so I’m assuming that others are probably having the exact same issues that we are.

Hopefully we get a quick resolve. Heatherplude, are you also hosting with HostGator?

hostpossum.com = websitewelcome.com = hostgator.com

GRRRR…

This is definitely a HostGator problem. None of our websites are linked together, nor share the same niches or demographic so that eliminates the possibility of this being the result of a hack or hacker. Also one of the websites that crashed on my end is in production and has no plugins installed so it couldn’t be a plugin, malware, SQL injection issue. Also it seems to be hit and miss across my reseller account. Right now only three or four websites are affected. I’m on the phone with HostGator now waiting on a representative and I still have the live chat window open. I will keep everyone updated ??

I’m having the same issue, hostgator reseller account.
I have a chat open also, stuck at 30 mins.
Let me know if you find out anything.
Thanks guys.

I just got off the phone with Crystal from HostGator. She confirmed that this is the result of a server issue on their end and that they are working on getting it fixed. I asked if there was an ETA on repairing their servers. She said that at this time, there is not. I also asked if there was any chance that anyone would loose data in the affected databases. She was unsure at this time because the extent of the issue is still unmeasured. I asked, “In the worse case scenario and this server crashes and data is lost, does HostGator have backups of the websites and databases to restore lost or damaged websites?” She said that HostGator does perform regular backups and have everything that is currently affected stored safely on a separate server. She also told me that we can monitor their progress by following the HostGator support forms. I’ve provided a link to the thread below.

https://forums.hostgator.com/oct-29-02-00-emergency-maintenance-t328219.html

Their last update is as follows…

Work is on-going at this time, the full resolution being much more time-consuming than we would prefer. Headway is being made however, with a large number of the affected servers having now been returned to normal functionality. Work will continue unabated until a full resolution is achieved. Further updates will be forthcoming.

Great thanks for the update Russ!

Thanks for the update, Russ!

You’re welcome guys! We’ll keep this thread open for now in case any further updates or announcements are made ??

Russ, you’re a legend… I’ve been freaking out about this for the last hour trying to work out if I’d messed up something in a site migration last week!