MySQL Backup for Rails Apps (on Nginx)

backup.sh

#!/bin/bash

today=`date +%Y-%m-%d_%H-%M` 

for i in /etc/nginx/sites-enabled/* 
do
  if [ $i != "/etc/nginx/sites-enabled/default" ] 
  then
    path=`cat $i | grep -w root | awk '{print $2}' | sed 's/\public;//g'` 
    path=$path"config/database.yml" 
    if [ -e $path ] 
    then
      username=`cat $path | grep -w username | awk '{print $2}'`
      password=`cat $path | grep -w password | awk '{print $2}'`
      dbname=`cat $path | awk '$0 == "production:" {i=1;next}; i && $1 == "database:"' | awk '{print $2}'`
      dump=`mysqldump $dbname -u$username -p$password`
      filename="/home/emre/mysql_backups/"$today"_"$dbname
      `echo $dump > $filename.sql`
    fi
  fi
done