Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- USER="YOUR USER NAME"
- PASSWORD="YOUR PASSWORD"
- ExcludeDatabases="Database|information_schema|performance_schema|mysql"
- databases=`mysql -u $USER -p $PASWORD -e "SHOW DATABASES;" | tr -d "| " | egrep -v $ExcludeDatabases`
- for db in $databases; do
- echo "Dumping database: $db"
- mysqldump -u $USER -p$PASSWORD --databases $db > `date +%Y%m%d`.$db.sql
- done
Add Comment
Please, Sign In to add comment