MySQL Forums
Forum List  »  Data Recovery

Advanced Search
New Topic

Re: Restore InnoDB data basing on .frm and common ibdata file
Posted by: Rick James
Date: August 22, 2012 08:11PM

The .frm contains the schema (table definition), but no data.

With innodb_file_per_table = 1, the data and indexes are in a .ibd file.

With = 0, the data and indexes are in ibdata1.

Are there any useful messages in mysqld.err ?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Restore InnoDB data basing on .frm and common ibdata file
17582
MIchael Abramovich
August 18, 2012 09:15AM
Re: Restore InnoDB data basing on .frm and common ibdata file
5960
Aftab Khan
August 21, 2012 02:51AM
Re: Restore InnoDB data basing on .frm and common ibdata file
5351
Michael Abramovich
August 21, 2012 02:54AM
Re: Restore InnoDB data basing on .frm and common ibdata file
5571
Michael Abramovich
August 21, 2012 08:11AM
Re: Restore InnoDB data basing on .frm and common ibdata file
4644
Rick James
August 22, 2012 08:11PM
Re: Restore InnoDB data basing on .frm and common ibdata file
4819
Michael Abramovich
August 23, 2012 01:53AM
Re: Restore InnoDB data basing on .frm and common ibdata file
4444
Aftab Khan
August 23, 2012 01:15AM


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.