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> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
