Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 Tags
Subject: RE: mySQL Database Recovery
Thread ID: 344721 Message ID: 345068 # Views: 29 # Ratings: 0
Version: Not Applicable Category: Off-topic
Date: Thursday, May 17, 2012 7:42:42 PM         
   


> > Hi Foxitians,
> >
> > Looking for some advise on how to or software repair utilities for mySQL databases.
> >
> > Here is the scenario.
> >
> > Client is located out on the east coast of Canada in Halifax. The were running Simply Accounting Enterprise 2012 that uses mySQL server database as the backend.
> >
> > They had the mySQL database installed on a Win 2008 server with a RAID-5 drive array. Early last week one of their RAID drives failed totally and also what-ever went wrong with the drive it also blew out the server's power supply so the server crashed.
> >
> > Now comes the fun. This client although a rather large company had no backup solution at all. Their IT manager expressed to me that in his opinion with a RAID-5 drive with full redundancy, "Why should I bother with any backup procedures when I have my server setup with full RAID-5."
> >
> > I humbly asked him what institution of higher learning advised him of this "best practice?" lol and lol and lol again.
> >
> > So we got all their data back after replacing the server's power supply and starting the replacement RAID drive rebuild manually. Everything is up and running except.. yep you guessed it, the mySQL database is corrupted.
> >
> > I cannot open the database in Simply Accounting or via the mySQL Server WorkBench nor connect to it via ODBC.
> > All I get if I try to open with Simply Accounting is and error, "The Company file is corrupted!"
> >
> > The mySQL Workbench gives me, "Not a mySQL database" error.
> >
> > ODBC just spits out a lot of errors that really do not matter here.
> >
> > So any recovery utilities you may have used successfully? Client's got over 4 years of accounting and financial information and not one backup ever taken in the past 4 years.
> >
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> There are companies that specialize in recovering data from media.
>
> Mike Yearwood
> Microsoft MVP Visual FoxPro 2008, 2009
> We have enough youth. We need a fountain of smart!
> There may be many ways to skin a cat, but there are very few right ways to do it.


Hi Mike,
We do a lot of data recovery here at Griffin Computers. In this case due to the fact the client had a RAID-5 configuration on his server we were able to order in and replace the defective drive and have it rebuild. All files came back and working except the mySQL database that I have all the files for, but one of them or all 3 of them became corrupted. Stellar mySQL recovery software successfully recovered the mySQL database. In this case one drive blew and also the power supply at the same time. I did discuss with the client reconfiguring the RAID-5 to add in one redundant drive and a dual fail-safe power supply, but customer does not want to spend any money.
Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

ENTIRE THREAD

mySQL Database Recovery Posted by Pete Sass @ 5/12/2012 4:33:17 PM
RE: mySQL Database Recovery Posted by anand kulkarni @ 5/12/2012 4:47:43 PM
RE: mySQL Database Recovery Posted by Mustapha Bihmouten @ 5/13/2012 10:20:37 AM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/13/2012 5:01:12 PM
RE: mySQL Database Recovery Posted by Mustapha Bihmouten @ 5/13/2012 8:11:32 PM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/13/2012 10:03:19 PM
RE: mySQL Database Recovery Posted by Mustapha Bihmouten @ 5/13/2012 11:00:30 PM
RE: mySQL Database Recovery Posted by tushar @ 5/13/2012 11:23:19 AM
RE: mySQL Database Recovery Posted by anand kulkarni @ 5/15/2012 11:17:24 AM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/15/2012 4:32:30 PM
RE: mySQL Database Recovery Posted by anand kulkarni @ 5/16/2012 7:55:13 AM
RE: mySQL Database Recovery Posted by Paul Gibson @ 5/16/2012 2:05:21 PM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/16/2012 3:58:20 PM
RE: mySQL Database Recovery Posted by Tom Saddul @ 5/16/2012 4:12:15 PM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/16/2012 8:52:27 PM
RE: mySQL Database Recovery Posted by Tom Saddul @ 5/17/2012 8:49:28 AM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/17/2012 6:39:46 PM
RE: mySQL Database Recovery Posted by Mike Yearwood @ 5/16/2012 4:38:20 PM
RE: mySQL Database Recovery Posted by Pete Sass @ 5/17/2012 7:42:42 PM