Skip to content

Instantly share code, notes, and snippets.

@mbpcoder

mbpcoder/mysql-restore.sh

Last active November 15, 2018 07:51
Show Gist options
  • Save mbpcoder/97107dee2012c286033ce2b5edb17127 to your computer and use it in GitHub Desktop.
Save mbpcoder/97107dee2012c286033ce2b5edb17127 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql Database Restore Backup
Raw
mysql-restore.sh
BACKUP_FILE="/tmp/backup.sql.gz"
cat BACKUP_FILE | mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" -u myusername -p'secret' database_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment