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

© 2003-17 iNeta d.o.o. | Koroška cesta 31, SI-4000 Kranj | info@ineta.si | Pravno obvestilo
Powered by BravoCMS