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]