jordantrizz/mysql-backup-all-databases.sh

Created November 30, 2022 15:13

Star (2) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jordantrizz/79fd6c4de9bcb5fd35a3880418eb1199.js"></script>
Save jordantrizz/79fd6c4de9bcb5fd35a3880418eb1199 to your computer and use it in GitHub Desktop.

Download ZIP

Backup all MySQL Databases on a Server

Raw

mysql-backup-all-databases.sh

mysql -uroot -N -e 'show databases' | while read dbname; do mysqldump -uroot --complete-insert "$dbname" > "$dbname".sql; done

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment