zeshan-a
4/13/2018 - 11:06 AM

mySQL Export all Databases to Dropbox

mySQL export all databases in separate files to Dropbox with unique backup folder name and gzip automatically.

mysql-export-all-databases.sh
content_copyfile_download
#!/bin/bash

#This solution is inspired from this Stackoverflow answer:
#https://stackoverflow.com/a/26096339/3107931 :)

USER="root"
PASSWORD=""
BACKUP_DIR="/Users/USERNAME/Dropbox/Mine/Backups/Databases"
#OUTPUT="/Users/rabino/DBs"

#rm "$OUTPUTDIR/*gz" > /dev/null 2>&1

databases=`/usr/local/bin/mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

echo $databases

for db in $databases; do
  if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
    echo $db
    mkdir "$BACKUP_DIR/backup_$(date +%Y-%m-%d)"
    cat
    /usr/local/bin/mysqldump --user=root --password= $db > "$BACKUP_DIR/backup_$(date +%Y-%m-%d)/$db _$(date +%Y-%m-%d).sql"
    # gzip the exported file. This will delete the original backup file. 
    gzip "$BACKUP_DIR/backup_$(date +%Y-%m-%d)/$db _$(date +%Y-%m-%d).sql"
  fi
done