Advertisement
Guest User

Exporting Databases Like A Boss Playa

a guest
Jul 3rd, 2018
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.66 KB | None | 0 0
  1. #!/bin/bash
  2.  
  3. USER="root"
  4. PASSWORD=""
  5. #OUTPUT="/var/www/db" #uncomment if you want this to zip and output the files somewhere..
  6.  
  7. #rm "$OUTPUTDIR/*gz" > /dev/null 2>&1
  8.  
  9. databases=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
  10.  
  11. for db in $databases; do
  12.     if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
  13.         echo "Dumping database: $db"
  14.         mysqldump -u $USER -p$PASSWORD --databases $db > `date +%Y%m%d`.$db.sql
  15.        # gzip $OUTPUT/`date +%Y%m%d`.$db.sql #uncomment if you want this to zip and output the files somewhere..
  16.     fi
  17. done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement