#Backup XtreamUI to GoogleDrive - 30 Days retention

Login to XtreamUI Via Putty

#Install Rclone:

curl -O https://downloads.rclone.org/rclone-current-linux-amd64.zip
unzip rclone-current-linux-amd64.zip
cd rclone-v1.50.2-linux-amd64/
cp rclone /usr/bin/
chmod 775 /usr/bin/rclone

#Config Rclone

rclone config
n (new Remote)
GoogleDrive
Option 13

Blank
Blank
1) Full accees

Manually create Folder in Google Drive called XtreamUI - Use Windows Machine




Create BackupUI.sh in /var/ with the following:-

#####################################################################################################################
/usr/bin/mysql -uroot -p##PASS## -hlocalhost -Dxtream_iptvpro -e"TRUNCATE TABLE client_logs"
/usr/bin/mysql -uroot -p##PASS## -hlocalhost -Dxtream_iptvpro -e"TRUNCATE TABLE stream_logs"
/usr/bin/mysql -uroot -p##PASS## -hlocalhost -Dxtream_iptvpro -e"TRUNCATE user_activity"

mysqldump -u root -p##PASS## xtream_iptvpro | gzip > /home/backups/xtreamui-$(date +%d_%m_%Y_%H_%M_%S).gz

#Sync Files to Google Drive
rclone sync /home/backups 'GoogleDrive':XtreamUI

#Remove all Files older than 30 days from local Server
find /home/backups -mtime +30 -delete
#####################################################################################################################

Add this to crontab

0 4 * * * sh /var/BackupUI.sh