-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Jerome Smith wrote:
> Hello everybody,
>
> Im 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
It's actually a bug with the windows binaries (until version 4.0.13).
This is fixed in 4.0.13 (which is the current stable build of MySQL).
-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+2NVmtvXNTca6JD8RAiQFAJwJzqO+TfEbv9e7vLsZWd072dVnTgCdFIgR
EkY+CRktLnc1YezXCA2IGxM=
=Iakc
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
