I had a server fail (disk failure, old server; no raid) at the weekend and am unable to recover the MySQL databases from the backup.
After exhausting all the usual recovery options, I've performed a disk recovery and have managed to retrieve the contents of the MySQL data folder located at c:\programdata\MySQL Server 5.5\data
The folders corresponding to each of the databases are there and are populated with .frm and .myi/.myd files... these seem quite small in size.... between 10 and 20k each. In the root of the data folder there are various files...
ib_logfile0
ib_logfile1
ib_logfile0_000
ib_logfile1_000
ibdata1
ibdata1_000
WIN-8KT3MJ6T2PS.err
WIN-8KT3MJ6T2PS.pid
WIN-8KT3MJ6T2PS_000.err
WIN-8KT3MJ6T2PS_000.pid
So far I have tried installing a new clean server with 2008 R2 (original host OS) and MySQL 5.5, then stopping the service and replacing the contents of the data directory with that of my recovered data, but when I try this, the MySQL service will no longer start, telling me 'The description for Event ID 100 from source MySQL cannot be found...'.
Is there any other way in which I can recover the databases from these files?
