Recovering INNODB - corrupt Gallery db?
|
billc108
Joined: 2009-10-09
Posts: 8 |
Posted: Mon, 2009-10-12 04:31
|
|
Hey folks, I'm in semi-crisis mode. Our server which was running three Gallery databases has experienced some problems with MySQL; our backups were daily direct copies of the MySQL data directory (unfortunately, i've learned since that db files stored in INNODB format instead of MYISAM format can't be restored easily - or maybe not at all - that way). Fortunately, only one of those three Gallery installs is for a paying client, and though they'd like it back it's not absolutely mission critical. BUT I'd like to figure out how to retrieve the data if at all possible. As I mentioned in an earlier post, I've got a bunch of .frm files, but the associated tables aren't showing up on the new MySQL server. The only tables I'm seeing are the two which have .MYI and .MYD files as well. I'm assuming all the rest are in INNODB format. The Gallery data files are still in place, as they were on a separate server. I've tried a fresh install of Gallery followed by replacing the .frm files, but that's not doing a thing from what I can see. Any suggestions welcome. |
|
Posts: 8
Whew. I got it sorted out.
I was able to eventually get the original mysql server to come up, so I was able to export the problem dbs.
Note for those of you who don't already know it: Be sure that you use mysqldump or similar to back up your database, or you may not be able to recover it.