List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 13 2001 8:20pm
Subject:Re: Using Scripts with MySQL - NEWBIE
View as plain text  
At 9:13 PM +0100 7/13/01, Sara wrote:
>Hi Paul
>
>Thanks for replying, however, something which I know should be easy is
>eluding me right now.
>
>The samp_db directory is created  as a subdirectory of the mysql1 directory.
>
>This is what I tried to do following your instructions and this is the error
>message I got, I guess I am missing something very, very obvious, so Im
>ready to cringe when you point it out ;-)
>
>(I'm running the mysql client from the windows command prompt at the moment.
>C:\MYSQL1>mysql samp_db < create_president.sql
>The system cannot find the file specified.
>
>
>I don't have the mysql client open at the time I run that command, as you
>said to cd into the directory where the scripts are.  If I do that this is
>the error I receive:
>
>C:\MYSQL1\SAMP_DB>mysql samp_db < create_president.sql
>'MYSQL' is not recognized as an internal or external command,
>operable program or batch file.

Okay, first run DIR in this directory just to make sure that the
create_president.sql file is there.  However, the error message indicates
that DOS doesn't know where to find the mysql program.  The real fix
for this is to add the directory where mysql is installed to your PATH
variable setting.  In the meantime, you can invoke mysql using its
full pathname.  If mysql is in C:\mysql\bin, then the command you type
should look like this:

	C:\mysql\bin\mysql samp_db < create_president.sql

If the directory is something else, adjust the command accordingly.


>
>This is getting very frustrating, the only solance I have is that someone
>has posted on my isp newsgroup that they can't get this to work either!
>
>Thanks in anticipation
>
>Sara


-- 
Paul DuBois, paul@stripped
Thread
Using Scripts with MySQL - NEWBIESara11 Jul
  • Re: Using Scripts with MySQL - NEWBIEPaul DuBois11 Jul
  • Re: Using Scripts with MySQL - NEWBIESara13 Jul
    • Re: Using Scripts with MySQL - NEWBIEPaul DuBois13 Jul
  • Re: Using Scripts with MySQL - NEWBIESara13 Jul
    • Re: Using Scripts with MySQL - NEWBIEPaul DuBois13 Jul
Re: Using Scripts with MySQL - NEWBIEMike Baranski11 Jul