作者SmallBeeWayn (喵喵叫的蜜蜂猫)
看板Database
标题[系统] MySQL崩溃, 求助
时间Tue Aug 8 23:04:50 2006
资料库名称:MySQL
资料库版本:4.1.19
作业平台:Windows 2003
问题描述:
发生状况当时我不在现场,当时发生了停电
UPS有运作指示电脑关机
系统纪录上在下次开机(我设定来电自动开机)没有警示异常关机
之後MySQL於启动时发生以下状况
060808 22:42:23 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...
060808 22:42:52 InnoDB: Operating system error number 23 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB:
http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: File name .\ibdata1
InnoDB: File operation call: 'Windows aio'.
InnoDB: Cannot continue operation.
=======================
如果将ibdata1, ib_logfile0, ib_logfile1 移走的话可以启动
但是有很多table都会挂掉
另外也试着改table_cache值,不过没有用
我没有备份Table, 请问该怎麽办......
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.115.204.46