File: //scripts/autoDumpMySQL.sh
#!/bin/bash
TODAY=`date +%F-%H-%M-%S`
DIR="/data/BACKUP/MySQLDump"
mysqldump -u root --all-databases --single-transaction --quick --lock-tables=false > $DIR/full-backup-$TODAY.sql
tar -I pigz -cvf $DIR/full-backup-$TODAY.sql.tar.gz $DIR/full-backup-$TODAY.sql
rclone sync -vv -P $DIR/full-backup-$TODAY.sql.tar.gz GDrive-Karmanye:'Karmanye/DevOpsYes/ServerBackup/5.9.111.147/MySQLDump/' --fast-list --checkers=20 --transfers=32 --tpslimit=32 --drive-chunk-size 256M
rm -rf $DIR/full-backup-$TODAY.sql