Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.3.12
-
None
-
linux 64
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.
Attachments
Issue Links
- is duplicated by
-
MDEV-17429 mysqldump uses 10.3 options with pre-10.3 servers and breaks
- Closed