MAMP PRO (macOS) Documentation

FAQ > MySQL

MySQL server does not start because of a sequence number

This may occur when your Mac goes to sleep.

10:12:32 1753 [Note] InnoDB: The log sequence numbers 609248312 and 609248312 in ibdata files do not match the log sequence number 609248322 in the ib_logfiles!

1. Quit MAMP PRO.
2. Go to your “/Library/application support/appsolute/MAMP PRO/db/mysql57” directory.
3. Rename both “ib_logfile0” and “ib_logfile1” to “ib_logfile0_bak” and “ib_logfile1_bak”.
4. Restart MAMP PRO.
5. Both “ib_logfile0” and “ib_logfile1” should be rebuilt.