import a sql file using mysql command line tools

Question

here is my command to import a sql file into mysql using command line

mysql -p eshop < c:\xampp\mysql\eshop.sql

But there is error message

Error:
Unknown command '\x'

Error:
Unknown command '\m'

Error:
Unknown command '\e'

Anyone knows what's wrong with the command?

PS Kumar · Accepted Answer · 2014-03-03 10:06:04Z

1

Try this, I think this may help you.

mysql -u username -p database_name < file.sql

check mysql Options. Don't use \ (slash) use / (slash) to mention the file path.

edited Mar 3, 2014 at 10:06

answered Mar 3, 2014 at 7:25

PS Kumar

2,4766 gold badges33 silver badges45 bronze badges

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

Comments

avisheks · Accepted Answer · 2014-03-03 07:24:20Z

0

On Windows, the pathname separator character is ‘\’, but MySQL treats the backslash as the escape character in strings. To deal with this issue, write separators in Windows pathnames either as ‘/’ or as ‘\\’. To load a file named C:\mydata\data.txt, specify the filename as shown in either of the following statements:

mysql  <database_name> < ‘C:/mydata/data.txt’
mysql  <database_name> < ‘C:\\mydata\\data.txt’

answered Mar 3, 2014 at 7:24

avisheks

1,1801 gold badge11 silver badges28 bronze badges

Collectives™ on Stack Overflow

import a sql file using mysql command line tools

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related