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