Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- backup_dir=/storage/.hbackup/mysql/$(date +'%Y')/$(date +'%m')/$(date +'%d')/$(date +'%T')
- DATABASES=(mysql forum up wikidb)
- USER="root"
- PASSWORD="not_realy_password"
- RIGHTS="0400"
- OWNER="root.root"
- # =================
- echo "Optimizing all DB"
- mysqlcheck --user=$USER --password=$PASSWORD --all-databases --analyze --auto-repair --optimize
- echo "Creating dir: $backup_dir"
- mkdir -v -p $backup_dir
- echo "Go to dir: $backup_dir"
- cd $backup_dir
- if [ "${DATABASES[*]}" ]; then
- for database in ${DATABASES[@]}; do
- echo "dumping: $database "
- /usr/bin/mysqldump --user=$USER --password=$PASSWORD $database > $backup_dir/${database}.sql
- chmod $RIGHTS $backup_dir/${database}.sql
- chown $OWNER $backup_dir/${database}.sql
- echo " zipping file"
- pbzip2 -l $backup_dir/${database}.sql
- gpg --homedir='/root/.gnupg' -e -r dimkalinux@gmail.com $backup_dir/${database}.sql.bz2
- rm -f $backup_dir/${database}.sql.bz2
- done
- fi
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement