Arch Linux

Fandekasp

Member

From: Japan

Registered: 2012-02-12

Posts: 25

Website

[SOLVED] Cannot downgrade MariaDB from 10.3 to 10.2

Hi,

My routine commands to update local dbs from a staging broke as follow

$ /usr/bin/mysqldump -uroot -p${password} -h127.0.0.1 -P3306 db --routines --triggers --no-data --result-file=/tmp/db_schema_${date}.sql                                                         
mysqldump: Couldn't execute 'SHOW PACKAGE STATUS WHERE Db = 'db'': You have an error in your SQL

I then came upon this SO thread which explains that MariaDB 10.3 doesn't work with MySQL 5.6.
My GCP Cloud SQL instance is running Mysql 5.7, and I can't see a specific incompatibility regarding SHOW PACKAGE STATUS.

I tried to downgrade the packages mariadb mariadb-clients and mariadb-libs, but could only downgrade up to 10.3.12-1, which fails as well.
I would like to downgrade to 10.2.6-2, but only the packages mariadb and mariadb-clients have an available package mariadb-clients-10.2.6-2-x86_64.pkg.tar.xz.  mariadb-libs's oldest available package is mariadb-libs-10.3.12-1-x86_64.pkg.tar.xz , and I can't downgrade mariadb because of libs.

Do you have a solution for me to get things done, ie backup my db via mysqldump ?
Thanks in advance

Last edited by Fandekasp (2019-03-01 07:00:25)

chr0mag

Member

From: Vancouver, Canada

Registered: 2017-02-02

Posts: 94

Re: [SOLVED] Cannot downgrade MariaDB from 10.3 to 10.2

mariadb-libs was renamed from libmariadb at some point. That could be a messy downgrade though so you may want to follow this.

Another simpler option may be to install the MySQL version you need from the AUR.

Fandekasp

Member

From: Japan

Registered: 2012-02-12

Posts: 25

Website

Re: [SOLVED] Cannot downgrade MariaDB from 10.3 to 10.2

chr0mag, thanks for the perfect answer <3