Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- host01:~# cat ultiamte_sql_dump
- #!/bin/bash
- echo "alle datenbanken werden gedumpt"
- DBASELIST=`mktemp`
- DATE=$(date +%Y-%m-%d_%Hh%Mm)-sql
- mysqlshow -h mysql02.bastelfreak.org --user=root --password=$(cat /root/.mysqlsecret) | awk '{print $2}' | grep -v Databases | sort >$DBASELIST
- mkdir /home/backups/$DATE-sql/
- for x in `cat $DBASELIST`; do
- echo "Datenbank: $x sichern";
- mysqldump -h mysql02.bastelfreak.org --user=root --password=$(cat /root/.mysqlsecret) $x >/home/backups/$DATE-sql/$(date +%Y-%m-%d_%Hh%Mm).$x.sql;
- done;
- echo "alle erfolgreich gedumpt"
- echo "beginne rsync..."
- rsync -avze ssh /home/backup/$DATE-sql/ root:aFPWwwsNaIsuhglTZHcj@s1.debauer.net:/home/backup/km
- echo "rsync erfolgreich"
- host01:~#
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement