Hi Richard, Try looking at mysqlimport instead. I'm only taking a punt that it works with that version but the manual doesn't say anything about it being since a certain version. It works as at 3.23.58 so hopefully it may do for .55
Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: Richard Whitney [mailto:[EMAIL PROTECTED] Sent: Thursday, 28 October 2004 10:37 AM To: [EMAIL PROTECTED] Subject: LOAD DATA LOCAL INFILE Hi! Can someone point me in the right direction? I have this that works in v.4x: $sql = "LOAD DATA LOCAL INFILE '$file' REPLACE INTO TABLE `members` FIELDS TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\\\' LINES TERMINATED BY '\\r\\n'"; When I try it using 3.23.55 I get the following error: #1148 - The used command is not allowed with this MySQL version Is there any way I can make this work using 3.23.55? TIA! R. Whitney Transcend Development "Producing the next phase of your internet presence" http://xend.net Premium Quality Web Hosting http://hosting.xend.net [EMAIL PROTECTED] 310-943-6498 602-288-5340 "The day this country abandons God is the day God will abandon this country" "Linux is like a wigwam, no windows, no gates, apache inside." - borrowed from Sharon Kimble off of the Fedora mailing list -- 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]