mysql - XAMPP MySQL 无法启动错误 1217

Question

我的电脑最近中了病毒，不得不重新安装 Windows。幸运的是，我将所有内容都存储在单独的 HDD 上，因此我认为只需重新格式化并再次启动 XAMPP 即可。但显然这并不那么容易，当我尝试启动 MySQL 时，我不断收到此错误消息

2014-04-18 10:26:35 3200 [Note] Plugin 'FEDERATED' is disabled.
2014-04-18 10:26:35 bb4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-04-18 10:26:35 3200 [Note] InnoDB: The InnoDB memory heap is disabled
2014-04-18 10:26:35 3200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-04-18 10:26:35 3200 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-04-18 10:26:35 3200 [Note] InnoDB: Not using CPU crc32 instructions
2014-04-18 10:26:35 3200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-04-18 10:26:35 3200 [Note] InnoDB: Completed initialization of buffer pool
2014-04-18 10:26:43 3200 [Note] InnoDB: Highest supported file format is Barracuda.
2014-04-18 10:26:45 bb4 InnoDB: Operating system error number 1117 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2014-04-18 10:26:45 3200 [ERROR] InnoDB: File D:\xampp\mysql\data\ib_logfile0: 'Windows aio' returned OS error 1217. Cannot continue operation

我可以做什么来修复它？我不想丢失 MySQL 服务器中的数据。

Answer 1

请测试这个方法，将mysql/data/ibdata1复制到另一个地方，如果Windows无法复制该文件，这意味着文件因Unwanted windows shutdown而崩溃。所以发生了ibdata1 I/O错误。您必须在 xampp 驱动器上运行 Windows 驱动器错误检查。 Windows 自动恢复您的 ibdata1 文件。