Skip to content

Instantly share code, notes, and snippets.

@eschmar
Created December 22, 2014 10:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save eschmar/7e47eca3e1a86bdc2a50 to your computer and use it in GitHub Desktop.
Save eschmar/7e47eca3e1a86bdc2a50 to your computer and use it in GitHub Desktop.
Large MySQL dump import
# shorthand
mysql -u root <database_name> < <sql_file_path>
# long
mysql -u root -p
use <database_name>
source <sql_file_path>
# windows phpmyadmin alias
importmysql=C:\xampp\mysql\bin\mysql.exe -u root $1 < $2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment