MySQL Forums
Forum List  »  Data Recovery

Re: Restore InnoDB data basing on .frm and common ibdata file
Posted by: Michael Abramovich
Date: August 21, 2012 08:11AM

The main problem is that I can't figure out how can I find Index of my tables. InnoDB-monitor shows just that even if I run some select queries with my database "word" (broken table is named "wp_wpshop_ordered" and doesn't appear in output):

===========================================
120821 16:08:16 INNODB TABLE MONITOR OUTPUT
===========================================
--------------------------------------
TABLE: name SYS_FOREIGN, id 11, flags 0, columns 7, indexes 3, appr.rows 0
  COLUMNS: ID: DATA_VARCHAR DATA_ENGLISH len 0; FOR_NAME: DATA_VARCHAR DATA_ENGLISH len 0; REF_NAME: DATA_VARCHAR DATA_ENGLISH len 0; N_COLS: DATA_INT len 4; DB_ROW_ID: DATA_SYS prtype 256 len 6; DB_TRX_ID: DATA_SYS prtype 257 len 6; DB_ROLL_PTR: DATA_SYS prtype 258 len 7;
  INDEX: name ID_IND, id 11, fields 1/6, uniq 1, type 3
   root page 302, appr.key vals 0, leaf pages 1, size pages 1
   FIELDS:  ID DB_TRX_ID DB_ROLL_PTR FOR_NAME REF_NAME N_COLS
  INDEX: name FOR_IND, id 12, fields 1/2, uniq 2, type 0
   root page 303, appr.key vals 0, leaf pages 1, size pages 1
   FIELDS:  FOR_NAME ID
  INDEX: name REF_IND, id 13, fields 1/2, uniq 2, type 0
   root page 304, appr.key vals 0, leaf pages 1, size pages 1
   FIELDS:  REF_NAME ID
--------------------------------------
TABLE: name SYS_FOREIGN_COLS, id 12, flags 0, columns 7, indexes 1, appr.rows 0
  COLUMNS: ID: DATA_VARCHAR DATA_ENGLISH len 0; POS: DATA_INT len 4; FOR_COL_NAME: DATA_VARCHAR DATA_ENGLISH len 0; REF_COL_NAME: DATA_VARCHAR DATA_ENGLISH len 0; DB_ROW_ID: DATA_SYS prtype 256 len 6; DB_TRX_ID: DATA_SYS prtype 257 len 6; DB_ROLL_PTR: DATA_SYS prtype 258 len 7;
  INDEX: name ID_IND, id 14, fields 2/6, uniq 2, type 3
   root page 305, appr.key vals 0, leaf pages 1, size pages 1
   FIELDS:  ID POS DB_TRX_ID DB_ROLL_PTR FOR_COL_NAME REF_COL_NAME
--------------------------------------
TABLE: name mysql/innodb_table_monitor, id 14, flags 1, columns 4, indexes 1, appr.rows 0
  COLUMNS: id: DATA_INT DATA_BINARY_TYPE len 4; DB_ROW_ID: DATA_SYS prtype 256 len 6; DB_TRX_ID: DATA_SYS prtype 257 len 6; DB_ROLL_PTR: DATA_SYS prtype 258 len 7;
  INDEX: name GEN_CLUST_INDEX, id 16, fields 0/4, uniq 1, type 1
   root page 309, appr.key vals 0, leaf pages 1, size pages 1
   FIELDS:  DB_ROW_ID DB_TRX_ID DB_ROLL_PTR id
--------------------------------------
TABLE: name word/innodb_table_monitor, id 13, flags 1, columns 4, indexes 1, appr.rows 0
  COLUMNS: id: DATA_INT DATA_BINARY_TYPE len 4; DB_ROW_ID: DATA_SYS prtype 256 len 6; DB_TRX_ID: DATA_SYS prtype 257 len 6; DB_ROLL_PTR: DATA_SYS prtype 258 len 7;
  INDEX: name GEN_CLUST_INDEX, id 15, fields 0/4, uniq 1, type 1
   root page 307, appr.key vals 0, leaf pages 1, size pages 1
   FIELDS:  DB_ROW_ID DB_TRX_ID DB_ROLL_PTR id
-----------------------------------
END OF INNODB TABLE MONITOR OUTPUT
==================================

Can it happen becuase MySQL dosn't see table because only .frm exist?
mysql> select * from wp_wpshop_ordered;
ERROR 1146 (42S02): Table 'word.wp_wpshop_ordered' doesn't exist



Edited 1 time(s). Last edit at 08/21/2012 08:18AM by Michael Abramovich.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore InnoDB data basing on .frm and common ibdata file
5487
August 21, 2012 08:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.