Skip to content

Instantly share code, notes, and snippets.

@joergpatz

joergpatz/import-mysql-dumpfile.md

Created April 30, 2014 10:47
Show Gist options
  • Save joergpatz/1267d1c9ec72b5ed053e to your computer and use it in GitHub Desktop.
Save joergpatz/1267d1c9ec72b5ed053e to your computer and use it in GitHub Desktop.
Download ZIP
import mysql dump
Raw
import-mysql-dumpfile.md

mysql -h<hostname> -u<user> -p<password> <database> < example.sql

gz'ed dumpfile

gunzip < <DUMP_FILE>.sql.gz | mysql -h<hostname> -u<user> -p<password> <database>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment