I'm sure it could be automated with:
[b:e192a31463]mysqldump --all-databases --compress & file[/b:e192a31463]
I use this on our server, without problems.
You may want to use --lock-tables and --flush-logs too...
Ronnie
http://AlwaysWebHosting.com