Hello, All.
After a some backup actions we had lost our ibdata1 file. In my.cnf we have option innodb_file_per_table enabled, and we have an all our data in .frm and .ibd files. How can we got all data? Mysql doesn't view tables at all. Even in recovery mode. Here are messages from error log:
080724 13:46:28 InnoDB error:
Cannot find table Spot/AsearchChangeLog from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of
http://www.innodb.com/ibman.html
how you can resolve the problem.
080724 13:46:28 [ERROR] /usr/sbin/mysqld: Can't open file: 'AsearchChangeLog.ibd' (errno: 1)
Edited 1 time(s). Last edit at 07/24/2008 07:48AM by Eugene Petrenko.