nordicmaterial2
1/26/2017 - 12:04 PM

Import a large DataBase via command line

Import a large DataBase via command line

// Source article: https://tommcfarlin.com/importing-a-large-database/

$ cd /Applications/MAMP/Library/bin

// Now, connect to the MYSQLserver:

$ mysql -uroot -proot

// Then you’ll be presented with the MySQL command-line. 

$ connect your_database_name
// vb: connect leerwinkel
// vb: connect eimr

//Next, simply enter the following command:

$ source /path/to/your/file/sql_export.sql

// And let MySQL do its thing.