Not the answer you need?
Register and ask your own question!

Recover from deleted ibdata1 file

emagutuemagutu EntrantCurrent User Role Beginner
Hi,
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

Comments

  • wagnerbianchiwagnerbianchi Remote DBA Current User Role Patron
    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...
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.