is it possible to recover from a deleted ibdata1 after the database has been restarted? I am able to start the database by setting innodb_force_recovery = 1 and display the tables but when I try and run a select or dump on the data I get the following error.
mysqldump: Got error: 1146: Table ‘database.table’ doesn’t exist when using LOCK TABLES
i get the same with skip lock tables as well
Could you give us more details about the operation that was being done by you when this happened?
At first sight, it seems that you removed the InnoDB shared tablespace and then restart mysqld, is that correct? If yes, this is the cause of the error message you’re received when querying a InnoDB table because the InnoDB’s metadata and other things resides in the shared tablespace and even using innodb_file_per_table one cannot remove the ibdataX (read more about that file here http://dev.mysql.com/doc/refman/5.5/…os_ibdata_file).
Backup? i don’t have any other magical thing on my mind now…