Well ... actually, I recommend you stay out of \mysql\bin and run scripts
from some other directory.
Your message doesn't say it, but I assume you are running on a Win32
platform. You should put c:\mysql\bin (or wherever it is installed) into
your computer's path. That way, you can put scripts in any directory and
still execute them. We use a generic \sqlscripts directory off the root of
one of the Windoze drives.
Of course, if you were running Linux, MySQL should already be in path.
G. Jensen
----- Original Message -----
From: "Jon Crater" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 10, 2001 3:09 PM
Subject: executing scripts in batch mode
> i'm trying to execute a sql script in batch mode. the command i'm typing
is:
> mysql < createdb.sql;
>
> does the createdb.sql script need to be in a specific directory for mysql
to
> recognize it? i've tried putting it in mysql\bin and mysql and specifying
> relative and absolute paths to the file. the only thing i get from mysql
is
> "You have an error in your SQL syntax..."
>
> i know this is probably a newbie question, but there isn't anything in the
> documentation about where the script files should be. can anybody point
me
> in the right direction?
>
> thanks in advance.
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php