Mysql Backup Locally

File: mysqlbk.sh

#!/bin/sh

DIR=<backup_directory>
PW=<root_password>
USER=<owner_of_file>
DATE=$(date +%Y%m%d)

mysqldump=$(which mysqldump)
mysql=$(which mysql)
tar=$(which tar)
chown=$(which chown)

for i in $($mysql -p$PW -e "SHOW DATABASES"|grep -v Database); do
        $mysqldump -p$PW --allow-keywords $i > $DIR/$i.sql
done

cd $DIR
$tar -cvf $DATE.tar *.sql
rm $DIR/*.sql
$chown -R $USER $DIR

exit 0