Skip to content

Instantly share code, notes, and snippets.

@davidcrx

davidcrx/backupsql.sh

Created May 7, 2018 09:57
Show Gist options
  • Save davidcrx/f1abd0e01893a6e9c89ec0bec7b3b885 to your computer and use it in GitHub Desktop.
Save davidcrx/f1abd0e01893a6e9c89ec0bec7b3b885 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
backupsql.sh
#!/bin/bash
mysqldump --databases db1 > "/$USER/mysql-backup/db1-$(date +'%Y-%m-%d').sql"
mysqldump --databases db2 > "/$USER/mysql-backup/db2-$(date +'%Y-%m-%d').sql"
mysqldump --databases db3 > "/$USER/mysql-backup/db3-$(date +'%Y-%m-%d').sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment