MySQL Forums
Forum List  »  InnoDB

Deleted ib* files, now not able to see table definition/data
Posted by: veeru k
Date: June 22, 2017 04:48AM

Hello - During server administration, we accidentally removed ib* files for our prod database. Now though we could bounce tables and see all table information through "SHOW TABLES", we aren't able to see the table definition (DESCRIBE <Tablename>) nor look for data (select * from <table-name>). We don't take regular backups to restore but the database schema files are intact, it's just the ib* files deleted.

mysql> select * from ac_alerts;
ERROR 1146 (42S02): Table 'rightnow.ac_alerts' doesn't exist


Pl. suggest on the option/ways to overcome from this issue.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Deleted ib* files, now not able to see table definition/data
198
June 22, 2017 04:48AM


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.