我已经使用 MAMP 安装了几个星期了,当我今天启动它时,它无法启动。没有 mysql 进程正在运行,因此我检查了错误日志,启动服务器时显示以下内容:
130826 14:19:55 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql
130826 14:19:55 [Warning] You have forced lower_case_table_names to 0 through a command-line option, even though your file system '/Applications/MAMP/db/mysql/' is case insensitive. This means that you can corrupt a MyISAM table by accessing it with different cases. You should consider changing lower_case_table_names to 1 or 2
130826 14:19:55 [Warning] One can only use the --user switch if running as root
130826 14:19:55 [Note] Plugin 'FEDERATED' is disabled.
130826 14:19:55 InnoDB: The InnoDB memory heap is disabled
130826 14:19:55 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130826 14:19:55 InnoDB: Compressed tables use zlib 1.2.3
130826 14:19:55 InnoDB: Initializing buffer pool, size = 128.0M
130826 14:19:55 InnoDB: Completed initialization of buffer pool
130826 14:19:55 InnoDB: highest supported file format is Barracuda.
130826 14:19:55 InnoDB: Waiting for the background threads to start
130826 14:19:56 InnoDB: 1.1.8 started; log sequence number 4057202289
/Applications/MAMP/Library/bin/mysqld: File './mysql-bin.000025' not found (Errcode: 2)
130826 14:19:56 [ERROR] Failed to open log (file './mysql-bin.000025', errno 2)
130826 14:19:56 [ERROR] Could not open log file
130826 14:19:56 [ERROR] Can't init tc log
130826 14:19:56 [ERROR] Aborting
130826 14:19:56 InnoDB: Starting shutdown...
130826 14:19:57 InnoDB: Shutdown completed; log sequence number 4057202289
130826 14:19:57 [Note] /Applications/MAMP/Library/bin/mysqld: Shutdown complete
130826 14:19:57 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended
所以很明显找不到某个日志文件,但我不知道为什么会发生这种情况,也不知道如何修复它。
似乎二进制日志文件之一,Applications/MAMP/db/mysql/mysql-bin.000025
,被损坏或删除(它不再存在,而且我没有手动删除它)。
经过一些研究并发现this http://mysqldatabaseadministration.blogspot.com/2006/07/mysql-failed-to-open-log-file-innodb.html帖子,我可以通过导航到来解决这个问题/Applications/MAMP/db/mysql
并手动编辑mysql-bin.index
不再包含丢失的日志文件。
我仍然有点困惑最初是什么导致了这个问题,因为我正常关闭了我的 MAMP 服务器并且从未接触过二进制日志文件......
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)