৩০ দিনের পুরানো ফাইল মুছে ফেলা

sudo nano /usr/local/backup-scripts/backup_UniworldHrm_sqlite.sh

#!/bin/bash

# আজকের তারিখ
TODAY=$(date +"%Y-%m-%d")

# সোর্স এবং ডেস্টিনেশন পাথ
SOURCE="/root/UniworldHrm/UniworldHrm/db.sqlite3"
DESTINATION="/backup/files/UniworldHrmBackup/$TODAY"
LOG_FILE="/var/log/UniworldHrmBackup.log"

# ডিরেক্টরি তৈরি
mkdir -p "$DESTINATION"

# লগ ফাইলে শুরুর সময় লেখা
echo "$(date): Starting backup for $SOURCE" >> "$LOG_FILE"

# ব্যাকআপ কপি
cp "$SOURCE" "$DESTINATION/db.sqlite3"

if [ $? -eq 0 ]; then
    echo "$(date): Backup successful: $DESTINATION/db.sqlite3" >> "$LOG_FILE"

    # Google Drive-এ আপলোড
    rclone copy "$DESTINATION/db.sqlite3" UniworldHrm-GoogleDrive:UniworldHrmBackup/$TODAY --progress >> "$LOG_FILE" 2>&1

    if [ $? -eq 0 ]; then
        echo "$(date): Upload to Google Drive (UniworldHrm-GoogleDrive) successful." >> "$LOG_FILE"
    else
        echo "$(date): Upload to Google Drive (UniworldHrm-GoogleDrive) failed!" >> "$LOG_FILE"
    fi
else
    echo "$(date): Backup failed for $SOURCE!" >> "$LOG_FILE"
fi

# ৩০ দিনের পুরানো লোকাল ব্যাকআপ মুছে ফেলা
find /backup/files/UniworldHrmBackup/ -maxdepth 1 -type d -mtime +30 -exec rm -rf {} \; >> "$LOG_FILE" 2>&1
if [ $? -eq 0 ]; then
    echo "$(date): Successfully deleted local backups older than 30 days." >> "$LOG_FILE"
else
    echo "$(date): Failed to delete local backups older than 30 days!" >> "$LOG_FILE"
fi

# ৩০ দিনের পুরানো Google Drive ব্যাকআপ মুছে ফেলা
rclone delete UniworldHrm-GoogleDrive:UniworldHrmBackup --min-age 30d >> "$LOG_FILE" 2>&1
if [ $? -eq 0 ]; then
    echo "$(date): Successfully deleted Google Drive backups older than 30 days." >> "$LOG_FILE"
else
    echo "$(date): Failed to delete Google Drive backups older than 30 days!" >> "$LOG_FILE"
fi

# লগ ফাইলের সাইজ ম্যানেজ করা (১০০০ লাইনের বেশি হলে পুরানো লাইন মুছে ফেলা)
if [ $(wc -l < "$LOG_FILE") -gt 1000 ]; then
    tail -n 1000 "$LOG_FILE" > "$LOG_FILE.tmp" && mv "$LOG_FILE.tmp" "$LOG_FILE"
    echo "$(date): Log file trimmed to last 1000 lines." >> "$LOG_FILE"
fi

sudo chmod +x /usr/local/backup-scripts/backup_UniworldHrm_sqlite.sh

sudo /usr/local/backup-scripts/backup_UniworldHrm_sqlite.sh

   ls -l /backup/files/UniworldHrmBackup/$(date +"%Y-%m-%d")/db.sqlite3

   rclone lsd UniworldHrm-GoogleDrive:UniworldHrmBackup/$(date +"%Y-%m-%d")

   tail -f /var/log/UniworldHrmBackup.log

   Sat Aug  2 20:15:01 +06 2025: Starting backup for /root/UniworldHrm/UniworldHrm/db.sqlite3
   Sat Aug  2 20:15:01 +06 2025: Backup successful: /backup/files/UniworldHrmBackup/2025-08-02/db.sqlite3
   Sat Aug  2 20:15:02 +06 2025: Upload to Google Drive (UniworldHrm-GoogleDrive) successful.
   Sat Aug  2 20:15:02 +06 2025: Successfully deleted local backups older than 30 days.
   Sat Aug  2 20:15:03 +06 2025: Successfully deleted Google Drive backups older than 30 days.

crontab -l

0 2 * * * /usr/local/backup-scripts/backup_UniworldHrm_sqlite.sh >> /var/log/UniworldHrmBackup.log 2>&1

sudo crontab -e

tail -f /var/log/UniworldHrmBackup.log

Sat Aug  2 20:15:01 +06 2025: Starting backup for /root/UniworldHrm/UniworldHrm/db.sqlite3
Sat Aug  2 20:15:01 +06 2025: Backup successful: /backup/files/UniworldHrmBackup/2025-08-02/db.sqlite3
Sat Aug  2 20:15:02 +06 2025: Upload to Google Drive (UniworldHrm-GoogleDrive) successful.
Sat Aug  2 20:15:02 +06 2025: Successfully deleted local backups older than 30 days.
Sat Aug  2 20:15:03 +06 2025: Successfully deleted Google Drive backups older than 30 days.

   rclone copy UniworldHrm-GoogleDrive:UniworldHrmBackup/$(date +"%Y-%m-%d")/db.sqlite3 /tmp/test.sqlite3
   sqlite3 /tmp/test.sqlite3 "SELECT * FROM sqlite_master;"