MySQL backup question

[mhalloran]

Is there any way that I can use a mysqldump command to export ALL databases EXCEPT for one? I don't want to have to list all.

Thanks

[bastien]

phpmyadmin gives you an easy way to choose the dbs you want to dump...

or simply list them in the command line as per the manual

shell> mysqldump [options] --databases DB1 [DB2 DB3...]

[mhalloran]

Thanks but this is actually a command that's part of a cronjob (run daily) so I can't do it through phpMyAdmin.

The reason I don't want to add each database individually is because I'm constantly adding and removing databases and I don't want to update the script every time.

It seems crazy but here's what I think I have to do for this to work.

(as root)
mysql -uroot -ppass<CREATE TABLE master_db.db_names AS SELECT Db FROM mysql.db

and then export the new table and create the dump statement based on the contents.

Is there an easier way?

[bastien]

that's pretty slick and should suit your needs well