[Toolserver-l] Schema-only database backups

[River Tarnell]

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