Hi.
I run wordpress website using Ubuntu 16.04 + Nginx + Mariadb 10.0.x + Php7.
I saw article about upgrade mariadb from 10.0 to 10.1. but i cant find to 10.2
Same as 10.1? or Do I need to upgrade to 10.1 and then upgrade to 10.2 again?
Please let me know how do i that
Thank you.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!
The suggested upgrade procedure is:
Set innodb_fast_shutdown to 0 (this step is not necessary when upgrading to MariaDB 10.2.5 or later - omitting it can make the upgrade process far faster - see MDEV-12289). Shutdown MariaDB 10.1, Take a backup (this is the perfect time to take a backup of your databases) Uninstall MariaDB 10.1 Install MariaDB 10.2 [2] Run mysql_upgrade Ubuntu and Debian packages do this automatically when they are installed; Red Hat, CentOS, and Fedora packages do not mysql_upgrade does two things: Upgrades the permission tables in the mysql database with some new fields Does a very quick check of all tables and marks them as compatible with MariaDB 10.2 In most cases this should be a fast operation (depending of course on the number of tables) Add new options to my.cnf to enable features If you change my.cnf then you need to restart mysqld