mysql - Windows自行关闭后，我无法在xampp上运行mysql

Question

我在启动 mysql (xampp) 时遇到问题。我的windows自行关闭后mysql无法运行。

我认为问题是因为在 Windows 关闭之前某些文件未完成。但我不知道文件在哪里。或者可能是另一个问题？

虽然apache也跑不了。请帮忙

请大家帮忙解决这个问题

错误消息

2015-05-25 21:42:44 3776 [Note] Plugin 'FEDERATED' is disabled.

2015-05-25 21:42:44 c78 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.

2015-05-25 21:42:44 3776 [Note] InnoDB: Using atomics to ref count buffer pool pages


2015-05-25 21:42:44 3776 [Note] InnoDB: The InnoDB memory heap is disabled

2015-05-25 21:42:44 3776 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2015-05-25 21:42:44 3776 [Note] InnoDB: Memory barrier is not used

2015-05-25 21:42:44 3776 [Note] InnoDB: Compressed tables use zlib 1.2.3

2015-05-25 21:42:44 3776 [Note] InnoDB: Not using CPU crc32 instructions

2015-05-25 21:42:44 3776 [Note] InnoDB: Initializing buffer pool, size = 16.0M

2015-05-25 21:42:44 3776 [Note] InnoDB: Completed initialization of buffer pool

2015-05-25 21:42:45 3776 [Note] InnoDB: Highest supported file format is Barracuda.

2015-05-25 21:42:45 3776 [Note] InnoDB: Log scan progressed past the checkpoint lsn 17355383

2015-05-25 21:42:45 3776 [Note] InnoDB: Database was not shutdown normally!

2015-05-25 21:42:45 3776 [Note] InnoDB: Starting crash recovery.

2015-05-25 21:42:45 3776 [Note] InnoDB: Reading tablespace information from the .ibd files...

2015-05-25 21:42:47 3776 [Note] InnoDB: Restoring possible half-written data pages 

2015-05-25 21:42:47 3776 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 17355393

2015-05-25 21:42:49 3776 [Note] InnoDB: 128 rollback segment(s) are active.

2015-05-25 21:42:49 3776 [Note] InnoDB: Waiting for purge to start

2015-05-25 21:42:49 3776 [Note] InnoDB: 5.6.20 started; log sequence number 17355393

2015-05-25 21:42:49 3776 [Note] Server hostname (bind-address): '*'; port: 3306

2015-05-25 21:42:49 3776 [Note] IPv6 is available.

2015-05-25 21:42:49 3776 [Note]   - '::' resolves to '::';

2015-05-25 21:42:49 3776 [Note] Server socket created on IP: '::'.

Answer 1

不知道为什么会出现这个问题。但要解决这个问题，您可以:

1. 获取 xampp > htdocs 和 xampp > mysql > data 的备份位于远离 xampp 文件夹的其他位置的文件夹。
2. 卸载 xampp 并重新安装。
3. 将复制的文件夹 htdocs 和 data 替换到新安装的 xampp 文件夹的相应文件夹中。

现在您可以运行 apache 和 mysql。