Mysql Backups

How do most users backup thier databases? I know I can do a SQL dump, but I was hoping to have a more automated process.

I’ve often thought it would be nice to have Backup Database and Restore Database From Backup options on the MySQL tab of the DreamHost Control Panel. It would certainly be useful (especially for “db noobs”), and I know that certain panel packages (such as CPanel) offer things like that.

Simon Jessey
Keystone Websites | si-blog