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
Subject
Views
Written By
Posted
Deleted ib* files, now not able to see table definition/data
1027
June 22, 2017 04:48AM
502
June 22, 2017 07:46AM
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.