List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:July 13 2001 8:58pm
Subject:Re: Using Scripts with MySQL - NEWBIE
View as plain text  
At 9:54 PM +0100 7/13/01, Sara wrote:
>----- Original Message -----
>From: "Paul DuBois" <paul@stripped>
>To: "Sara" <red@stripped>; <mysql@stripped>
>Sent: Friday, July 13, 2001 9:20 PM
>Subject: Re: Using Scripts with MySQL - NEWBIE
>
>
>>  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
>
>Hi and thanks for the speedy response.
>
>I did as you suggested and this was the systems reply:
>
>C:\MYSQL1\BIN>mysql samp_db < create_president.sql
>The system cannot find the file specified.

Actually, that's not what I suggested.  First make sure you are in
the samp_db directory, then run mysql using its full path.  Given the
pathnames you list below, you should run these commands:

	cd \mysql1\samp_db
	c:\mysql1\bin\mysql samp_db < create_president.sql

>
>I can confirm that mysql.exe is in c:\mysql1
>and all of your scripts are contained in c:\mysql1\samp_db\
>
>Im sorry I grew up in the windows age so when you refer to changing the path
>variable setting you are talking in a foreign language to me :(

Edit AUTOEXEC.BAT and add C:\mysql1\bin to the value of PATH
that you find there...

>
>Still in anticipation!!!
>
>Regards
>
>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