[MDEV-18312] mysqldump fails to work on any lower-version of mariadb Created: 2019-01-19  Updated: 2019-01-19  Resolved: 2019-01-19

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.3.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Philip orleans Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

linux 64


Issue Links:
Duplicate
is duplicated by MDEV-17429 mysqldump uses 10.3 options with pre-... Closed

 Description   

In my central office, I have the latest version of Mariadb, 10.3, but I want to connect to all production servers and get a backup of all the objects, not data, from a single point. It turns out it's impossible to use mysqldump on any other version, like 10.2 because it uses ad-hoc commands that fail.
This is a bug. There is a flag called --compatible, and it does not consider the commands sent, only the output when it should also consider the commands sent to the server. We all need a version of mysqldump that can talk any version of mariadb, using the compatible flag.
Right now I face the task of creating three boxes to get a backup, one for each major version of MySQL. As you probably imagine, once an application is in production with a certain version, it never gets updated.



 Comments   
Comment by Elena Stepanova [ 2019-01-19 ]

Thanks for the report. We have one for it already, MDEV-17429, I suggest to track it there. Please comment there it if you have anything to add.

Generated at Thu Feb 08 08:43:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.