Advertisement
Guest User

Untitled

a guest
Mar 1st, 2019
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. #!/bin/bash
  2. mkdir -p backup
  3. ## Get all databases on system
  4. USER="root"
  5. PASSWORD=""
  6. DBS=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" -sN | grep -Ev "information_schema|performance_schema|mysql|test"`
  7.  
  8. for DB in ${DBS}
  9. do
  10. mysqldump -u $USER -p$PASSWORD --databases ${DB} > "${DB}-`date +%Y%m%d`.sql"
  11. done
  12. mv *.sql backup/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement