MySQL Forums
Forum List  »  Data Recovery

Re: Restore InnoDB data basing on .frm and common ibdata file
Posted by: Michael Abramovich
Date: August 23, 2012 01:53AM

Rick James Wrote:
-------------------------------------------------------
> 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 ?


I know. I had innodb_file_per_table set to 0, so all my data in single ibdata1 file (and in ibdata2). The folders with databases contains just .frm files.
The only lost data is mysql.ini configuration file.

Logs from mysql.err are published in initial post.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore InnoDB data basing on .frm and common ibdata file
4732
August 23, 2012 01:53AM


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.