Skip to content

Instantly share code, notes, and snippets.

@pbredenberg
Last active December 6, 2015 20:39
Show Gist options
  • Save pbredenberg/bb556d8352b8f198c1e7 to your computer and use it in GitHub Desktop.
Save pbredenberg/bb556d8352b8f198c1e7 to your computer and use it in GitHub Desktop.
#!/bin/bash
read -p "Enter username: " user
read -s -p "Enter password: " pass
echo "Ok, here we go..."
OUTPUT="/var/www/archive/db"
mkdir -p $OUTPUT
databases=`mysql -u $user -p$pass -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`
for db in $databases; do
if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
echo "Dumping database: $db"
mkdir -p $OUTPUT/$db
mysqldump -u $USER -p$pass --databases $db > $OUTPUT/$db/`date +%Y%m%d`.$db.sql
fi
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment