getting the tables.

[connell]

Hi all of you,
There is a disastrous failure of my C drive. E drive is safe contaning the stored IBDATA1 but not the log files. I reinstalled MySQL and then overwrote the blank new IBDATA1 with my old one. Please advice me of how to get at the tables that are in there?
Please help its urgent.
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[gilbert]

In case the database was shut down cleanly, it should come up without the log files. Delete the log files from the new installation before overwriting the ibdata1 with the backup. Also, request InnoDB to dump its internal data dictionary to the error log by creating a table named "innodb_table_monitor". And try to come up with the CREATE TABLE statements. CREATE TABLE would then create the .frm files and you could access the tables. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --