Mettre à niveau MySQL 5.5 vers MySQL 5.6 - ubuntu 14.04

sudo service apache2 stop

mysqldump -p --lock-all-tables --events --all-databases > toutes_les_BDs.sql 

wc -l toutes_les_BDs.sql

sudo cp /etc/mysql/my.cnf{,_original}

sudo apt-get update

sudo apt-get remove mysql-server

sudo apt-get autoremove

sudo apt-get install mysql-client-5.6 mysql-client-core-5.6

sudo apt-get install mysql-server-5.6

sudo mysql -p -u root < toutes_les_BDs.sql 

sudo service apache2 start