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.
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
----- Original Message -----
From: "Paul DuBois" <paul@stripped>
To: "Sara" <sara.morgan@stripped>; <mysql@stripped>
Sent: Wednesday, July 11, 2001 10:38 PM
Subject: Re: Using Scripts with MySQL - NEWBIE
> At 7:31 PM +0100 7/11/01, Sara wrote:
> >Hi
> >
> >I am using Paul Dubois' book MySQL to teach myself. He has sample
> >data base data which one can load using his scripts.
> >
> >However, the book doesn't say where the scripts have to be loaded to
> >inorder for them to work ie which directory?
> >
> >Also can someone just confirm the syntax for a create table script
> >(ie how to load it).
> >
> >The theory I understand, howerver I'm having some problems with
> >minor technicalities!
> >
> >Many thanks in anticipation
> >
> >Sara
>
> Assuming you have unpacked the samp_db distribution into a directory
> named samp_db, just cd into that directory, and then to execute a
> file of SQL statements, use this command:
>
> mysql samp_db < filename
>
> For example, to run the create_president.sql script:
>
> mysql samp_db < create_president.sql
>
>
> --
> Paul DuBois, paul@stripped
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread79200@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-red=aboutmightyred.co.uk@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
