MySql error when importing dump from linux into windows machine localhost

Question

I get a couple of errors when trying to import a .sql dump file using the following command:

mysql -hIP -r -uroot -p db_test < C:\Users\Mark Hur\SQL Dumps\oct.sql;

The errors I get are as follows:

ERROR:
Unknown command '\U'.
ERROR:
Unknown command '\O'.
ERROR:
Unknown command '\P'.
ERROR:
Unknown command '\D'.
ERROR:
Unknown command '\S'.
ERROR:
Unknown command '\o'.

I guess these are due to the fact that I received a .sql dump from a database that resides on a linux machine. How do I import it then? I want to to import the data only

Cyclonecode · Accepted Answer · 2017-07-31 23:24:35Z

1

Since you are using a long filename with spaces it needs to be quoted:

mysql -hIP -r -uroot -p db_test < "C:\Users\Mark Hur\SQL Dumps\oct.sql"

Reference:

Long Filenames or Paths with Spaces Require Quotation Marks

edited Jul 31, 2017 at 23:24

answered Jul 31, 2017 at 23:19

Cyclonecode

30.4k11 gold badges77 silver badges97 bronze badges

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

Collectives™ on Stack Overflow

MySql error when importing dump from linux into windows machine localhost

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related