Re: Restore InnoDB data basing on .frm and common ibdata file

[Michael Abramovich]

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.