The Ultimate Guide to High Availability with MariaDB

New to MariaDB Upgrade Problems on Windows OS

You are viewing an old version of this question. View the current version here.

I have installed MariaDB 10.4 and 10.11 on a test workstation, created a blank DB in 10.4, stopped all MariaDB services then copied the entire 10.4 data folder and had it overwrite the 10.11 data folder location. I started the MariaDB services and see the test DB listed when I run Show Databases; . The problem is when I run mariadb-upgrade I get the following errors: mysql/gtid_slave_pos is correct, mysql.innodb.index_stat does not exist etc....

I am practicing the upgrade since I will be moving a MariaDB 10.2 to 10.11 but could not find a 10.2 download. Where did I go wrong with this process? From what I have read running mariadb-upgrade is required when copying the DB's to a new version.

Answer Answered by Vladislav Vaintroub in this comment.

Those errors you see do not prevent the database from starting, and are fixed by running mariadb-upgrade. mariadb-upgrade is there exactly to fix the missing and incorrect (in the target version) system tables.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.