RE: mysql LOAD DATA INFILE - Donald Tyler - com.mysql.lists.mysql

15 messages in com.mysql.lists.mysqlRE: mysql LOAD DATA INFILE

From	Sent On	Attachments
Mike At Spy	08 Aug 2003 12:34
Donald Tyler	08 Aug 2003 12:41
Jay Blanchard	08 Aug 2003 12:57
Mike At Spy	08 Aug 2003 12:58
Donald Tyler	08 Aug 2003 13:06
Donald Tyler	08 Aug 2003 13:08
Jay Blanchard	08 Aug 2003 13:08
Mike At Spy	08 Aug 2003 13:09
Jay Blanchard	08 Aug 2003 13:14
Mike At Spy	08 Aug 2003 13:19
Mike At Spy	08 Aug 2003 13:23
Donald Tyler	08 Aug 2003 13:29
Mike At Spy	08 Aug 2003 13:39
Jay Blanchard	08 Aug 2003 13:39
Hans van Harten	08 Aug 2003 15:24

Subject:	RE: mysql LOAD DATA INFILE
From:	Donald Tyler (dty...@frazerbilt.com)
Date:	08/08/2003 01:08:01 PM
List:	com.mysql.lists.mysql

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:dty...@frazerbilt.com] Sent: Friday, August 08, 2003 3:07 PM To: 'mys...@lists.mysql.com' 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:spyc...@spyproductions.com] Sent: Friday, August 08, 2003 2:59 PM To: Donald Tyler; mys...@lists.mysql.com 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,

-----Original Message----- From: Donald Tyler [mailto:dty...@frazerbilt.com] Sent: Friday, August 08, 2003 3:42 PM To: mys...@lists.mysql.com 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:spyc...@spyproductions.com] Sent: Friday, August 08, 2003 2:35 PM To: mys...@lists.mysql.com 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,

http://lists.mysql.com/mysql?unsub=dty...@frazerbilt.com