Shell Script To Backup MySql Database Server

in Categories Backup, MySQL last updated March 12, 2010

Save the script and run it as a cron job:
@daily /path/to/

Share this on:

55 comment

  1. This is a really nice script although I did some changes for it, nothing major:

    – Commented the CHOWN. For some reason is was doing a root wide CHOWN, being that I am not running the backups as root, I do not need to CHOWN the files anyway, they’ll be owned by the administrative account.
    – I had to add the list of databases that I wanted not to back up, I though that just adding the ones that I wanted would exclude the ones that I did not wanted to.

    But, it is a very handy script and I appreciate you posting it. Thanks.

    Have a question? Post it on our forum!