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.
Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Sign in to AnswerThese 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.
Try DigitalOcean for free
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