Skip to content

Instantly share code, notes, and snippets.

@jcefoli

jcefoli/backup_all_mysql_dbs.sh

Created October 24, 2017 22:12
Show Gist options
  • Save jcefoli/036074428d77536d8c27e6ecb818bdca to your computer and use it in GitHub Desktop.
Save jcefoli/036074428d77536d8c27e6ecb818bdca to your computer and use it in GitHub Desktop.
Download ZIP
Backup and Restore all MariaDB/MySQL Databases
Raw
backup_all_mysql_dbs.sh
#Take GZipped Backup of all DBs, Stored Procs and Triggers (https://stackoverflow.com/a/38527022)
#Note, if you want to shrink ibdata1, Another article recommends skipping a few DBS (https://stackoverflow.com/a/3456885)
#Backup
mysqldump -u root --all-databases --events --ignore-table=mysql.event --extended-insert --add-drop-database --disable-keys --flush-privileges --quick --routines --triggers | gzip > "all_databases.gz"
#Restore
gunzip < all_databases.gz | mysql -u root
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment