这是我在 mysql.err 里找出来的。请帮忙检查,谢谢_____________________________________________________________________ InnoDB: stored checksum 3075374560, prior-to-4.0.14-form stored checksum 1158438285 InnoDB: Page lsn 4142669612 3360602035, low 4 bytes of lsn at page end 3586200832 InnoDB: Page number (if stored to page already) 4118889177, InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 650564504 InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 2179. 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.1/en/forcing-recovery.html InnoDB: about forcing recovery. InnoDB: Ending processing because of a corrupt database page. 100209 11:21:04 [Note] Plugin 'FEDERATED' is disabled.____________________________________________________________________ InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence number in the ib_logfiles! 100209 11:21:04 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... 100209 11:21:04 InnoDB: Started; log sequence number 0 72402747 100209 11:21:04 [Note] Recovering after a crash using 1 100209 11:21:04 [Note] Starting crash recovery... 100209 11:21:04 [Note] Crash recovery finished. 100209 11:21:04 [Note] Event Scheduler: Loaded 0 events 100209 11:21:04 [Note] D:\xampp\mysql\bin\mysqld.exe: ready for connections. Version: '5.1.41-log' socket: '' port: 3306 Source distribution 100209 11:48:44 InnoDB: Error: space id and page n:o stored in the page InnoDB: read in are 650564504:4118889177, should be 0:2179! InnoDB: Database page corruption on disk or a failed InnoDB: file read of page 2179. InnoDB: You may have to recover from a backup.
Database page corruption on disk or a failed 不会是硬盘坏了吧
InnoDB: stored checksum 3075374560, prior-to-4.0.14-form stored checksum 1158438285
InnoDB: Page lsn 4142669612 3360602035, low 4 bytes of lsn at page end 3586200832
InnoDB: Page number (if stored to page already) 4118889177,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 650564504
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 2179.
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.1/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Ending processing because of a corrupt database page.
100209 11:21:04 [Note] Plugin 'FEDERATED' is disabled.____________________________________________________________________
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100209 11:21:04 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...
100209 11:21:04 InnoDB: Started; log sequence number 0 72402747
100209 11:21:04 [Note] Recovering after a crash using 1
100209 11:21:04 [Note] Starting crash recovery...
100209 11:21:04 [Note] Crash recovery finished.
100209 11:21:04 [Note] Event Scheduler: Loaded 0 events
100209 11:21:04 [Note] D:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.41-log' socket: '' port: 3306 Source distribution
100209 11:48:44 InnoDB: Error: space id and page n:o stored in the page
InnoDB: read in are 650564504:4118889177, should be 0:2179!
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 2179.
InnoDB: You may have to recover from a backup.
不会是硬盘坏了吧
http://download.csdn.net/source/2033283