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: Tom Saddul
  Where is Tom Saddul?
 Paranaque
 Philippines
 Tom Saddul
 Tags
Subject: RE: mySQL Database Recovery
Thread ID: 344721 Message ID: 344988 # Views: 30 # Ratings: 0
Version: Not Applicable Category: Off-topic
Date: Wednesday, May 16, 2012 8:52:27 PM         
   


> >
> >
> > Hi Anand,
> >
> > So far "No". I received .FRM file - the table definition file .MYD file - the data file, .MYI file - the index definition file.
> >
> > I tried to start and connect and open the database using all the methods in the previous messages to my thread.
> > In the error trace log:
> > Cannot Connect to Database Server - Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306
> >
> > I have the firewall turned totally off so there is no problem with port 3306, plus another mySQL database will connect and open just fine on my test server.
> >
> > If I take a new copy "just create a new Simply Accounting mySQL database Company file" and copy this into the data folder location, everything starts up and connects just fine. Copy back in the corrupted database and no go.
> >
> > So obviously something is very corrupted in the database that does not work. I tried out Stellar mySQL database recovery software and this product did successfully recover the corrupted database. I tested Stellar using the trail version that does not support the final copy out to produce a final fixed database that you can use as your production database.
> > Cost for me to purchase this software to fix the database is $599.00 US.
> >
> > Currently it looks like the client may be going elsewhere in efforts to recover the data. Not sure why, but my $695.00 quote to fix I guess to this customer seemed way too high. I talked to the admin manager yesterday morning and he felt that all that should be required is a rebuild of the database and indexing and felt that a charge of $75.00 was more than enough. Keep in mind this comment came from the same manager that feels if he has RAID-5 stripped drive on his server he need absolutely no backup solutions at all. I already have 4 hours invested in this mess and I guess my 4 hours is now a total loss.
> >
> > Not only is this manager arrogant and a pain-in-th-@ss, but he totally believes he is 100% correct. He took great exception to me pointing out a need is required for a disaster recovery backup solution for mission critical data. Heads knocked and he basically told me to stick it!
> >
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> You can copy the database into a working (fresh) mysql installation (where you can log-in as 'root') then you can repair the corrupted tables using CHECK TABLE and REPAIR TABLE commands


Hi Tom,
That's exactly what I did. Create a new Simply Accounting ccmpany file and copy the:
• .FRM file, the table definition file.
• .MYD file, the data file.
• .MYI file, the index definition file.

into a fresh mySQL installation and things work as expected. Copy in the same 3 files associated with the corrupted database and I cannot work on it.
However, Stellar mySQL Recovery software does work and correct the mySQL database.
http://www.stellarinfo.com/mysql-repair.htm

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