Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21376

mysqldump should support wildcards

    XMLWordPrintable

Details

    • Q2/2025 Development, Q3/2025 Maintenance

    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.

      The workaround is:
      https://serverfault.com/questions/442889/wildcard-backup-mysql-databases

      This is a very likely use case and should be implemented.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37099 mysqldump --wildcards=on should not try to do dump of the information_schema

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37130 Mysqldump --wildcards=ON without --database option accepts wildcards in database names

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37131 Mysqldump -L with a list of patterns should return 1 copy of db (or table), even if it fits multiple patterns

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37134 mysqldump --wildcards=on -L -B forms query with the syntax error, when there are no db, that should be returned

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37196 Memory leaks after calling mysqldump -L

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37242 Memory leaks after calling mysqldump -L when nothing matches pattern

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-37246 mysqldump -L should work with --ignore-database

          • Major - Major loss of function.
          • Closed
          links to

          Web Link MDEV-21376 mysqldump should support wildcards #1915

          Activity

            People

              alice Alice Sherepa
              php4fan teo teo
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.