Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3.15, 10.4.5
-
None
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
- relates to
-
MDEV-23630 mysqldump to logically dump system tables
- Closed
-
MDEV-19559 Provide SHOW commands for SERVERs
- Open