NOWT=$(date +"%Y-%m-%d")
FILE="/opt/DBBackup/TRAINING-DB-$NOWT.sql"
mysqldump --login-path=local training > $FILE
IP=192.168.0.113
scp $FILE root@$IP:/opt/DB_STORE
Now finally we need to change the file permission for the script to be executable as follows:
# chmod 744 /usr/backup-scripts/databasebackup.sh