From: Paul DuBois
Date: May 14 2002 3:02pm
Subject: Re: Scripts
List-Archive: http://lists.mysql.com/win32/8882
Message-Id: <p0511178fb906d7343b23@[192.168.0.33]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii" ; format="flowed"

At 0:42 +1000 5/15/02, Peter Goggin wrote:
>The error message is:
>error at line 1: Unknown command '\m'
>
>The current directory is C:\mysql\scripts
>The command used is
>..\bin\mysql stamps <security.sql
>
>The script security.sql is:
>CREATE TABLE security_questions(
>  Security_question_key SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT
>                  PRIMARY KEY,
>  Security_question VARCHAR(80) NOT NULL)
>DATA DIRECTORY="E:\mysqldata\"
>INDEX DIRECTORY="F:\mysqlindex\"
>TYPE=InnoDB
>;

"\" characters in Windows pathnames should be specified as "/" or as "\\".
The "\" is MySQL's escape character, so you have to double it to have
it taken as a literal backslash.

>
>The command ..\bin\mysql  involes mysql
>The command ..\bin\mysql stamps invokes mysql ad connects to the stamps
>database.
>  The script does notr seem to be being called.
>
>
>Regards
>
>Peter Goggin
>
>----- Original Message -----
>From: "Paul DuBois" <paul@stripped>
>To: "Peter Goggin" <pgoggin@stripped>; <win32@stripped>
>Sent: Tuesday, May 14, 2002 1:15 PM
>Subject: Re: Scripts
>
>
>>  At 13:26 +1000 5/14/02, Peter Goggin wrote:
>>  >What is the syntax fro using scripts with mysql?
>>  >
>>  >I have a series of scripts for creating tables and wish to run them
>against
>>  >a particular mysql database (stamps).
>>  >
>>  >I have tried:
>>  >
>>  >>mysql stamps <scriptname
>>  >
>>  >This does not work.
>>  >
>>  >Can anyone please help me?
>>
>>  Not unless you show us the error message you get.  You'll get
>>  better help if you provide better information.
>>
>>  >
>>  >Regards
>>  >
>  > >Peter Goggin