Bug #3528 mysqldump: dump all tables except a few given
Submitted: 21 Apr 2004 14:50 Modified: 7 Oct 2005 22:28
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:* OS:Any (*)
Assigned to: CPU Architecture:Any

[21 Apr 2004 14:50] Olaf van der Spek

My database contains a few large tables that are used as cache and don't need to be dumped. I could manually list all tables except those at the command line, but then I'd have to update all scripts each time I add a normal table.
And of course you find out you forgot to do that once you really need the backup.
So I'd like to have an option to have mysqldump dump all tables of a given database, except a few I give at the command line.

How to repeat:
[7 Oct 2005 22:28] Hartmut Holzgraefe
This request is very similar to bug #3228 so extended that one to include tables, too
and closed this one as duplicate