SQL database recovery?

Blah.. Blah.. Blah..

SQL database recovery?

Postby 91BRG » April 23rd, 2012, 11:17 am

Anyone had success with a software package that can salvage a corrupt SQL database? Bonus question: on Mac OSX? Ask me about my website...
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby thebeerbaron » April 23rd, 2012, 11:31 am

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...
Black 94C with the "track-ish" package.

Buy "my" beer!
User avatar
thebeerbaron
Consultant
 
Posts: 2653
Joined: March 5th, 2005, 1:19 am
Location: Simi Valley, CA

Re: SQL database recovery?

Postby 91BRG » April 23rd, 2012, 11:38 am

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.
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby mroadsters » April 23rd, 2012, 11:49 am

Uh, totally sucks. I can recommend a drive recovery service if you need one...
--
'03 LS
User avatar
mroadsters
Contributing Member
 
Posts: 467
Joined: September 5th, 2008, 8:40 pm
Location: Towson

Re: SQL database recovery?

Postby 91BRG » April 23rd, 2012, 11:53 am

mroadsters wrote: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.
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby 91BRG » April 23rd, 2012, 12:00 pm

MySQL Error #130 Incorrect File Format for many of the files...
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby thebeerbaron » April 23rd, 2012, 12:35 pm

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!).
Black 94C with the "track-ish" package.

Buy "my" beer!
User avatar
thebeerbaron
Consultant
 
Posts: 2653
Joined: March 5th, 2005, 1:19 am
Location: Simi Valley, CA

Re: SQL database recovery?

Postby 91BRG » April 23rd, 2012, 12:53 pm

thebeerbaron wrote: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.
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby mroadsters » April 23rd, 2012, 1:37 pm

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!
--
'03 LS
User avatar
mroadsters
Contributing Member
 
Posts: 467
Joined: September 5th, 2008, 8:40 pm
Location: Towson

Re: SQL database recovery?

Postby 91BRG » April 23rd, 2012, 2:02 pm

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 :cry:
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby mroadsters » April 23rd, 2012, 4:43 pm

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...
--
'03 LS
User avatar
mroadsters
Contributing Member
 
Posts: 467
Joined: September 5th, 2008, 8:40 pm
Location: Towson

Re: SQL database recovery?

Postby 91BRG » April 23rd, 2012, 4:55 pm

mroadsters wrote: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.
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby mroadsters » April 24th, 2012, 9:02 am

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...
--
'03 LS
User avatar
mroadsters
Contributing Member
 
Posts: 467
Joined: September 5th, 2008, 8:40 pm
Location: Towson

Re: SQL database recovery?

Postby 91BRG » April 24th, 2012, 10:54 am

mroadsters wrote: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... :)
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon

Re: SQL database recovery?

Postby mroadsters » April 24th, 2012, 11:17 am

--
'03 LS
User avatar
mroadsters
Contributing Member
 
Posts: 467
Joined: September 5th, 2008, 8:40 pm
Location: Towson

Re: SQL database recovery?

Postby 91BRG » April 24th, 2012, 12:08 pm

1st, 3rd and/or last ones.
thread drift complete :)
--------------------------------------------
John - 1991 BRG SE #2042, born 02/05/91, 11:30 am + '05 Lotus Elise seats
User avatar
91BRG
Contributing Member
 
Posts: 2773
Joined: February 12th, 2009, 12:14 am
Location: Bawlmer, Hon


Return to Banter

Who is online

Users browsing this forum: No registered users and 0 guests

cron