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? 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]