Skip to content

Instantly share code, notes, and snippets.

@radinreth

radinreth/Dump + Source Mysql Database

Last active September 29, 2015 09:41
Show Gist options
  • Save radinreth/2dbd9f6d4c1105754fb7 to your computer and use it in GitHub Desktop.
Save radinreth/2dbd9f6d4c1105754fb7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Dump + Source Mysql Database
DUMP::
mysqldump -uroot -Q1p2m3g4 yoolk_api_development > db.sql
#good
mysqldump -uroot -pQ1p2m3g4 --no-data yoolk_core_api_development -r db-201509291633.dump
SOURCE ::
mysql -uroot -Q1p2m3g4 yoolk_api_development < db.sql
#good
mysql -uroot -p --default-character-set=utf8 database
mysql> SET names='utf8'
mysql> SOURCE db-201509291633.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment