MAMP Mysql Error - Failed to open log

mysql mamp error-log binary-log
Johannes picture Johannes · Aug 26, 2013 · Viewed 11.4k times · Source

I've been working with a MAMP installation for several weeks now, and when I started it up today it would not start. No mysql process was running so I checked the error log which shows the following when I start the server:

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

So it's clear that a certain log file cannot be found, but I don't know why that happened, or how to fix it.

Answer

Johannes picture Johannes · Aug 26, 2013

It seems that one of the binary log files, Applications/MAMP/db/mysql/mysql-bin.000025, got corrupted or deleted (it was no longer there, and I did not manually delete it).

After doing some research and finding this post, I was able to fix this by navigating to /Applications/MAMP/db/mysql and manually editing mysql-bin.index to no longer include the missing log file.

I'm still a little confused what led to this issue originally though, since I shut down my MAMP server normally and never touched the binary log files...

Related questions

PHP Warning: mysqli_connect(): (HY000/2002): Connection refused

I am using PHP 5.5 and MAMP (downloaded from here): I have a basic script like this: <?php $servername = "127.0.0.1"; $username = "root"; $password = "root"; // Create connection $conn = mysqli_connect($servername, $username, $password); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_…

Read More
MAMP mysql server won't start. No mysql processes are running

My MAMP mysql server won't start. All of the suggestions I've seen on the web say to check for other mysqld processes running and kill them if they exist, and that it should fix the problem, but it has not …

Read More
Does MySQL included with MAMP not include a config file?

I can't seem to find the my.cnf or other config file for the MySQL that comes with MAMP. Does it not include one?

Read More