1

I have a sql dump file generated by mysqldump of mariadb 10.2.

I want to set up a new db server using mariadb 10.4 with data coming from the sql dump file.

Is the upgrade process necessary in this case? If so, should I first restore the sql file into db and then run mysql_upgrade or somehow directly upgrade the sql file and then restore into the db?

hgl
  • 2,034
  • 4
  • 21
  • 30

1 Answers1

1

Well I would suggest that you follow the upgrade guides given on the MariaDb website. See Upgrading MariaDB. It lists articles on upgrading from one major version of MariaDb to the next.

There is no guide for directly upgrading from version 10.2 to 10.4, so you should first upgrade from 10.2 to 10.3 by following Upgrading from MariaDB 10.2 to MariaDB 10.3. Then upgrade from 10.3 to 10.4 by following Upgrading from MariaDB 10.3 to MariaDB 10.4.

Make sure to read the incompatibilities between the major versions

Nadir Latif
  • 3,690
  • 1
  • 15
  • 24
  • Thanks, hopes there is a more direct way. – hgl Oct 17 '19 at 08:08
  • Well the method I outlined seems to be the recommended way of upgrading MariaDb. If your SQL dump files does not contain constructs such as triggers and innodb configuration that might be incompatible across versions, then simply importing the SQL dump file should work – Nadir Latif Oct 17 '19 at 08:50