Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- echo "################################################"
- echo "### BACKUP"
- echo "################################################"
- MYSQLUSER="root"
- MYSQLPASSWORD="______"
- mkdir -p "/root/backups"
- NOW=`date +%Y-%m-%d_%H:%M:%S`
- databases=`mysql -u $MYSQLUSER -p$MYSQLPASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
- for db in $databases; do
- if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
- echo "Dumping database: $db"
- mysqldump -u $MYSQLUSER -p$MYSQLPASSWORD --databases $db > /root/backups/$NOW.$db.sql
- gzip /root/backups/$NOW.$db.sql
- fi
- done
- echo "################################################"
- echo "### UPLOAD TO RSYNC"
- echo "################################################"
- FTPHOST="_____.your-backup.de"
- FTPUSER="______"
- FTPPASSWORD="_______"
- /usr/bin/rsync -avh --rsh="/usr/bin/sshpass -p $FTPPASSWORD ssh -o StrictHostKeyChecking=no -l $FTPUSER -p 23" /root/backups/ $FTPUSER@$FTPHOST:./mysql --delete
- echo "################################################"
- echo "### DELETE OLD"
- echo "################################################"
- find /root/backups/ -type f -mtime +14 -execdir rm -- '{}' \;
- echo "################################################"
- echo "### On backup server: ls -lth ./mysql"
- echo "################################################"
- sshpass -p $FTPPASSWORD ssh $FTPUSER@$FTPHOST -p 23 "ls -lth ./mysql"
Add Comment
Please, Sign In to add comment