Bug #70592 mysqldump --ignore-schema feature wanted
Submitted: 10 Oct 2013 16:44 Modified: 13 Jan 2015 15:11
Reporter: Oli Sennhauser Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:5.6 OS:Any (n.a.)
Assigned to: CPU Architecture:Any
Tags: IGNORE, mysqldump, schema

[10 Oct 2013 16:44] Oli Sennhauser
Our customer asked for the mysqldump --ignore-schema=... features similar to --ignore-table feature

How to repeat:
Our customer asked for the mysqldump --ignore-schema=... features similar to --ignore-table feature
[11 Oct 2013 16:55] Hartmut Holzgraefe
Also a general "--ignore-system-tables" option could be nice (that ignores "mysql", "information_schema", "performance_schema" and the "ndb*" specific stuff if the mysqld being dumped is MySQL Cluster one?
[11 Oct 2013 16:56] Hartmut Holzgraefe
And --ignore-wild-table would also be nice ... could even be used as replacement for --ignore-schema by saying "--ignore-wild=some_schema.%" ...
[11 Oct 2013 17:02] Hartmut Holzgraefe
Thinking even further PERFORMANCE_SCHEMA.TABLES and PERFORMANCE_SCHEMA.SCHEMATA could maybe expose whether a certain table or database is considered being a "system" one? 

This way a --igore-system-tables implementation wouldn't even have to know which tables and databases to ignore (like current mysqldump has to know not to dump I_S starting with 5.0, and P_S starting with 5.1) but could simply ask the server it is about to dump what to exclude? 

Hm ... would actually need two different kinds of flags then? One for "System table, restorable" and one for "System table, dynamic, not restorable" ... default operation would then be to exclude only the later class of tables/schemata and with --ignore-system-tables also the former would be excluded, too ...

Time to actually break this out into a separate feature request ...
[28 Jan 2014 8:07] MySQL Verification Team
Hello Oli,

Thank you for the feature request!

Duplicate of internally reported FR - Bug 12741390 : SUPPORT TO INCLUDE IGNORE SCHEMA OPTION IN MYSQLDUMP

[13 Jan 2015 15:11] Stefan Hinz
Closed by mistake, sorry. Reopened. -Stefan
[6 Feb 2020 10:06] Shantanu Oak
I will like to know the status of this feature request.