Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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
Add Comment
Please, Sign In to add comment