How to run sql script on MySQL 5.1.34 prompt.

amit2781

Hi,

Can you please tell me how to run the sql script on mysql prompt?

I tried the command but not succesfull.
C:\MySQl\bin:> mysql --u=root --p=amit < mysql.sql

C:\MySQl\bin:>source < MySQL51amit_CL_Inst_1.txt

Atli · re: How to run sql script on MySQL 5.1.34 prompt.

Hey.

Your first attempt was close.
However, the --u parameter is to vague, like the error it gives says:

Quote:

mysql: ambiguous option '--u=root ' (unbuffered, user)

It could refer to either "user" or "unbuffered".

You just need to be more specific:

Expand|Select|Wrap|Line Numbers

mysql --user=root --password=amit < mysql.sql

That should work.

How to run sql script on MySQL 5.1.34 prompt.

re: How to run sql script on MySQL 5.1.34 prompt.

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about