mysql encrypted backup

gistfile1.txt

#!/bin/sh

sql_host=""
sql_user=""
sql_passwd=""
sql_db=""
sql_opts="--routines --add-drop-table --add-locks --create-options --single-transaction --disable-keys --extended-insert --quick"
sql_bk_directory=""
sql_bk_password=""

/usr/bin/nice -n 10  /usr/local/bin/mysqldump -v -h $sql_host -u $sql_user -p$sql_passwd $sql_opts $sql_db | \
/usr/bin/gzip -c >  $sql_bk_directory/$sql_db-`date "+%Y-%m-%d"`_full.sql.gz
if [ $? != 0 ]; then
        echo "Error dumping data"
        exit 1
fi


/usr/bin/openssl aes-256-cbc -salt -in $sql_bk_directory/$sql_db-`date "+%Y-%m-%d"`_full.sql.gz -out $sql_bk_directory/$sql_db-`date "+%Y-%m-%d"`_full.sql.gz.enc -pass pass:pr2bXiwXmm
if [ $? != 0 ]; then
        echo "Error encrypt data"
        exit 1
fi


rm $sql_bk_directory/$sql_db-`date "+%Y-%m-%d"`_full.sql.gz


############
#to decrypt#
############
#openssl aes-256-cbc -d -salt -in /usr/home/backup/mysql/dbs/$sql_db-`date "+%Y-%m-%d"`_full.sql.gz.enc -out /usr/home/backup/mysql/dbs/$sql_db-`date "+%Y-%m-%d"`_full.sql.gz -pass pass:pass