Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- # The file sourced below provides the mysql password in the variable MYSQL_USER_PASS
- . /root/bin/_mysqlauth
- BACKUP_SERVER=backup
- BACKUP_USER=backup
- MYSQL_USER=glpi
- SERVERNAME=`hostname -s`
- DAY=`/bin/date +%A`
- SAVPATH=/data/$SERVERNAME/$DAY/mysql
- MYSQLHOTCOPY=/usr/bin/mysqlhotcopy
- # Change to MySQL data directory
- cd /var/lib/mysql/
- # Create an array with all directories in the MySQL data directory
- # The directory name presents the database name in MySQL.
- ARRAY=`find * -type d -prune`
- for DATABASE in `echo $ARRAY`
- do
- # Create remote directory on backupserver
- ssh `echo $BACKUP_USER`@`echo $BACKUP_SERVER` mkdir -p $SAVPATH/$DATABASE
- # Create backup from database
- $MYSQLHOTCOPY --method=scp --user=`echo $MYSQL_USER` --password=`echo $MYSQL_USER_PASS` \
- $DATABASE `echo $BACKUP_USER`@`echo $BACKUP_SERVER`:$SAVPATH
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement