Recovery of data from InnoDB table

[Macario]

Sponsored Links

I had mysql on a server that has crashed. I recover the hard disk, it contains the whole directory of mysql: the engine data. How do I do to recover data from a table that is probably InnoDB? For though I copy it with other databases, when I try to see its contents with phpmyadmin, it says there is no table.

[void]

If your tables use the default MyISAM engine, you will just have to paste the folder back to your base where it was before crash (/var/lib/mysql/ usually on Linux).

If you know by using the InnoDB engine (which is excellent for receiving foreign keys) and you have not saved properly (using MySQL DUMP or phpMyAdmin tool backup or other) data, you may not find that the structure of tables by pasting the directory of your database and the data will probably be lost as stored in another file (/var/lib/mysql/idbdata on Linux + log files ib_logfileX ).

[Macario]

OK, I dig myself thinking about the same, then I changed my mind in preferring to create a new database. Because I happen to have the files "idbdata" and "ib_logfileX" but I do not know how to retrieve data from there on windows.

[void]

Since it is after a crash, I suppose the new server is empty of data and want to restore what was on the former.

What I would try:
1) Stop MySQL service on the new server

2) Save the current data directory of MySQL on the new server.
While in principle it is nearly empty but if there are config, the manip may completely crash the MySQL server, so be cautious.

3) Put in place the data directory from the old server.

4) Restart the MySQL service and see if the data is retrieved.
If it is planted, redo the manip reverse.

But before all that, even when I throw a look at the MySQL doc.

[Macario]

I searched a lot on this, I found nothing to InnoDB, only for MyISAM. I searched the net with InnoDB crash, then Reovery InnoDB crash recovery and InnoDB. But I find nothing under Windows system, can I get help? According to me Google is vast already but still a bit empty!