Sorry if this has been answered before (I couldn't find it, if so). I'm just wondering how this is different from doing a 'mysqldump', running it from cron, and specifying a copy to be sent via email.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
AutoMySQLBackup is a script that uses mysqldump. As you mentioned, it can e-mail the report and/or backup. It can dump all of your databases, so you do not have to edit anything after creating a new database; I particularly enjoy this feature. It also compresses the backups and rotates them; these could be done with logrotate, but you would writing your own script at that point.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sorry if this has been answered before (I couldn't find it, if so). I'm just wondering how this is different from doing a 'mysqldump', running it from cron, and specifying a copy to be sent via email.
AutoMySQLBackup is a script that uses mysqldump. As you mentioned, it can e-mail the report and/or backup. It can dump all of your databases, so you do not have to edit anything after creating a new database; I particularly enjoy this feature. It also compresses the backups and rotates them; these could be done with logrotate, but you would writing your own script at that point.