Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- BACKUP_DIR="/Users/`whoami`/Desktop/db-backups/"
- MYSQL_HOST="localhost"
- MYSQL_USER="root"
- MYSQL_PASS=""
- MYSQL_BACKUP_DIR="$BACKUP_DIR"
- MYSQL_PATH="$(which mysql)"
- MYSQLDUMP_PATH="$(which mysqldump)"
- THE_DATE="$(date '+%Y-%m-%d')"
- DBS="$($MYSQL_PATH -h $MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASS -Bse 'show databases')"
- for db in $DBS
- do
- echo "Dumping: $db..."
- $MYSQLDUMP_PATH -u $MYSQL_USER -p$MYSQL_PASS $db | gzip > $MYSQL_BACKUP_DIR$db\_$THE_DATE.sql.gz
- done
Add Comment
Please, Sign In to add comment