Asked By
Ren_Bang
0 points
N/A
Posted on - 01/29/2013
Hi,
Is there any possible way to retrieve .mdf files from mySQL server 2000 Database after it went corrupt due to virus infection? Are there any software available to recover missing files?
Thanks,
Ren
Retrieve files from mySQL server 2000 Database after being corrupt
Hello,
To resolve this issue, you need to perform some repair operations on the tables of your database. For that, use — recover, the –quick option and % myisamchk. The latter is very useful in repairing the tables without touching the data file. There are other slow options to use such as –safe-recover but few errors could be fixed. To remove temporary files completely –force option should be used. Check SQLRep.txt file attached to this message for instructions.
Another solution is to download MySQLRecovery. It is a data recovery software for damaged MySQL Server.
I hope this is helpful.
Retrieve files from mySQL server 2000 Database after being corrupt
Hello Ren,
First of all backup your database files (.mdf & .ndf).
Are you able to attach the database? If not the share the error message.
If you will be able to attach the database then run DBCC CHECK on the database. If you will find error messages the re-run DBCC CHECKDB with repair_allow_data_loss.
Note: Data will be lost.
There are some good SQL server 2000 database recovery software available on the Internet. Download the demo version of the software and repair the corrupt file. You may pay some amount for it.Â