Skip to content

Instantly share code, notes, and snippets.

@alancoleman

alancoleman/bash_db_backup_and_restore

Last active December 22, 2015 06:59
Show Gist options
  • Save alancoleman/6435250 to your computer and use it in GitHub Desktop.
Save alancoleman/6435250 to your computer and use it in GitHub Desktop.
Download ZIP
Simple method for backing up and restoring a database using bash
Raw
bash_db_backup_and_restore
// Backup using mysqldump
mysqldump my_database > database_backups/my_database_backup.dump;
// Restore using mysql
mysql> create database my_database_restore;
mysql> use my_database_restore;
mysql> source database_backups/my_database_backup.dump;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment