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 (the 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?