#!/bin/bash

TODAY=`date +"%d%b%Y"`
db_record='flowuses'
where='WHERE created_at BETWEEN DATE( DATE_SUB( NOW() , INTERVAL 1 DAY ) )AND DATE ( NOW() )'
##filename='file.csv'
filename='db_export_'${db_record}'_'${TODAY}'.csv'
hostname='localhost'
user='root'
password=''
database=''
port='3306'

echo "SELECT * INTO OUTFILE 'backups/${filename}'  FIELDS ENCLOSED BY '\"'  TERMINATED BY ',' FROM steven1_lara1.flowuses WHERE created_at BETWEEN DATE ( DATE_SUB( NOW() , INTERVAL 1 DAY ) ) AND DATE ( NOW() );" | mysql --host=${hostname} --port=${port} --user=${user} --password=${password} ${database}


echo "Hello, here is a copy of yesterday's flow uses." | mailx -s "Yesterday's Flow Uses" -a /var/lib/mysql/backups/${filename} blehman@godaddy.com