Skip to content

Instantly share code, notes, and snippets.

@aboritskiy
Created June 12, 2018 21:50
Show Gist options
  • Save aboritskiy/bbfdb2e5e62af490411926e32b3b471f to your computer and use it in GitHub Desktop.
Save aboritskiy/bbfdb2e5e62af490411926e32b3b471f to your computer and use it in GitHub Desktop.
MySQL Upgrade Amazon Linux
mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"
mysqladmin -u root -p shutdown
sudo yum remove mysql55\*
sudo yum install mysql56-server
sudo service mysqld start
sudo mysql_upgrade -u root -p
sudo service mysqld restart
https://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql
https://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html
https://forums.aws.amazon.com/thread.jspa?messageID=759356
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment