Archive for the ‘command line’ Category

Mysql Command Line Import

Monday, March 12th, 2012

navigate to the folder containing the .sql file you’d like to import

>mysql -user -password databaseToImportInto < newData.sql

return – no ; (unless you are IN mysql>)

password:

example:

>mysql -root -p someDB<newData.sql (return)

password: (return – default config has none, unless you’ve, hopefully, changed it, then enter it)