Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- path=/volume1/Old\ disk/root/scripts
- PASSWORD=mysql password
- echo Sletter forige backup.
- rm -rf $path/mysql/mysql-old
- echo Flytter sidste backup til dag1 mappe
- mkdir $path/mysql/mysql-old
- mv $path/mysql/*.sql $path/mysql/mysql-old/
- echo "Gætter mig frem til hvilke dataser vi har"
- mysql -Bse "show databases;" -p$PASSWORD > $path/dbs.txt
- DATABASER=`cat $path/dbs.txt`
- for db in $DATABASER
- do
- echo Laver backup af: $db
- mysqldump -u root -p$PASSWORD --opt $db > $path/mysql/$db.sql
- echo Succes
- echo
- done
- echo "Backup finished"
- echo "Check results"
- ls -lah $path/mysql
Advertisement
Add Comment
Please, Sign In to add comment