Pages

Friday, September 26, 2014

mysql dump import

mysql dump import

Say I have a SQL Dump File; How can I import SQL Dump into MySQL ?
This command will do this .


mysql -u username -p <Password> <DATA-BASE-NAME> < data.sql 

Where ,

 -u       -> User Name
 -p       -> Password 
data.sql  -> SQL Dump File Name

Solution:

http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/

No comments:

Post a Comment