Ubuntu serverda Laravel yoki Yii2 ilovasi va MySQL ma’lumotlar bazasining har haftalik avtomatik backup (zaxira nusxa) jarayonini sozlash

backup.sh

#!/bin/bash

# Sana
DATE=$(date +"%Y-%m-%d")

# Papkalar
BACKUP_DIR="/mnt/OSPanel/domains/backups"
DB_NAME="dbname"
DB_USER="ustadev"
DB_PASS="ustadev"
APP_DIR="/mnt/OSPanel/domains/yii2-basic-phone"

# Papkani yaratish
mkdir -p $BACKUP_DIR

# 1. MySQL zaxira nusxasi
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/db_backup_$DATE.sql

# 2. Laravel yoki Yii2 fayllari backup
tar -czf $BACKUP_DIR/yii2-basic-phone_$DATE.tar.gz $APP_DIR

# 3. Eski 30 kundan ortiq backuplarni o'chirish
find $BACKUP_DIR/* -mtime +30 -exec rm {} \;