Retrieve files from mySQL server 2000 Database after being corrupt

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

• Status: Open
• Question Views: 667
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Williams Todd

Go To Solution

Best Answer

Best Answer

Answered By Williams Todd 0 points N/A #170043

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.

About Williams Todd

Questions
4

Answers
143

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 02/14/2013
• Question Category: MySQL Server

Answered By addisionphilip 0 points N/A #170045

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. 

About addisionphilip

Questions
0

Answers
7

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 02/18/2013
• Question Category: MySQL Server