Score:-1

MariaDB - Emulate MySQL 5.7 version number?

cn flag

I have been running MariaDB 5.5 on a linux server for several years. Yesterday, I upgraded to MariaDB 10.11.3.

Now, my backup software has stopped backing up the databases, reporting an error that "MySQL 10.11 is not supported".

Since the backup software supports MySQL, it is likely expecting to receive version 5.7 from the server, and is being confused by receiving version 10.11.3.

Is there any way to make MariaDB report version 5.7, to make the backup software think we're running MySQL 5.7? Since MariaDB 10.11 and MySQL 5.7 are basically compatible (if using the same storage engines) it shouldn't present a problem to back up, but reporting 5.7 will persuade the backup software to continue running.

ua flag
What backup software? Let's see the actual error messages in context.
cn flag
@RickJames The backup software is N-Able Cove Data Protection (https://www.n-able.com/products/cove-data-protection) There is no context to the error message: it's the only error message. The exact error message is: "Unsupported version of MySQL server: 10.11.3.0" When the app attempted to run the last backup after the upgrade, this happened. Their support states that "mariadb is not supported".
Score:6
in flag

Quote from the documentation:

Some old legacy code may break because they are parsing the VERSION string and expecting a MySQL string or a simple version string like Joomla til API17, see MDEV-7780.

From MariaDB 10.2, one can fool these applications by setting the version string from the command line or the my.cnf files with --version=....

cn flag
Exactly what I was looking for! I will try this next time the database can be restarted to apply the change. Thanks!
I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.