MySQL upgrade

1. dump mysql database

   mysqldump -uroot -p mysql > mysql.sql

2. dump other databases

   mysqldump -uroot -p –-routines --events --all-databases --ignore-table=mysql --ignore-table=performance_schema > db-srv.sql

3. shutdown mysql

   mysqladmin -uroot -p shutdown

4. install new version of mysql
5. import and upgrade mysql database

   mysql -uroot -p mysql < mysql.sql
   mysql_upgrade -uroot -p --force

6. import other databases and check them

   mysql -uroot -p < db-srv.sql
   mysql_check --all-databases
   

7. [windows] disable auto run old mysql service