Automatic DB backup and email

[reds]

Has anyone made a script for this yet to automatically backup and email the database on the nightly cronjob?

 

Would be really useful.

 

Thanks.

[Adam]

Hey,

 

I think this should be left up to you to do, or at least you should already have backups enabled on your server.

 

You can enter the following cronjob command which will do the trick.

 

mysqldump -u username -h localhost -pPASSWORD database_name | gzip -9 > /home/USERNAME/backup_db.sql.gz

 

the password has to be RIGHT next to the -p part with no spaces. Replace database_name with the database name. Replace username with the username for mysql.

 

From,

Adam

[reds]

Thanks Adam, I'll have a look at that. I understand what you're saying about backups should bealready enabled ... but I'd like the extra ability to have it email me a copy every night aswell.