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.sha...@orkash.com <mailto:adarsh.sha...@orkash.com>> 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.sha...@orkash.com <mailto:adarsh.sha...@orkash.com>>
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
