How do I backup a database using a cron job and send it by mail?

[nic_net]

How can i do a database backup using a cron job and send it by mail?

Hello,

I would like to backup only a database (forum.gz) using a cron job and them send the file by mail to a gmail account.

What should I type in the command line ?? Please help me!

I really appreciate it if someone replied .

Thanks

 

[Stefaans]

This seems like the script what you are looking for: http://members.lycos.co.uk/wipe_out/automysqlbackup/

 

[nic_net]

I do it:

# Nico backup 1.0
# 29-11-06

# Email donde se enviara
EMAIL="[email protected]"

# Orden de crear el backup
mysqldump --opt -u USERNAME -pPASSWORD DBNAME >>  /home/backups/file1.sql

# Variable fecha
DATE=`date +%Y%m%d`

# De .sql a .gz
gzip file1.sql

# Renombro con la fecha el .gz
mv file1.sql.gz backup-$DATE.sql.gz

# Envio por e-mail
echo 'Aqui tienes el backup de hoy.' | mutt -a backup-$DATE.sql.gz $EMAIL -s "MySQL Backup"