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]

Hey.

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

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

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

You just need to be more specific:

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

That should work.