Do all databases at once.
Automatic MySQL Database Backups
To get started, create a folder db_backup. For this tutorial I’ve placed db_backupin my home folder. In db_backup create a directory named backups and a text file named backup.bin with the following code replacing the DB and S3 variables at the top with your own information
We’ll be executing this script so we’ll need to set the backup.bin file to be executable and while we’re at it give the script a test run. If you wish to use S3 you’ll also need to add the S3 directory from the tutorial download below.