Autor | Zpráva | ||
---|---|---|---|
Kvido Profil * |
#1 · Zasláno: 9. 6. 2010, 09:16:28
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 |
#2 · Zasláno: 9. 6. 2010, 09:19:24
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 * |
#3 · Zasláno: 9. 6. 2010, 09:41:18
Zkusil jsem to i s parametrem 4 ale žádný výsledek
|
||
nightfish Profil |
#4 · Zasláno: 9. 6. 2010, 09:46:01
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/
|
||
Časová prodleva: 14 let
|
0