Cron jobs auto backup mysql?

[magicstruck44]

Hi all

I am trying to use a cron job to automatically back up my DB, compress it and email it to myself... This is the script: http://www.tamba2.org.uk/wordpress/cron/

I have set it to run every 1 day.

Is it possible?

However i got an error on first run:

mysqldump: Got error: 1045: Access denied for user 'xxxx_main'@'localhost' (using password: YES) when trying to connect
/home/xxxx/etc/cronjob2.sh: line 48: mutt: command not found

Seems like the server does not have "mutt" installed to send email attachments?

Any workarounds?

 

[magicstruck44]

no workaround?

do you all use cron to automatically back up your db's or files? if so what method do you use?