[MDEV-21376] mysqldump should support wildcards Created: 2019-12-21  Updated: 2022-08-02

Status: Confirmed
Project: MariaDB Server
Component/s: Scripts & Clients
Fix Version/s: 11.0

Type: Task Priority: Major
Reporter: teo teo Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None


 Description   

I have dozens of databases with a given prefix, and I want to take a mysqldump of all of them.

It should be as simple as something like this:
$ mysqldump -u whatever -p --databases prefix_*

but there is no support for wildcards. This is ridiculous. How can you not support wildcards?

The workaround is to write a f***ing script:
https://serverfault.com/questions/442889/wildcard-backup-mysql-databases

Pathetic.



 Comments   
Comment by Alexey Botchkov [ 2021-07-01 ]

It was decided to use LIKE command style syntax for the wildcards.
Also add the --wildcards=ON option to enable/disable that feature.

Comment by Federico Razzoli [ 2022-07-24 ]

Please allow using multiple patterns:

mysqldump --databases xxx% yyy% zzz%

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