Title: Unknown storage engine 'InnoDB' Last modified: August 22, 2016 --- # Unknown storage engine 'InnoDB' * Resolved [R. K. Bentley](https://wordpress.org/support/users/rkbentley/) * (@rkbentley) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/) * Hi guys, * First time posting so bear with me. * I installed WP 4.0 for a client about 3 weeks back and everything was smooth sailing until this morning when we starting getting 500/501/502/504 errors. * MySQL was down for a time and then it came back up. * I tried the website and it said there might be a database problem. * Logged into MySQL and ran a repair and got this: * [authors_wrdp2.wp_commentmeta] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2. wp_commentmeta] error: Corrupt [authors_wrdp2.wp_comments] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2.wp_comments] error: Corrupt [authors_wrdp2.wp_links] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2.wp_links] error: Corrupt[ authors_wrdp2.wp_options] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2. wp_options] error: Corrupt [authors_wrdp2.wp_postmeta] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2.wp_postmeta] error: Corrupt [authors_wrdp2.wp_posts] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2.wp_posts] error: Corrupt[ authors_wrdp2.wp_statpress] status: OK [authors_wrdp2.wp_term_relationships] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2.wp_term_relationships] error: Corrupt [authors_wrdp2.wp_term_taxonomy] Error: Unknown storage engine‘ InnoDB’ [authors_wrdp2.wp_term_taxonomy] error: Corrupt [authors_wrdp2.wp_terms] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2.wp_terms] error: Corrupt[ authors_wrdp2.wp_usermeta] Error: Unknown storage engine ‘InnoDB’ [authors_wrdp2. wp_usermeta] error: Corrupt [authors_wrdp2.wp_users] Error: Unknown storage engine‘ InnoDB’ [authors_wrdp2.wp_users] error: Corrupt * I went to /wp-admin and it’s asking me to install WP again, went through the steps and gives me this long laundry list of error messages that begins like this: * WordPress database error: [Unknown storage engine ‘InnoDB’] CREATE TABLE wp_users( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default ”, user_pass varchar(64) NOT NULL default ”, user_nicename varchar(50) NOT NULL default ”, user_email varchar(100) NOT NULL default ”, user_url varchar( 100) NOT NULL default ”, user_registered datetime NOT NULL default ‘0000-00-00 00:00:00’, user_activation_key varchar(60) NOT NULL default ”, user_status int( 11) NOT NULL default ‘0’, display_name varchar(250) NOT NULL default ”, PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8 * It gets to the end and says: here’s your username and click continue and it loops thru the install. * You can see it over [here](http://www.riauthors.org/wp-admin) * Any way to save the database or am I starting from scratch? * Thanks for the help! Viewing 15 replies - 1 through 15 (of 27 total) 1 [2](https://wordpress.org/support/topic/unknown-storage-engine-innodb/page/2/?output_format=md) [→](https://wordpress.org/support/topic/unknown-storage-engine-innodb/page/2/?output_format=md) * [heatherplude](https://wordpress.org/support/users/heatherplude/) * (@heatherplude) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433395) * I have this same exact problem… * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433399) * 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’) * — ——————————————————– * Thread Starter [R. K. Bentley](https://wordpress.org/support/users/rkbentley/) * (@rkbentley) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433405) * 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’ * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433407) * 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 🙂 * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433411) * 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. * Thread Starter [R. K. Bentley](https://wordpress.org/support/users/rkbentley/) * (@rkbentley) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433415) * Looks like the dns servers are websitewelcome.com – googled it and hostgator? * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433417) * 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? * [heatherplude](https://wordpress.org/support/users/heatherplude/) * (@heatherplude) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433418) * hostpossum.com = websitewelcome.com = hostgator.com * GRRRR… * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433421) * 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 🙂 * [deanmgordon](https://wordpress.org/support/users/deanmgordon/) * (@deanmgordon) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433425) * 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. * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433431) * 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. * [http://forums.hostgator.com/oct-29-02-00-emergency-maintenance-t328219.html](http://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. * [deanmgordon](https://wordpress.org/support/users/deanmgordon/) * (@deanmgordon) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433434) * Great thanks for the update Russ! * Thread Starter [R. K. Bentley](https://wordpress.org/support/users/rkbentley/) * (@rkbentley) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433437) * Thanks for the update, Russ! * [Russ Powers](https://wordpress.org/support/users/russwebguy/) * (@russwebguy) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433440) * You’re welcome guys! We’ll keep this thread open for now in case any further updates or announcements are made 🙂 * [eclaire](https://wordpress.org/support/users/eclaire/) * (@eclaire) * [11 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/#post-5433461) * 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! Viewing 15 replies - 1 through 15 (of 27 total) 1 [2](https://wordpress.org/support/topic/unknown-storage-engine-innodb/page/2/?output_format=md) [→](https://wordpress.org/support/topic/unknown-storage-engine-innodb/page/2/?output_format=md) The topic ‘Unknown storage engine 'InnoDB'’ is closed to new replies. ## Tags * [InnoDB](https://wordpress.org/support/topic-tag/innodb/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 27 replies * 10 participants * Last reply from: [Upendra540](https://wordpress.org/support/users/upendra540/) * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/unknown-storage-engine-innodb/page/2/#post-5433874) * Status: resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics