SQL-Backup

Advance MySQL Database Backup Script

In this repository, you will get an advance MySQL database backup script with mutiple options. This script allows you to backup databases on local and upload to FTP, SFTP and S3 bucket.

Clone this repository

Clone this repository under /etc directory.

cd /etc/

git clone https://github.com/ghost717/sql-backup

Configure setup

Edit settings.conf file and update all requied values as per your requirements. You can enable/disable FTP, SFTP backups here.

Now edit credentials.txt file and put your mysql server login details

Execute backup script

Run the following commands step by step to execute this script.

cd /etc/sql-backup

chmod a+x mysql-dump.sh

./mysql-dump.sh

Schedule daily cron

You can also schedule this to run on daily basis using crontab. Add the following settings to crontab to run on 2:00 AM daily.

0 2 * * * cd /etc/sql-backup && ./mysql-dump.sh

Source

• Crontab

• Source1

• Source2