Autor Zpráva
Kvido
Profil *
nemůžu nastartovat MySQL a do logu se vypíše:

100609 9:03:12 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Warning: database page corruption or a failed
InnoDB: file read of page 5476.
InnoDB: Trying to recover it from the doublewrite buffer.
InnoDB: Dump of the page:
100609 9:03:12 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 9b71e71400001564ffffffffffffffff00000000424b99e545bf00000000000000000000000000162169005800000000........;InnoDB: End of page dump
100609 9:03:12 InnoDB: Page checksum 1696633244, prior-to-4.0.14-form checksum 63807889
InnoDB: stored checksum 2607933204, prior-to-4.0.14-form stored checksum 151947542
InnoDB: Page lsn 0 1112250853, low 4 bytes of lsn at page end 1112253351
InnoDB: Page number (if stored to page already) 5476,
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 0 387
InnoDB: Dump of corresponding page in doublewrite buffer:
100609 9:03:12 InnoDB: Page dump in ascii and hex (16384 bytes):
len 16384; hex 9b71e71400001564ffffffffffffffff00000000424b99e545bf000000000000000000000000001621690058000000002..........;InnoDB: End of page dump
100609 9:03:12 InnoDB: Page checksum 1696633244, prior-to-4.0.14-form checksum 63807889
InnoDB: stored checksum 2607933204, prior-to-4.0.14-form stored checksum 151947542
InnoDB: Page lsn 0 1112250853, low 4 bytes of lsn at page end 1112253351
InnoDB: Page number (if stored to page already) 5476,
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 0 387
InnoDB: Also the page in the doublewrite buffer is corrupt.
InnoDB: Cannot continue operation.
InnoDB: You can try to recover the database with the my.cnf
InnoDB: option:
InnoDB: set-variable=innodb_force_recovery=6


Dík za pomoc
nightfish
Profil
Kvido:
InnoDB: You can try to recover the database with the my.cnf
InnoDB: option:
InnoDB: set-variable=innodb_force_recovery=6
pro začátek bych zkusil toto
Kvido
Profil *
Zkusil jsem to i s parametrem 4 ale žádný výsledek
nightfish
Profil
Pokud to s 6 nepomohlo, tak asi bude potřeba použít nějaký jiný nástroj - třeba http://code.google.com/p/innodb-tools/

Vaše odpověď

Mohlo by se hodit


Prosím používejte diakritiku a interpunkci.

Ochrana proti spamu. Napište prosím číslo dvě-sta čtyřicet-sedm:

0