List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:March 15 2012 6:01am
Subject:ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
View as plain text  
Dear All,

Is there any way to recover data or only schema of corrupted innodb 
tables.My 4 innodb tables are coorupted in a  database.

mysql> show tables;
+---------------------+
| Tables_in_ois       |
+---------------------+
| acos                |
| aros                |
| aros_acos           |
| categories          |
| groups              |
| metadata            |
| page_content        |
| projects            |
| results             |
| users               |
| website_internalurl |
+---------------------+
12 rows in set (0.00 sec)

mysql> show create table metadata;
ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist

I backup my all remaining tables as I not able to backup corruted tables.

Thanks in advance

Thread
ERROR 1146 (42S02): Table 'ois.metadata' doesn't existAdarsh Sharma15 Mar
  • Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't existBaron Schwartz15 Mar
    • Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't existAdarsh Sharma15 Mar
Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't existAdarsh Sharma16 Mar