#!/bin/sh
BACKUP_HOME="/var/www/html/backups/sovey"

cd $BACKUP_HOME

backupdir="$BACKUP_HOME"
backup="sovey-$(date +%Y-%m-%d)"


# run backup
#
mysqldump -uroot -pCxb0SW5RE4UhGN@L soveyautoparts.com | sed 's/DEFINER=[^*]*\*/\*/' > $backupdir/$backup.sql

# compress file backup
#
tar -czf $backup.tar.gz $backup.sql


# remove file after compress
#
rm $backup.sql


# Deleted 'westland-*' files older than 5 days in
#
find "$backupdir" -type f -name "sovey-*" -mtime +3 -exec rm -f {} \;
