\. 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] <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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql <http://lists.mysql.com/mysql> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] <http://lists.mysql.com/[EMAIL PROTECTED]>