-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Hi,

It is now possible to mark a user database to be backed up without its data, i.e. only the schema is dumped (mysqldump -d). To do this, include the string "_transient" in the database name:

u_jsmith_transient u_jsmith_my_transient_data_p

If you have databases whose data doesn't need to be backed up, it would be very helpful if you could rename them to include _transient in the name, to reduce the load / disk space requirements of the nightly backup job.

Unfortunately MySQL doesn't provide a way to rename a database, but you can copy the database to a new name like this:

$ mysqladmin create u_jsmith_transient $ mysqldump --opt u_jsmith | mysql u_jsmith_transient

The old database should then be dropped.

- river.