denovo/mamp-mysql-repair.md

Last active January 17, 2018 12:50

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/denovo/dc0fecd91d819fad387c36c526f8ccca.js"></script>
Save denovo/dc0fecd91d819fad387c36c526f8ccca to your computer and use it in GitHub Desktop.

mamp - fix problems with mysql not starting on server start

Raw

If mysql won't start when using mamp MAMP

Edit MAMP settings: File > Edit Template > MySql my.cnf

Add/Edit lines in my.cnf:

[mysqld]
innodb_force_recovery = 0

^ add or change line above to innodb_force_recovery = 1 (if there isn't this line in your config you may need to add it below "[mysqld]")

Then restart servers, mysql should start as normal. Remember to revert the changes above back to 0 and then use mamp as usual

Select an option