Database automate

#!/bin/bash
# declare an array called array and define 3 vales
databases=( drupal fresh lasalle_wp_fts )
username=root
password=password
filepath=/home/amitavroy/code/backup
for i in "${databases[@]}"
do
  filename=${i}_$(date  +"%m%d%Y-%k%M")
  mysqldump -u${username} -p${password} ${i} > ${filepath}/${filename}.sql
  tar -zcf ${filepath}/${filename}.tar.gz ${filepath}/${filename}.sql
  rm ${filepath}/${filename}.sql
done

Changed the file. All the folder reference should be absolute.

Shell script to delete DB backup older than 2 days

Crontab command to run at 5pm everyday => 0 17 * * * /home/fwdev/remove_backup_files.sh

#!/bin/bash
databases=(lasalle_gj_drupal)
filepath=/home/fwdev/lasalle_gj_db_backups
for i in "${databases[@]}"
do
	filename=${filepath}/${i}_$(date -d "-2 days" +"%m%d%Y")
	rm ${filename}*
done