Advertisement
Guest User

Untitled

a guest
May 8th, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.88 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. # The file sourced below provides the mysql password in the variable MYSQL_USER_PASS
  4. . /root/bin/_mysqlauth
  5.  
  6. BACKUP_SERVER=backup
  7. BACKUP_USER=backup
  8.  
  9. MYSQL_USER=glpi
  10.  
  11. SERVERNAME=`hostname -s`
  12. DAY=`/bin/date +%A`
  13. SAVPATH=/data/$SERVERNAME/$DAY/mysql
  14.  
  15. MYSQLHOTCOPY=/usr/bin/mysqlhotcopy
  16.  
  17. # Change to MySQL data directory
  18. cd /var/lib/mysql/
  19.  
  20. # Create an array with all directories in the MySQL data directory
  21. # The directory name presents the database name in MySQL.
  22. ARRAY=`find * -type d -prune`
  23.  
  24. for DATABASE in `echo $ARRAY`
  25. do
  26.     # Create remote directory on backupserver
  27.     ssh `echo $BACKUP_USER`@`echo $BACKUP_SERVER` mkdir -p $SAVPATH/$DATABASE
  28.  
  29.     # Create backup from database
  30.     $MYSQLHOTCOPY --method=scp --user=`echo $MYSQL_USER` --password=`echo $MYSQL_USER_PASS` \
  31.         $DATABASE `echo $BACKUP_USER`@`echo $BACKUP_SERVER`:$SAVPATH
  32. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement