XAAMP中的MySQL服务器无法启动

4

我使用这个软件已经几天了,没有遇到任何问题,但昨天mysql服务器拒绝启动。我已经重新启动了所有设备,但它仍然无法启动。以下是部分日志文件,请告诉我如何让它重新运行起来以及为什么会出现这种情况?我的操作系统是Windows 10。同时,Apache服务器仍然可以正常启动。

**InnoDB: using atomic writes.
2020-11-24 15:25:23 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-11-24 15:25:23 0 [Note] InnoDB: Uses event mutexes
2020-11-24 15:25:23 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-24 15:25:23 0 [Note] InnoDB: Number of pools: 1
2020-11-24 15:25:23 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-24 15:25:23 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-11-24 15:25:23 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-24 15:25:23 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-11-24 15:25:24 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-24 15:25:24 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-24 15:25:24 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-24 15:25:24 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-24 15:25:24 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-11-24 15:25:24 0 [Note] InnoDB: Waiting for purge to start
2020-11-24 15:25:24 0 [Note] InnoDB: 10.4.16 started; log sequence number 300297; transaction id 170
2020-11-24 15:25:24 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-11-24 15:25:24 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-24 15:25:24 0 [Note] InnoDB: Buffer pool(s) load completed at 201124 15:25:24
2020-11-24 15:25:24 0 [Note] Server socket created on IP: '::'.
2020-11-24 19:42:47 0 [Note] mysqld.exe: Aria engine: starting recovery
recovered pages: 0% 13% 55% 81% 94% 100% (0.0 seconds); tables to flush: 2 1 0
 (0.1 seconds); 
2020-11-24 19:42:48 0 [Note] mysqld.exe: Aria engine: recovery done
InnoDB: using atomic writes.
2020-11-24 19:42:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-11-24 19:42:48 0 [Note] InnoDB: Uses event mutexes
2020-11-24 19:42:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-24 19:42:48 0 [Note] InnoDB: Number of pools: 1
2020-11-24 19:42:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-24 19:42:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-11-24 19:42:48 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-24 19:42:48 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=458268
2020-11-24 19:42:48 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-24 19:42:48 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-24 19:42:48 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-24 19:42:48 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-24 19:42:48 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-11-24 19:42:48 0 [Note] InnoDB: Waiting for purge to start
2020-11-24 19:42:48 0 [Note] InnoDB: 10.4.16 started; log sequence number 458277; transaction id 670
2020-11-24 19:42:48 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-11-24 19:42:48 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-24 19:42:48 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-11-25 11:28:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-11-25 11:28:55 0 [Note] InnoDB: Uses event mutexes
2020-11-25 11:28:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-25 11:28:55 0 [Note] InnoDB: Number of pools: 1
2020-11-25 11:28:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-25 11:28:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-11-25 11:28:55 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-25 11:28:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=458587
2020-11-25 11:28:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-25 11:28:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-11-25 11:28:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-25 11:28:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-25 11:28:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-11-25 11:28:55 0 [Note] InnoDB: Waiting for purge to start
2020-11-25 11:28:55 0 [Note] InnoDB: 10.4.16 started; log sequence number 458596; transaction id 693
2020-11-25 11:28:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-11-25 11:28:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-25 11:28:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.**

没有问题,您可以在“服务器套接字已创建IP:'::'”处看到这个信息。如果出现启动错误,就会有相应的错误消息提示,但是现在暂时看不到任何原因。MySQL并不是出现问题的原因,可能是其他程序造成了计算机重启,从而导致MySQL重新启动以进行恢复。 - nbk
这非常奇怪。我正在使用个人电脑,没有其他人可以访问它。有什么想法是什么导致了这个问题吗?看起来mysql在启动1-2秒后就停止了。 - Justin Oberle
请检查日志中的任何错误(不是MySQL),并检查适合MySQL日志的日期。 - nbk
我找到了一个。在这里... - Justin Oberle
2020-11-27 14:29:06 0 [错误] mysqld.exe:'.\mysql\db'表的索引已损坏;请尝试修复它***警告:无法打开.\mysql\db:错误:126 25%35%48%62%74%86%96%100%(0.0秒);要刷新的表:3 2 1 0 (0.3秒); - Justin Oberle
显示剩余4条评论
1个回答

5

从xampp/mysql/backup文件夹复制并粘贴到xampp/mysql/data文件夹,除了ibdata1文件。

如果您替换xampp/mysql/data中的ibdata1文件,则某些数据库会出现错误:表不存在。

在此处找到... XAMPP重新启动后MySQL服务崩溃


网页内容由stack overflow 提供, 点击上面的
可以查看英文原文,
原文链接