當往其中的一個資料表內insert一條記錄的時候當掉的
“mysql-dt.ext 。。。。記憶體 0x?????? 不能為 read 之類的”
查不到日誌，於是修改了 my.ini ，往最後添加了
log=F:/Program Files/MySQL/MySQL Server 5.0/logs/log.log
log-error=F:/Program Files/MySQL/MySQL Server 5.0/logs/error.log
於是錯誤訊息出來了，可還是看不懂。。。
- 081212 23:18:28 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...
- 081212 23:18:28 InnoDB: Starting log scan based on checkpoint at
- InnoDB: log sequence number 0 407574894.
- InnoDB: Doing recovery: scanned up to log sequence number 0 407574894
- 081212 23:18:28 InnoDB: Started; log sequence number 0 407574894
- 081212 23:18:29 [Note] F:/Program Files/MySQL/MySQL Server 5.0/bin/mysqld-nt: ready for connections.
- Version: '5.0.21-community-nt-log' socket: '' port: 3306 MySQL Community Edition (GPL)
- InnoDB: Next record offset is nonsensical 52066 in record at offset 0
- InnoDB: rec address 010C8000, first buffer frame 00F84000
- InnoDB: buffer pool high end 01F84000, buf fix count 2
- 081212 23:18:34 InnoDB: Page dump in ascii and hex (16384 bytes):
- len 16384; hex （00000......幾十K的000.....00000）0000000000000000; asc
mysqldump 全庫頁不行，同樣的錯誤。。。
