List:MySQL on Win32« Previous MessageNext Message »
From:Peter Goggin Date:May 14 2002 2:42pm
Subject:Re: Scripts
View as plain text  
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
;

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
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread8873@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
>
>

Thread
ScriptsPeter Goggin14 May
  • Re: ScriptsPaul DuBois14 May
  • Re: ScriptsPeter Goggin14 May
    • Re: ScriptsPaul DuBois14 May
  • Re: Table privilegesPeter Goggin5 Jul
  • Re: Table privilegesRajeev Rumale5 Jul