By default, "LOAD DATA INFILE ..." is disabled (I am not sure from which
version). You may need to compile MySQL with -enable-local-infile". You
may find details on www.mysql.com .
Ruth
- Original Message -
From: "mysql" <[EMAIL PROTECTED]>
To: "mySQL List" <[EMAIL PROTECTED]>
Sent: Tue
I ran into this too. I assume it is a limitation on the free version of MySQL, and
that
you have to pay to use "load data" in an SQL script. To import my data files, I use
the "mysqlimport" function from the command line or batch file. It seems to support
most of the "load data" options.
-
uford
- Original Message -
From: "Insanely Great" <[EMAIL PROTECTED]>
To: "Padma kuruganti" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, December 07, 2002 12:32 PM
Subject: Re: LOAD DATA command
> Greetings...
>
> Are you using Windows to con
Greetings...
Are you using Windows to connect to the MySQL. Then you can try SQLyog at
http://www.webyog.com/sqyog/download.html It will help you a lot in these
works and you dont have to write queries also.
Rgds
Insane
- Original Message -
From: "Padma kuruganti" <[EMAIL PROTECTED]>
To:
i believe that this security issue came up with the .51 version of mysql
you can remove this block by adding this to your my.cnf file
[mysqld]
local-infile=1
[mysql]
local-infile=1
- hcir
On Friday, December 6, 2002, at 10:16 AM, Padma kuruganti wrote:
Hi I just downloaded version 3.23.53 fo
Hi Joshua,
what exactly did you try? LOAD DATA INFILE seems to be working on my
box ;-)
Joshua Richards wrote:
>
> Hi,
> Could anyone please tell me how I could load a text file into a specific
> column in mysql.
> I tried LOAD DATA INFILE but didn't work
>
> Thanks,
>
> J.Richards
>
>
If the table has a unique key then add the REPLACE keyword.
This will update the columns with new values if the key already exists
and add the row if it doesnt.
--Mark
Michael Kaiser wrote:
> Using the following inserts data from a text file into a particular MySQL
> table:
>
> LOAD DATA LOC
