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 under /etc directory.
cd /etc/
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
Run the following commands step by step to execute this script.
cd /etc/database_dump
chmod a+x mysql-dump.sh
./mysql-dump.sh
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/database_dump && ./mysql-dump.sh
https://tecadmin.net/bash-script-mysql-database-backup/
https://tecadmin.net/advance-bash-script-for-mysql-database-backup/