当我尝试在XAMPP中启动mysql时，服务短暂启动，几秒钟后意外停止。mysql_error日志没有显示任何我能看到的异常情况（见下面的进一步内容），但是Windows事件查看器报告了一些问题。
XAMPP版本3.2.4，内置mariaDB，端口3308（尝试3306和3307，结果类似或更差：我能够手动启动msqld.exe通过windows资源管理器，服务显示为在XAMPP中运行，但HeidiSQL在尝试连接到服务器时变得无响应）
任何关于如何解决这个问题的建议将不胜感激。
事件查看器错误：
Fatal error: Can't open and lock privilege tables: Incorrect file format 'db'
Aborting
mysqld.exe: Error writing file 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
mysqld.exe: Aria engine: checkpoint failed
mysqld.exe: Error writing file 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
mysqld.exe: Error on close of 'C:\xampp\mysql\data\aria_log_control' (Errcode: 9 "Bad file descriptor")
Mysql_Error log extract:
2023-06-10 10:32:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-06-10 10:32:22 0 [Note] InnoDB: Uses event mutexes
2023-06-10 10:32:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-06-10 10:32:22 0 [Note] InnoDB: Number of pools: 1
2023-06-10 10:32:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-06-10 10:32:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-06-10 10:32:22 0 [Note] InnoDB: Completed initialization of buffer pool
2023-06-10 10:32:22 0 [Note] InnoDB: The log sequence number 38297845790 in the system tablespace does not match the log sequence number 38297845799 in the ib_logfiles!
2023-06-10 10:32:23 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-06-10 10:32:23 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-06-10 10:32:23 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-06-10 10:32:23 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-06-10 10:32:23 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-06-10 10:32:23 0 [Note] InnoDB: Waiting for purge to start
2023-06-10 10:32:23 0 [Note] InnoDB: 10.4.13 started; log sequence number 38297845799; transaction id 2864880
2023-06-10 10:32:23 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-06-10 10:32:23 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-06-10 10:32:23 0 [Note] InnoDB: Buffer pool(s) load completed at 230610 10:32:23
2023-06-10 10:32:23 0 [Note] Server socket created on IP: '::'.
1条答案
按热度按时间w80xi6nr1#
我无法解决MariaDB无法访问的问题，但是，我找到了恢复数据的方法：
1.安装相同版本的XAMPP的新示例，并确保选择新的目标文件夹
1.确保一切正常（主要是Apache和MySQL应该启动并保持活跃，PHPmyAdmin应该启动并不产生任何错误）
1.将数据所在的文件夹（通常为\XAMPP\mysql\data）复制到新XAMPP示例下的Data文件夹（例如c：\XAMP2\MySQL\data）
1.从新示例下的原始XAMPP MySQL\data文件夹中复制文件ibdata1，同一文件夹
1.打开新的XAMPP示例并启动Apache和MySQL（这就是它的标签，我不是说它 is MySQL...）
1.数据应可访问以进行查看和导出，或在新示例中使用
这不是一个完美的解决方案，因为它可能需要大量重新配置XAMPP组件，但至少您已经重新获得了对数据的访问。