Thanks again Keith-- I put in the mysql_error() and it told me I had an access denied issue. I then brainstormed for a second and tried adding the word local into the command ie. LOAD DATA LOCAL INFILE and it worked!! This was a simple yet big step for me and it helped to talk it out.. Thanks again!!
-----Original Message----- From: Keith C. Ivey [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:55 PM To: [EMAIL PROTECTED] Cc: Montagna, Dan Subject: RE: Load data infile issue On 5 Aug 2003 at 11:16, "Montagna,Dan" <[EMAIL PROTECTED]> wrote: > Thanks Keith, that got me past the first two queries but I'm now > getting an " Invalid DATA LOAD query" . Someone told me that the > "load data infile option is not always on by default. Is there a > piece of code I need to insert earlier in the file to "turn on" the > load local file option? "Invalid DATA LOAD query" is the message you're printing in your code. You need to print mysql_error() to see the error message MySQL is giving you, which should help in figuring out what's going wrong. If I had to guess, I'd say the problem was with the location of the file (are you giving MySQL the full path?) or with permissions. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
