RE: Reading and Executing a source...

[Paul DuBois]

At 2:42 PM -0500 11/17/03, Ola Ogunneye wrote:
Thanks Paul,

Just to be crystal clear, at the mysql prompt, I will type    source
stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Looking something like this:

mysql>source stations.sql \.
E:\Apache\apache2\htdocs\public_html\weather\stations.sql
Or am I not supposed to include the source stations.sql at all?
You use either source or \. when you enter the command -- not both.
They are synonyms.  That is, at the mysql> prompt, you should type
either this:
\. E:\Apache\apache2\htdocs\public_html\weather\stations.sql

or this:

source E:\Apache\apache2\htdocs\public_html\weather\stations.sql

The semicolon at the end can be given, but need not.


Is there a ; at the end or I do not need one.

Thanks a lot for your response

Ola
 Paul DuBois <[EMAIL PROTECTED]> 11/17/03 02:08PM >>>
At 10:28 AM -0500 11/17/03, Ola Ogunneye wrote:
Can you elaborate please? Like I said, the sql file I am executing is
in
E:\Apache\apache2\htdocs\public_html\weather

I see that you typed \ c>\loadfile.sql - Please explain. I really am
new
to this.
No, he typed \., not \, and c:, not c>.  If you change characters like
that,
you will have little success.
What he meant (I think) was that the general form of the command is:

\. path-to-the-file-you-want-to-load

In your case, at the mysql> prompt, type:

\. E:\Apache\apache2\htdocs\public_html\weather\stations.sql



Thank you

  Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:56AM >>>
\. c:\loadFile.sql
-----Original Message-----
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:41 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Reading and Executing a source...
The problem is that I was getting an error message. I am not at home
right now, and should have posted the message last night. However, my
main question is trying to know based on what the instruction says:
Using mysql - connect as your root or other privileged user
   connect to your geeklog database
   Using "source" read in and execute the SQL file
o mysql# source stations.sql;

How do I type the above at the mysql prompt? Do I need to reference the
directory where the stations.sql is residing? the file stations.sql
resides in E:\Apache\apache2\htdocs\public_html\weather\
Do I need to point to this directory in order to execute the query or
how does mysql know where to find the file. If I have to point to it,
do
I then just type at the mysql prompt

mysql>source d:/apache/apache2/htdocs/public_html/weather/stations.sql;

Please advice once again....

Thanks
  Victor Pendleton <[EMAIL PROTECTED]> 11/17/03 08:22AM >>>
What seems to be the problem? Are you getting an error message? If so
can
you post the message?
The syntax is \. fileName
-----Original Message-----
From: Ola Ogunneye [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 7:10 AM
To: [EMAIL PROTECTED]
Subject: Reading and Executing a source...
I am using a program that says I should use source to read in and
execute a file. I tried using the direction in Mysql second edition I
think on page 795 or something thereabout,
source file_name, /. file_name

I do not have the complete syntax, but what I did reesembled something
like the above. Only thing I chaged was the file_name.
What I needed to do is described below, and I am using mysql 4.0.13 Can
someone please let me know how to accomplish this?
I have root privilege and I get to the mysql prompt. I also invoked the
use database command and that was successful, but I just cannot
accomplish the following...Please Help
Using mysql - connect as your root or other privileged user
   connect to your geeklog database
   Using "source" read in and execute the SQL file
o mysql# source stations.sql;
 >
Best regards

 >Ola


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]