Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

One of my servers' OS crashed yesterday. It was Win 2008.The server developed an HDD fault and did not boot.

My host provider (Turnkey) has mounted the HDD on a Rescue system and given me access to the HDD through SSH. I have been able to download the Mysql data folder and all the MYD, MYI, FRM files. (MyIsam db?).

I tried changing my local computer's data folder to the backup data folder but MySql didn't run with this data folder. At my other server the db showed up but it was empty!

I believe this could be happening due to version differences in the MySql files.

Is there any way I can recover this data? A tool maybe, or a way?

Also

  • How can I find the version of mysql from the data files or the bin folder.

Thanks for the help guys!

share|improve this question
    
Impossible to answer. "MySql didn't run with this data folder" - were there any error messages? Any log lines? –  Gaius Oct 25 '10 at 20:04

1 Answer 1

If you used Innodb, you need the innodb data files aswell. default names are ibdata0 and ibdata1, plus log files for it. Did you check the logs of mysql? It would refuse to start if there is incorrect permissions or ownership for example. You should start by looking at the error messages there.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.