Can I get a dump of all my databases *except one* using mysqldump?

Question

I'm currently using mySQLdump to backup my dev machine and servers.

There is one project I just started, however, that has a HUUUUUGE database that I don't really need backed up, and i'll be a big problem to add it to the rest of the backup cycle.

I'm currently doing this:

"c:\Program Files\mysql\MySQL Server 5.1\bin\mysqldump" -u root -pxxxxxx --all-databases > g:\backups\MySQL\mysqlbackup.sql

Is it possible to somehow specify "except this database(s)"?

I wouldn't like to have to specify the list of DBs manually, since that would mean that I'd have to remember updating my backup batch file every time I create a new DB, and I know that's not gonna happen.

EDIT: As you probably guessed from my command line above, i'm doing this on Windows, so I can't do any kind of fancy bash stuff, only wimpy .bat things.

Alternatively, if you have other ideas to solve this same issue, they are more than welcome, of course!

Answer 1

mysql ... -N -e "show databases like '%';" |grep-v -F databaseidontwant |xargsmysqldump ... --databases > out.sql

Answer 2

Create a backup user and only grant that user access to the databases that you want to backup.

You still need to remember to explicitly grant the privileges but that can be done in the database and doesn't require a file to be edited.

Answer 3

What about

--ignore-table=db_name.tbl_name

Do not dump the given table, which must be specified using both the database and table names. To ignore multiple tables, use this option multiple times.

Maybe you'll need to specify a few to completely ignore the big database.