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

Dump "mysql" system database first on "mysqldump --all-databases"

    XMLWordPrintable

Details

    Description

      When doing mysqldump --all-databases, databases are simply dumped in alphabetical order.

      I'd like to suggest to make an exception for the "mysql" system database, dumping that first, and emitting a FLUSH PRIVILEGES to the dump stream right after that, before proceeding to dump all user defined databases.

      That way it would e.g. become possible to restore dumps that contain FederatedX tables that refer to specific mysql.servers entries, which is otherwise not possible with mysqldump yet as we are missing SHOW CREATE SERVER and SHOW SERVERS equivalents to CREATE SERVER ....

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              hholzgra Hartmut Holzgraefe
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.