472,090 Members | 1,398 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,090 software developers and data experts.

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 5390
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 Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.