469,946 Members | 1,997 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

How to run sql script on MySQL 5.1.34 prompt.


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
Oct 7 '09 #1
1 5191
5,058 Expert 4TB

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:
Expand|Select|Wrap|Line Numbers
  1. mysql --user=root --password=amit < mysql.sql
That should work.
Oct 21 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Ola Ogunneye | last post: by
51 posts views Thread by w_curtis | last post: by
9 posts views Thread by ruud | last post: by
22 posts views Thread by Duncan Jones | last post: by
1 post views Thread by el chupacabra | last post: by
1 post views Thread by techBoy | last post: by
3 posts views Thread by apostolosl | last post: by
1 post views Thread by paulq182 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.