Backup MySQL DB
# Take Database Dump wget https://raw.githubusercontent.com/MiteshShah/admin/master/backup/mysqldump.sh bash mysqldump.sh # Cross check database dump ls /var/www/mysqldump mkdir -p /backup/mysql/data service mysql stop cp -av /etc/mysql /backup cp -av /var/www/mysqldump /backup/mysql cp -av /var/lib/mysql/ /backup/mysql/data
Remove MySQL 5.5 Packages
apt-get purge mysql-server* apt-get autoremove
Install Percona MySQL 5.6
ee stack install mysql
Install PV command:
apt-get update apt-get install pv
Import Database:
cd /var/www/mysql gunzip * pv example_com.13Oct2014142434 | mysql example_com
How to revert
In any case you can face some issue, you can revert it using following commands:
Remove Percona MySQL 5.6
ee stack purge mysql
Install MySQL 5.5
apt-get install mysql-server
Import Database
cd /var/www/mysqldump
gunzip * pv example_com.13Oct2014142434 | mysql example_com