Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- USER="myuser"
- PASSWORD="mypassword"
- OUTPUT="/etc/mysql/backup"
- ExcludeDatabases="information_schema|performance_schema|mysql"
- if [ ! -d $OUTPUT ]; then
- mkdir -p $OUTPUT
- fi
- chmod 0700 $OUTPUT
- rm "$OUTPUT/*" > /dev/null 2>&1
- databases=`mysql -u $USER -p$PASWORD -e "SHOW DATABASES;" | tr -d "|" | grep -v $ExcludeDatabases`
- for db in $databases; do
- echo "Dumping database: $db"
- mysqldump --add-drop-database --opt --lock-all-tables -u $USER -p$PASSWORD $db | gzip -9 > "$OUTPUT/$db.sql.gz"
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement