List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:March 15 2012 10:39am
Subject:Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
View as plain text  
It sounds like InnoDB itself might have failed to start, but there is
not enough information to know for sure. Please check the server's
error log.

On Thu, Mar 15, 2012 at 2:01 AM, Adarsh Sharma <adarsh.sharma@stripped> wrote:
> 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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>



-- 
Baron Schwartz
Win free MySQL conference tickets! http://goo.gl/mvZ4W
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