Ah. No wonder it dinna work. Neither did specifying the columns as Jay suggested.
I also have no choice but to do it through the browser - I don't have command line access on the server. :\ -Mike > -----Original Message----- > From: Donald Tyler [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 4:08 PM > To: [EMAIL PROTECTED] > Subject: RE: mysql LOAD DATA INFILE > > > Oh and just a note. This solution won't work if you are uploading the file > to the server through the browser. You will need to put the file on the > server and adjust the commands PATH accordingly. > > -----Original Message----- > From: Donald Tyler [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 3:07 PM > To: '[EMAIL PROTECTED]' > Subject: FW: mysql LOAD DATA INFILE > > I see you still have the word LOCAL in there. Did you try and remove it? > > To do that in PHPMyAdmin you will need to run the import so you get the > error message and then copy and paste it into the SQL section of the > PHPMyadmin tool. Delete the world LOCAL and then run the query. It should > work. > > -----Original Message----- > From: Mike At Spy [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 2:59 PM > To: Donald Tyler; [EMAIL PROTECTED] > Subject: RE: mysql LOAD DATA INFILE > > > Sorry, that is the error - my mistake. I am getting this: > > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS > TERMINATED BY ';' LINES TERMINATED BY '\r\n' > > I am using phpMyAdmin 2.3.3 - would an upgrade to the latest > version remedy > the issue? > > Thanks, > > -Mike > > > > > -----Original Message----- > > From: Donald Tyler [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 08, 2003 3:42 PM > > To: [EMAIL PROTECTED] > > Subject: RE: mysql LOAD DATA INFILE > > > > > > PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just > remove the word > > LOCAL and it should work fine. > > > > -----Original Message----- > > From: Mike At Spy [mailto:[EMAIL PROTECTED] > > Sent: Friday, August 08, 2003 2:35 PM > > To: [EMAIL PROTECTED] > > Subject: mysql LOAD DATA INFILE > > > > > > When I come across this error: > > > > The used command is not allowed with this MySQL version > > > > Does this mean that I need a whole different verison of MySQL, or just a > > different compile? The command was 'LOAD DATA INFILE' and I > was doing it > > through phpMyAdmin. > > > > Thanks, > > > > -Mike > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
