Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tom Saddul
  Where is Tom Saddul?
 Paranaque
 Philippines
 Tom Saddul
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: mySQL Database Recovery
Thread ID: 344721 Message ID: 345010 # Views: 29 # Ratings: 0
Version: Not Applicable Category: Off-topic
Date: Thursday, May 17, 2012 8:49:28 AM         
   


> >
> > 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

It's good that you were able to repair it. Were you paid?

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