Hi all!

My server crashed due to a HDD failure, but luckily I could somehow retrieve all the files from the HDD and made an .image using dd on my workstation.

Now my question is there someway to retrieve mySQL databases from these files? I hosted about 25 sites and I'm really not to into making them again from 0.

Cheers,
shorto

Hello,

It depends on what engine you used. Are they myisam or innodb? If the first then it should be painless to restore them. Have a look at the following links.
http://stackoverflow.com/questions/4...physical-files
http://dev.mysql.com/doc/refman/5.1/...intenance.html
http://www.webhostingtalk.com/showthread.php?t=670578

Also worth mentioning. The fact that you didn't have a backup (I assume you didn't since you don't mention it) means you really should get that put in place as soon as you're up and running again. There are some pretty neat utilities on the internet that you can use to make backup of your databases. As with all good practice, a backup should never be on the same disk/server/location.

Kind regards,

Eric