How to upgrade mariadb 10.0 to 10.2?


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.

Submit an answer

This textbox defaults to using Markdown to format your 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 or Sign Up to Answer

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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