MySQL Bugs: #70592: mysqldump --ignore-schema feature wanted

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:	None
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

Description:
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

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?

And --ignore-wild-table would also be nice ... could even be used as replacement for --ignore-schema by saying "--ignore-wild=some_schema.%" ...

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

Hello Oli,

Thank you for the feature request!

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

Thanks,
Umesh

Closed by mistake, sorry. Reopened. -Stefan

I will like to know the status of this feature request.