-
-
Save gghughunishvili/333de6e6b2a948dad07c414dba2a0613 to your computer and use it in GitHub Desktop.
Upgrade MySql on MAMP
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# // Upgrade MAMP 3 to Mysql 5.7.12 (on El Capitan Tested) | |
#!/bin/sh | |
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-osx10.11-x86_64.tar.gz | |
tar xfvz mysql-5.7.12-osx10.11-x86_64.tar.gz | |
echo "stopping mamp" | |
sudo /Applications/MAMP/bin/stop.sh | |
sudo killall httpd mysqld | |
echo "creating backup" | |
sudo rsync -arv --progress /Applications/MAMP ~/Desktop/MAMP-Backup | |
echo "copy bin" | |
sudo rsync -arv --progress mysql-5.7.*/bin/* /Applications/MAMP/Library/bin/ --exclude=mysqld_multi --exclude=mysqld_safe | |
echo "copy share" | |
sudo rsync -arv --progress mysql-5.7.*/share/* /Applications/MAMP/Library/share/ | |
echo "fixing access (workaround)" | |
sudo chmod -R o+rw /Applications/MAMP/db/mysql/ | |
sudo chmod -R o+rw /Applications/MAMP/tmp/mysql/ | |
echo "starting mamp" | |
sudo /Applications/MAMP/bin/start.sh | |
echo "migrate to new version" | |
sudo chmod -R 777 /Applications/MAMP/db/mysql/ | |
/Applications/MAMP/Library/bin/mysql_upgrade --user=root --password=root --host=localhost --port=3306 | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# // Upgrade MAMP 4.1.1 to Mysql 5.7.12 (on OSX Sierra Tested) | |
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.12-osx10.11-x86_64.tar.gz | |
tar xfvz mysql-5.7.12-osx10.11-x86_64.tar.gz | |
echo "stopping mamp" | |
sudo /Applications/MAMP/bin/stop.sh | |
sudo killall httpd mysqld | |
echo "creating backup" | |
sudo rsync -arv --progress /Applications/MAMP ~/Desktop/MAMP-Backup | |
echo "copy bin" | |
sudo rsync -arv --progress mysql-5.7.*/bin/* /Applications/MAMP/Library/bin/ --exclude=mysqld_multi --exclude=mysqld_safe | |
echo "copy share" | |
sudo rsync -arv --progress mysql-5.7.*/share/* /Applications/MAMP/Library/share/ | |
// on this point you have to start MAMP, you should see that MySql is running and after that you can run the last command \\ | |
echo "Migrate, finaly, to new version" | |
sudo /Applications/MAMP/Library/bin/mysql_upgrade --user=root --password=root --port=3306 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --force |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# // Upgrade MAMP 4.1.1 to Mysql 5.7.18 (on OSX Sierra) | |
#!/bin/sh | |
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-macos10.12-x86_64.tar.gz | |
tar xfvz mysql-5.7.18-macos10.12-x86_64.tar.gz | |
echo "Stopping MAMP" | |
sudo /Applications/MAMP/bin/stop.sh | |
sudo killall httpd mysqld | |
echo "Copy Bin" | |
sudo rsync -arv --progress mysql-5.7.*/bin/* /Applications/MAMP/Library/bin/ --exclude=mysqld_multi --exclude=mysqld_safe | |
echo "Copy Share" | |
sudo rsync -arv --progress mysql-5.7.*/share/* /Applications/MAMP/Library/share/ | |
echo "Building Mysql 5.7 Folder" | |
sudo cp -r /Applications/MAMP/db/mysql56 /Applications/MAMP/db/mysql57 | |
sudo rm -fr /Applications/MAMP/db/mysql57/mysql/innodb_* | |
sudo rm -fr /Applications/MAMP/db/mysql57/mysql/slave_* | |
sudo chmod -R o+rw /Applications/MAMP/db/mysql57/ | |
sed -i.bak 's/mysql56/mysql57/g' /Applications/MAMP/Library/bin/mysqld_safe | |
echo "Fixing Access (workaround)" | |
sudo chmod -R o+rw /Applications/MAMP/tmp/mysql/ | |
echo "Starting MySQL" | |
sudo /Applications/MAMP/Library/bin/mysqld_safe --port=3306 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log | |
echo "Migrate, finaly, to new version" | |
sudo /Applications/MAMP/Library/bin/mysql_upgrade --user=root --password=root --port=3306 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --force |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Thanks.
can you create a script for MAMP 4.5?