Bash Script For backup & restore

make-backup.sh:

PROJECT=sample
BPDATE=$(date +%Y-%m-%d-%H.%M.%S);
BPDIR=./$BPDATE
mkdir -p $BPDIR
BPTYPE=dev
7za a -mx=9 -y $BPDIR/$PROJECT-$BPTYPE-$BPDATE.7z ./../public | grep 'Everything'
mysqldump --user=root --password=123456 mysql | bzip2 -c > $BPDIR/mysqldump-$PROJECT-$BPTYPE-$BPDATE.sql.bz2

restore-database.sh:

bzip2 -dc dump.sql.bz2 | mysql --user=$DBUSER --password=$DBPASSWORD $DBNAME