[MDEV-19558] Dump "mysql" system database first on "mysqldump --all-databases" Created: 2019-05-22  Updated: 2020-08-30

Status: Open
Project: MariaDB Server
Component/s: Backup, Scripts & Clients
Affects Version/s: 10.3.15, 10.4.5
Fix Version/s: 10.3

Type: Bug Priority: Minor
Reporter: Hartmut Holzgraefe Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-23630 mysqldump to logically dump system ta... Closed
relates to MDEV-19559 Provide SHOW commands for SERVERs Open

 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 ....


Generated at Thu Feb 08 08:52:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.