Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
MariaDB - enable root login via both UNIX_SOCKET and TCP Question Question
Errors with migrating from MariaDB 10.0 to 10.1 Question Question

Question

How to upgrade mariadb 10.0 to 10.2?

Posted August 17, 2017 10.3k views
MariaDBUbuntu 16.04

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.

Add a comment
junukseo
By:
junukseo

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
MariaDB - enable root login via both UNIX_SOCKET and TCP Question Question
Errors with migrating from MariaDB 10.0 to 10.1 Question Question

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.

×
Submit an Answer
1 answer
mm580486 August 18, 2017

The suggested upgrade procedure is:

Set innodbfastshutdown 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 mysqlupgrade
Ubuntu and Debian packages do this automatically when they are installed; Red Hat, CentOS, and Fedora packages do not
mysqlupgrade 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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help