Po awarii prądu posypała mi się baza, gdy uruchamiam mysql w loga mam:
Czy jak mogę odzyskać dane z ibdata1?140822 21:25:46 InnoDB: Page checksum 1951577503, prior-to-4.0.14-form checksum 2862084858
InnoDB: stored checksum 1951577503, prior-to-4.0.14-form stored checksum 3097213159
InnoDB: Page lsn 1 1477217244, low 4 bytes of lsn at page end 1749220671
InnoDB: Page number (if stored to page already) 5,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be a transaction system page
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 5.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.5/en/ ... overy.html
InnoDB: about forcing recovery.
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 1109.
InnoDB: You may have to recover from a backup.
140822 21:25:46 InnoDB: Page dump in ascii and hex (16384 bytes):
[--------------------------- cos tam ------------------------------------------]
InnoDB: End of page dump
140822 21:25:46 InnoDB: Page checksum 1171680337, prior-to-4.0.14-form checksum 2213139294
InnoDB: stored checksum 2134044248, prior-to-4.0.14-form stored checksum 3644722137
InnoDB: Page lsn 1 1462772487, low 4 bytes of lsn at page end 1573800919
InnoDB: Page number (if stored to page already) 1109,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an index page where index id is 1
InnoDB: (index "CLUST_IND" of table "SYS_TABLES")
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 1109.
InnoDB: You may have to recover from a backup.
InnoDB: It is also possible that your operating
InnoDB: system has corrupted its own file cache
InnoDB: and rebooting your computer removes the
InnoDB: error.
InnoDB: If the corrupt page is an index page
InnoDB: you can also try to fix the corruption
InnoDB: by dumping, dropping, and reimporting
InnoDB: the corrupt table. You can use CHECK
InnoDB: TABLE to scan your table for corruption.
InnoDB: See also http://dev.mysql.com/doc/refman/5.5/en/ ... overy.html
InnoDB: about forcing recovery.
Pozdrawiam
