Monday, December 17, 2012

Importing a database (.sql file) into MySQL

No real trick, but I don't do this often enough to remember:

First log in to mysql and create the database named DB-NAME, then run the following from command line:
$ mysql -u root DB-NAME < filename.sql

No comments:

Post a Comment