how to import sql file in command prompt

Question

i am trying to import sql file through putty

below are my details of DB dbname - test, password - test123, username -utest,

i tried the below code

mysql -u utest -p test123 test< /home/path/public_html/file.sql

when i run this command i saw a error message

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u utest -p test123 test < file' at line 1

please suggest how to import sql file

Thank Sanjib

possible duplicate of stackoverflow.com/questions/7316507/… — sanoj lawrence
– sanoj lawrence, Commented Jan 8, 2015 at 14:05

Ram Sharma · Accepted Answer · 2015-01-08 14:10:27Z

3

try this

mysql -utest -ptest123  test < /home/path/public_html/file.sql

and make sure that you run this command from your console not in mysql

if you are in mysql prompt than it would be somehting like this

mysql> use test;
mysql> source /home/path/public_html/file.sql;

OR

 mysql>SET autocommit=0; source /home/path/public_html/file.sql; COMMIT;

edited Jan 8, 2015 at 14:10

answered Jan 8, 2015 at 14:04

Ram Sharma

8,8157 gold badges48 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

psanjib Over a year ago

it works fine, one question to you. I rememebr, i have tried the same command and it was successfully imported. But today i don't understand why not imported

Ram Sharma Over a year ago

may be you are missing some minor thing :)

Alex Over a year ago

@psanjb: Maybe you had hit CTRL+D to exit mysql first.

Ram Sharma Over a year ago

@psanjib please mark it as correct so that other user can get the help from your question

Alex · Accepted Answer · 2015-01-08 14:02:21Z

2

You should run this command in your console, outside of the mysql tool.

answered Jan 8, 2015 at 14:02

Alex

4053 silver badges12 bronze badges

Collectives™ on Stack Overflow

how to import sql file in command prompt

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related