crontab entry:
0 1 * * 1,3,5 /usr/bin/mysqldump -q -u username -p"password" databasename > /tmp/file.sql;gzip /tmp/file.sql;/var/www/email.pl
email.pl
Code:
#!/usr/bin/perl -w
use MIME::Lite;
$msg = MIME::Lite->new(
From => 'user@domain.com',
To => 'user@domain.com',
Subject => 'mysql backup',
Type => 'text/plain',
Data => "backups attached");
$msg->attach(Type=>'application/x-tar',
Path =>"/tmp/file.sql.gz",
Filename =>"file.sql.gz");
$msg->send;