mirror of
https://github.com/myronblair/do-server-config
synced 2026-06-30 17:50:59 -05:00
DO Server Backup
36 lines
1.3 KiB
Bash
Executable File
36 lines
1.3 KiB
Bash
Executable File
#!/bin/bash
|
|
BACKUP_DIR="/home/tomtomgames.com/backups"
|
|
SITE_DIR="/home/tomtomgames.com/public_html"
|
|
DB_NAME="tomt_ttg_db"
|
|
DB_USER="tomt_ttg_user"
|
|
DB_PASS='q#q+mrOcozsa7I6J'
|
|
DATE=$(date +%Y-%m-%d_%H-%M-%S)
|
|
SQL_FILE="/tmp/ttg_db_${DATE}.sql"
|
|
ZIP_FILE="${BACKUP_DIR}/ttg_backup_${DATE}.zip"
|
|
|
|
mkdir -p "$BACKUP_DIR"
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] Starting backup..."
|
|
|
|
/usr/bin/mysqldump -u "$DB_USER" "-p${DB_PASS}" "$DB_NAME" > "$SQL_FILE" 2>&1
|
|
if [ $? -ne 0 ] || [ ! -s "$SQL_FILE" ]; then
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] ERROR: Database export failed"
|
|
rm -f "$SQL_FILE"; exit 1
|
|
fi
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] Database exported ($(du -sh "$SQL_FILE" | cut -f1))"
|
|
|
|
/usr/bin/zip -r "$ZIP_FILE" "$SITE_DIR" "$SQL_FILE" -x "*/backups/*" > /dev/null 2>&1
|
|
RC=$?; rm -f "$SQL_FILE"
|
|
|
|
if [ $RC -ne 0 ] || [ ! -f "$ZIP_FILE" ]; then
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] ERROR: Archive creation failed"
|
|
rm -f "$ZIP_FILE"; exit 1
|
|
fi
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] Archive created: $(basename "$ZIP_FILE") ($(du -sh "$ZIP_FILE" | cut -f1))"
|
|
|
|
ls -t "${BACKUP_DIR}"/ttg_backup_*.zip 2>/dev/null | tail -n +8 | while read old; do
|
|
rm -f "$old"
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] Pruned: $(basename "$old")"
|
|
done
|
|
|
|
echo "[$(date '+%Y-%m-%d %H:%M:%S')] Backup complete."
|