How to import an SQL file using the command line in My. SQL If you already have the database use the following to import the dump or the sql filemysql u username p databasename lt file. My. SQL, for that first log on to the My. SQL console by running the following command in terminal or in cmdmysql u user. Name p. and when prompted provide the password. Next create a database and use itmysql create database your. Database. Name. mysql use your. Database. Name. Then import the sql or the dump file to the database frommysql source path. To. Your. SQLFile. Note if your terminal is not in the location where the dump or sql file exists, use the relative path in above.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |