MySQL backups

[Mark Komarinski]

A few thoughts:

- have a MySQL slave system that you can shut down for backup purposes.  Doesn't have to be beefy, just enough disk space to store the DB.
- mysqldump is your friend.
- I think that you can sort-of hot backup MyISAM tables,  and there's a hot backup utility for InnoDB.
-there is a process for using innodb file per table and then locking per table and backing up the underlying tablespace files.

We use mysqldump with a role account that has backup privileges on the databases that we can't easily recreate.  Works pretty well though I'll change it to back up one database per file.

-Mark