List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:March 16 2012 4:16am
Subject:Re: ERROR 1146 (42S02): Table 'ois.metadata' doesn't exist
View as plain text  
Thanks Andrew ,

I got my schema back :-) .

But Is it possible to get back all procedures that are created on these 
tables.

Thanks once again.

Andrew Moore wrote:
> You should be able to get the table structure again using the frm files
>
> http://www.mysqlperformanceblog.com/2008/12/17/recovering-create-table-statement-from-frm-file/
> 
>
> On Thu, Mar 15, 2012 at 11:56 AM, Adarsh Sharma 
> <adarsh.sharma@stripped <mailto:adarsh.sharma@stripped>> wrote:
>
>     Thanks baron , below are the contents of my error.log :-
>
>
>     120315 17:17:51 [Note] Plugin 'FEDERATED' is disabled.
>     120315 17:17:51  InnoDB: Initializing buffer pool, size = 8.0M
>     120315 17:17:51  InnoDB: Completed initialization of buffer pool
>     InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on
>     InnoDB: Skipping log redo
>     120315 17:17:51  InnoDB: Started; log sequence number 0 0
>     InnoDB: !!! innodb_force_recovery is set to 6 !!!
>     120315 17:17:51 [Note] Event Scheduler: Loaded 0 events
>     120315 17:17:51 [Note] /usr/sbin/mysqld: ready for connections.
>     Version: '*5.1.61-0ubuntu0.10.04.1*'  socket:
>     '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
>     120315 17:17:52 [ERROR] Cannot find or open table ois/metadata from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table ois/page_content
>     from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table ois/page_crawled
>     from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table
>     ois/website_internalurl from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table ois/metadata from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table ois/page_content
>     from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table ois/page_crawled
>     from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     120315 17:17:52 [ERROR] Cannot find or open table
>     ois/website_internalurl from
>     the internal data dictionary of InnoDB though the .frm file for the
>     table exists. Maybe you have deleted and recreated InnoDB data
>     files but have forgotten to delete the corresponding .frm files
>     of InnoDB tables, or you have moved .frm files to another database?
>     or, the table contains indexes that this version of the engine
>     doesn't support.
>     See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
>     how you can resolve the problem.
>
>     I read the links & Is there any way whether my table is orphaned
>     or not. I need that table structure only , and it might be good
>     that I get my data back & it is not mandatory.
>
>
>     Thanks
>
>
>
>
>     Baron Schwartz wrote:
>
>         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 <mailto: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
>
>                
>
>
>
>
>          
>
>
>


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