whoops,
yip,
**blush**
-Original Message-
From: Jack Challen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:23 AM
To: [EMAIL PROTECTED]
Cc: Sean O'Donnell
Subject: Re: Hello please help me out
[EMAIL PROTECTED] wrote:
>
> try
>
> echo file.sql >
[EMAIL PROTECTED] wrote:
>
> try
>
> echo file.sql > mysql -u username -p password databasename
>
You mean:
^
cat file.sql | mysql -u username -p password databasename
^
Or, better:
mysql -u username -p password databasename < file.sql
--
Jack Chall
[EMAIL PROTECTED] wrote:
>
> try
>
> echo file.sql > mysql -u username -p password databasename
>
> or on dos
>
> type file.sql > mysql -u username -p password databasename
>
> That should execute the scripts on the db in question,
>
> or you can download a a tool like mysqlgui/mysqlfront an
try
echo file.sql > mysql -u username -p password databasename
or on dos
type file.sql > mysql -u username -p password databasename
That should execute the scripts on the db in question,
or you can download a a tool like mysqlgui/mysqlfront and
use it to load and run the queries.
Sean
-O
At 9:19 AM +0530 6/28/01, Divakar wrote:
>Hi list
>
> I am a beginner in the field of mysql
>I would like to know whether it is possible to run sql scripts(a .sql file)
>in mysql.
>if yes please some body tell me how do we do that,.
The MySQL Reference Manual is your friend:
http://www.mysql.c