Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- mkdir -p backup
- ## Get all databases on system
- USER="root"
- PASSWORD=""
- DBS=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" -sN | grep -Ev "information_schema|performance_schema|mysql|test"`
- for DB in ${DBS}
- do
- mysqldump -u $USER -p$PASSWORD --databases ${DB} > "${DB}-`date +%Y%m%d`.sql"
- done
- mv *.sql backup/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement