backup_database.sh

#!/bin/bash
# Backup script for Odoo database
# Usage: ./backup_database.sh [database_name]

set -e

# Configuration
DB_NAME="${1:-gypex_dev}"
DB_USER="odoo"
DB_HOST="localhost"
BACKUP_DIR="/home/user/Documents/Odoo/backups"
TIMESTAMP=$(date +%Y%m%d_%H%M%S)
BACKUP_FILE="${BACKUP_DIR}/${DB_NAME}_backup_${TIMESTAMP}.dump"

# Colors for output
GREEN='\033[0;32m'
BLUE='\033[0;34m'
NC='\033[0m' # No Color

echo -e "${BLUE}========================================${NC}"
echo -e "${BLUE}Odoo Database Backup${NC}"
echo -e "${BLUE}========================================${NC}"
echo ""
echo "Database: ${DB_NAME}"
echo "Backup file: ${BACKUP_FILE}"
echo ""

# Create backup directory if it doesn't exist
mkdir -p "${BACKUP_DIR}"

# Check if database exists
if ! PGPASSWORD=odoo psql -h "${DB_HOST}" -U "${DB_USER}" -lqt | cut -d \| -f 1 | grep -qw "${DB_NAME}"; then
    echo "ERROR: Database '${DB_NAME}' does not exist!"
    exit 1
fi

echo "Starting backup..."
echo ""

# Perform backup
PGPASSWORD=odoo pg_dump -h "${DB_HOST}" -U "${DB_USER}" \
    -F c \
    -b \
    -v \
    -f "${BACKUP_FILE}" \
    "${DB_NAME}" 2>&1 | grep -E "(dumping|ERROR|WARNING)" || true

# Check if backup was successful
if [ $? -eq 0 ] && [ -f "${BACKUP_FILE}" ]; then
    BACKUP_SIZE=$(du -h "${BACKUP_FILE}" | cut -f1)
    echo ""
    echo -e "${GREEN}✓ Backup completed successfully!${NC}"
    echo "  File: ${BACKUP_FILE}"
    echo "  Size: ${BACKUP_SIZE}"
    echo ""
    
    # List recent backups
    echo "Recent backups:"
    ls -lht "${BACKUP_DIR}"/*.dump 2>/dev/null | head -5 | awk '{print "  " $9 " (" $5 ")"}'
else
    echo ""
    echo "ERROR: Backup failed!"
    exit 1
fi