How to automatically make backups mysql?

I use a bunch of "cron + mysqldump + dropbox" from the automated delivery of backup on my machine and backup storage in the cloud.

If such questions arise, it is worth a try
\rSypex Dumper.
He of course still beta, but works very stable. Able to run from the crown and to fill in the files on the FTP anywhere. Sending soap you can implement yourself)

try www.opennet.ru/dev/fsbackup/

Avoiding all the database in a loop and remove the dumps
\r

#!/bin/bash USER="root" PASSWORD="123123" mkdir /var/backup/database/`date +%F`; for DB in `mysql-u$USER-p$PASSWORD -N-e 'show databases' | awk '{print $1}"; do mysqldump --user=$USER --host=$HOST --password=$PASSWORD ${DB} | gzip > /var/backup/database/`date +%F`/${DB}.sql.gz; echo "${DB} Backup"; done done 

not aesthetically pleasing =) but... p.s. (true for small databases, lock tables locks base in the dump process)
bash script to add in cron:
\r

#!/bin/sh mysqldump -u -p --lock-tables --opt  > /sqldata/dump.sql cd /sqldata/ tar-zcvf sqldata.tgz,*.sql perl sendtoemail.pl 

The script requires the folder /sqldata, sendtoemail.pl is in /sqldata.
\r
the contents sendtoemail.pl requires MIME::Lite:
\r

#!/usr/bin/perl -w use MIME::Lite; $msg = MIME::Lite->new( From => 'backup@wailaowai.com', To => 'me@wailaowai.com', Subject => 'sqldata.tgz MySQL backup!', Type => 'text/plain', Data => "Here are the MySQL database backups."); $msg->attach(Type=>"application/x-tar", Path =>"/sqldata/sqldata.tgz", Filename =>"sqldata.tgz"); $msg->send; 

Can recommend as well AutoMySQLBackup.
To configure and hang in CZK. Can send dumps to email — setting MAILCONTENT="files" you need to get started mutt.