Database Backup Script

mysql_backup_production_data.sh

#!/bin/bash
    backup_path="/root/production_backup/database_backup"
    mv $backup_path/bak_data.19.sql $backup_path/bak_data.20.sql
    mv $backup_path/bak_data.18.sql $backup_path/bak_data.19.sql
    mv $backup_path/bak_data.17.sql $backup_path/bak_data.18.sql
    mv $backup_path/bak_data.16.sql $backup_path/bak_data.17.sql
    mv $backup_path/bak_data.15.sql $backup_path/bak_data.16.sql
    mv $backup_path/bak_data.14.sql $backup_path/bak_data.15.sql
    mv $backup_path/bak_data.13.sql $backup_path/bak_data.14.sql
    mv $backup_path/bak_data.12.sql $backup_path/bak_data.13.sql
    mv $backup_path/bak_data.11.sql $backup_path/bak_data.12.sql
    mv $backup_path/bak_data.10.sql $backup_path/bak_data.11.sql
    mv $backup_path/bak_data.9.sql $backup_path/bak_data.10.sql
    mv $backup_path/bak_data.8.sql $backup_path/bak_data.9.sql
    mv $backup_path/bak_data.7.sql $backup_path/bak_data.8,sql
    mv $backup_path/bak_data.6.sql $backup_path/bak_data.7.sql
    mv $backup_path/bak_data.5.sql $backup_path/bak_data.6.sql
    mv $backup_path/bak_data.4.sql $backup_path/bak_data.5.sql
    mv $backup_path/bak_data.3.sql $backup_path/bak_data.4.sql
    mv $backup_path/bak_data.2.sql $backup_path/bak_data.3.sql
    mv $backup_path/bak_data.1.sql $backup_path/bak_data.2.sql
    cd $backup_path
    mysqldump -uuser -ppassword app_db_new > bak_data.1.sql

psql_backup_production_data.sh

#!/bin/bash
backup_path="/var/www/apps/production_backup/database_backup" 

mkdir -p $backup_path
mv $backup_path/bak_data.19.dmp $backup_path/bak_data.20.dmp
mv $backup_path/bak_data.18.dmp $backup_path/bak_data.19.dmp
mv $backup_path/bak_data.17.dmp $backup_path/bak_data.18.dmp
mv $backup_path/bak_data.16.dmp $backup_path/bak_data.17.dmp
mv $backup_path/bak_data.15.dmp $backup_path/bak_data.16.dmp
mv $backup_path/bak_data.14.dmp $backup_path/bak_data.15.dmp
mv $backup_path/bak_data.13.dmp $backup_path/bak_data.14.dmp
mv $backup_path/bak_data.12.dmp $backup_path/bak_data.13.dmp
mv $backup_path/bak_data.11.dmp $backup_path/bak_data.12.dmp
mv $backup_path/bak_data.10.dmp $backup_path/bak_data.11.dmp
mv $backup_path/bak_data.9.dmp $backup_path/bak_data.10.dmp
mv $backup_path/bak_data.8.dmp $backup_path/bak_data.9.dmp
mv $backup_path/bak_data.7.dmp $backup_path/bak_data.8,dmp
mv $backup_path/bak_data.6.dmp $backup_path/bak_data.7.dmp
mv $backup_path/bak_data.5.dmp $backup_path/bak_data.6.dmp
mv $backup_path/bak_data.4.dmp $backup_path/bak_data.5.dmp
mv $backup_path/bak_data.3.dmp $backup_path/bak_data.4.dmp
mv $backup_path/bak_data.2.dmp $backup_path/bak_data.3.dmp
mv $backup_path/bak_data.1.dmp $backup_path/bak_data.2.dmp
cd $backup_path
pg_dump -Fc app_production > bak_data.1.dmp

sudo crontab -e

27 5 * * * /var/www/apps/backup_production_data.sh