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
