Live Chat Software by Kayako |
Knowledgebase
MySQL Import Command
Posted by on 08 January 2013 12:12 AM
|
|
The syntax is as follows to import the data created by mysqldump command:
mysql -u {DB-USER-NAME} -p {DB-NAME} < {db.file.sql} mysql -u {DB-USER-NAME} -h {MySQL-SERVER-HOST-NAME} -p {DB-NAME} < {db.file.sql}
In this example import a file called chillox.sql for chilloxdb user and chillox db, enter:
If database chilloxdb does not exists, first create it and than import it as follows:
| |
|
Comments (0)