You can edit the script below in accordance with the needs in your infrastructure for having any of the databases nested in your MySQL server to be backuped and copied to a preferred location. You may define this script inside the crontab and install it to make these backup operations performed periodically. If you’re in a search of a central backup solution to store, manage and have these backups reported regularly in same or in a different server at remote locations, I recommend you to read the article about my project named Automatic Backup And Synchronization Solution with Rsync On FreeBSD.

more