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