crashed mySQL - won't start

A power outage took down a server hard. Unfortunately, trying to restore backup's to 7.x servers are not working for some reason. They restore but not really.

Log files indicated the following: 160906 3:25:56 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Error: trying to add tablespace 2 of name './thecorkandtap/wp_formmaker_backup.ibd'
InnoDB: to the tablespace memory cache, but tablespace
InnoDB: 2 of name './bigbear2/omeka_csv_import_imported_items.ibd' already exists in the tablespace
InnoDB: memory cache!InnoDB: Error: trying to add tablespace 32250 of name to the tablespace memory cache, but tablespace

We have about 60+ websites on the machine. Ouch. "innodb_force_recovery=" 1 to 3 have not worked Not sure where to go from here.

Status: 
Active

Comments

Howdy -- I'm looking into ways to handle that.

As a way to get the service back online, you could always try moving the /var/lib/mysql/thecorkandtap directory elsewhere, and then restarting MySQL.

That might just get it online, minus the one database.

At that point, if you have a backup, you could always try restoring a backup of that particular site.

Good grief. I looked in all the wrong places. It was a shortage of space in the var/cache/ directory. I deleted a few log files and everything was back to normal. I should have learned the first time that happened to me. Thanks for the advice as always.

Oh nuts! Yeah I didn't consider that either. Glad to hear it's working now!