Azuria

BASH - Mysql Backup

Nov 22nd, 2011
256
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.59 KB | None | 0 0
  1. #!/bin/bash
  2. path=/volume1/Old\ disk/root/scripts
  3. PASSWORD=mysql password
  4.  
  5. echo Sletter forige backup.
  6. rm -rf $path/mysql/mysql-old
  7. echo Flytter sidste backup til dag1 mappe
  8. mkdir $path/mysql/mysql-old
  9. mv $path/mysql/*.sql $path/mysql/mysql-old/
  10. echo "Gætter mig frem til hvilke dataser vi har"
  11. mysql -Bse "show databases;" -p$PASSWORD > $path/dbs.txt
  12. DATABASER=`cat $path/dbs.txt`
  13.  
  14. for db in $DATABASER
  15. do
  16. echo Laver backup af: $db
  17. mysqldump -u root -p$PASSWORD --opt $db > $path/mysql/$db.sql
  18. echo Succes
  19. echo
  20. done
  21.  
  22. echo "Backup finished"
  23. echo "Check results"
  24. ls -lah $path/mysql
  25.  
  26.  
Advertisement
Add Comment
Please, Sign In to add comment