-----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.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (SunOS)
iEYEARECAAYFAk3OGlQACgkQIXd7fCuc5vKdsQCaAwWY3LJ/H4+JcvB0x7VHTyzS
VSMAnjVCQBvlfOVG/2DmLtUz0c9EUe5Y
=sB8i
-----END PGP SIGNATURE-----