Hello everybody,
I’m new to this list, and also new to MySQL. I would be very grateful if
someone could help me with the following problem:
I have MySQL server version 4.0.12 with a database on a Linux server. I
work from a Windows XP client. I am trying to load data from a text file
into a table on the server. I am using the LOAD DATA command and get the
following error message:
Database test - table RUBRO running on localhost
Error
SQL-query :
LOAD DATA LOCAL INFILE '/tmp/php7oeURC' INTO TABLE `RUBRO`
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY
'\\' LINES TERMINATED BY '\r\n'
MySQL said:
The used command is not allowed with this MySQL version
The manual says that LOAD DATA command can be used with version 3.5
onwards, and I have 4.0.12. What could the trouble be?
Thanks in advance.
Jerome Smith
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.470 / Virus Database: 268 - Release Date: 08-04-2003
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
