Skip to content

Instantly share code, notes, and snippets.

@vishaltelangre

vishaltelangre/mysql_dump_restore.sh

Last active December 16, 2015 08:29
Show Gist options
  • Save vishaltelangre/5406030 to your computer and use it in GitHub Desktop.
Save vishaltelangre/5406030 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL dump and restore commands
Raw
mysql_dump_restore.sh
# take dump of specific db
mysqldump -u vishal -p foo_db_dev > foo_db_dev_dump.sql
# take dump of all available databases
mysqldump -u vishal -p -r -A > foo_db_dev_dump.sql
# import dump of specific db
mysql --verbose -u vishal -p --default-character-set=utf8 foo_db_dev < foo_db_dev_dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment