#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