MySQL Forums
Forum List  »  Data Recovery

Recovering InnoDB databases/tables
Posted by: Andrew Chan
Date: March 23, 2009 11:07PM

I have a database with all InnoDB tables.

I am a little bit confused about the file structure

the .frm files are the table format
the .ibd files inside the database folder are the data
I have a ibdata1 file, which should be the shared tablespace.

The above should all be restored. I know that, OK. The problem goes to the transaction log

I have two files, ib_logfile0 and ib_logfile1. They are at 10mb in size. I suppose they are the transaction log file.

Then I turned on the Binary Log function, I learn that I can't restore point-in-time if I dun turn on Binary Log.

Then what does the ib_logfiles do?

what is a proper restore strategy for InnoDB tables if I need to have the transactions/statements roll forward to the latest second?

thank you very much

Options: ReplyQuote


Subject
Views
Written By
Posted
Recovering InnoDB databases/tables
4253
March 23, 2009 11:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.