[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: LOAD DATA problem
From:       Mark Matthews <mark () mysql ! com>
Date:       2003-05-31 16:16:38
[Download RAW message or body]

-----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 <mark@mysql.com>
  / /|_/ / // /\ \/ /_/ / /__ 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/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]