SQL database recovery?

[91BRG]

Anyone had success with a software package that can salvage a corrupt SQL database? Bonus question: on Mac OSX? Ask me about my website...

[thebeerbaron]

which SQL, how did you corrupt it, and so forth?

no direct experience with this on a Mac (though I use them personally), but in theory I know how to deal with our postgres database on linux...

[91BRG]

MySQL and don't know what happened, drive appeared to suffer hardware failure. Backup wasn't online (long angry story) so recovered what we could but I don't have all the info. One of my IT guys is working on it and hasn't gotten back to me with anything other than "SQL database has terrible corruption"... Running on an Apple XServe with 10.6.8 Server. This, of course, happened while I was at a conference on the other side of the country.

[mroadsters]

Uh, totally sucks. I can recommend a drive recovery service if you need one...

[91BRG]

Uh, totally sucks. I can recommend a drive recovery service if you need one...

That's the next step. I have an ooooold version that will have to go up if nothing else works and then we can look at more expensive options.

[91BRG]

MySQL Error #130 Incorrect File Format for many of the files...

[thebeerbaron]

yeah, doesn't sound like a SQL problem, sounds like a disk problem. I'd be worried that drive recovery won't help since you've already mounted the filesystem - IANA drive recovery expert, but I'd think that any disk check/fix that ran blew away any chances of recovering your data...

good luck, and for the love of god, get your important data on a RAID array (or better yet, two!).

[91BRG]

yeah, doesn't sound like a SQL problem, sounds like a disk problem. I'd be worried that drive recovery won't help since you've already mounted the filesystem - IANA drive recovery expert, but I'd think that any disk check/fix that ran blew away any chances of recovering your data...

good luck, and for the love of god, get your important data on a RAID array (or better yet, two!).

I made the mistake of taking the word of an IT staffer that we had full time server backup to their core recovery system - something only they could setup. When this happened I found out "oh, we never set that up". I've made up some new swear words. New RAID going in today and adding cloud backup as well.

[mroadsters]

Bummer. I've been called in on more then a few jobs after it was already too late. And I always charge a lot more if someone else has already mucked with it.

Good luck!

[91BRG]

This may be the time when we wipe the server and start over... New RAID is in and there seem to be other problems with permissions and I'm dealing with legacy creations from several years of different hands mucking about anyway, so a fresh start might be the best thing - except for the whole losing the website database part

[mroadsters]

You're running WordPress aren't you? Should have been a piece of cake to get going again. And there isn't a single usable backup? That person wouldn't be working for me anymore...

[91BRG]

You're running WordPress aren't you? Should have been a piece of cake to get going again. And there isn't a single usable backup? That person wouldn't be working for me anymore...

June 2011 version works... If the person who was supposed to set up the backup actually worked for me I'd be able to make a bigger stink. Actually, the original guy that assured me it was set up doesn't work here any more. The good news is that the guy that's helping me fix things IS able to make a big stink and WILL get it set up correctly.

Next few days will be spent trying to pick the discombobulated bits for the newer data. The critical audio and graphic files survived, but the database of posts and such appears to be toast. For now a mangled 2011 version is up. Much more to do sadly. Lesson, I didn't need, learned.

[mroadsters]

I'd check the Internet Wayback Machine to see if they have any cached pages that might be helpful to recover. Let me know if you need any of the Ana Popovic shots again...

[91BRG]

I'd check the Internet Wayback Machine to see if they have any cached pages that might be helpful to recover. Let me know if you need any of the Ana Popovic shots again...

BTDT nope. For some reason it hasn't cached our page in quite awhile. Actually I was hoping to get one of your Ana shots for the art auction on Friday...

[mroadsters]

Which one? http://portfolio.marcsiegelphoto.com/ph ... Key=82ck87

[91BRG]

1st, 3rd and/or last ones.
thread drift complete