Errors during import of sql file to MySQL database

Question

I am new to database and have just started to learn MYSQL. I have downloaded a sql file called rating.sql and would like to import it to the MYSQL database installed on the local machine. The operation system is Windows 7. The path for the sql file is:

"E:\rating.sql".

I am using the following commands in the MySQL Command Line Client

mysql>use database_name;
mysql>source E:\rating.sql;

The system gives the following error message:

ERROR 1049 <42000>: Unknown database 'ating.sql'

It is definitely something related to the path. Can anyone explain how this error is generated?Thanks

@NigelNquande I am using Eclipse and has connected MySQL DB to Eclipse using a connector. I am doing all query in the Eclipse environment. Is this normal in industry or everybody in Industry uses the MySQL Workbench? — Optimus Prime
– Optimus Prime, Commented Feb 22, 2014 at 21:35

user3329793 · Accepted Answer · 2014-02-22 21:19:36Z

3

You have use \ and this is an escape character (omits the immediate following character. So to fix this you can use \ instead.

mysql>resour E:\\rating.sql;

answered Feb 22, 2014 at 21:19

user3329793

626 bronze badges

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

2 Comments

Optimus Prime Over a year ago

@NigelNquande my level is not high enough to allow me to do that. It requires level 15 and I am only 11.

user3329793 Over a year ago

No, that's to give rep. To accept the answer just click the tick not the arrows.

user3329793 · Accepted Answer · 2014-02-22 21:27:00Z

1

Mysql recognises \r as an escape for a carriage return character.

To make it simpler, could you rename your file to something beginning with another letter...mustn't be b n r t or z...

answered Feb 22, 2014 at 21:27

user3329793

626 bronze badges

1 Comment

Agi Hammerthief Over a year ago

Renaming the file isn't the right solution, to my mind. Escaping the path separator is a better solution.

Collectives™ on Stack Overflow

Errors during import of sql file to MySQL database

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related