Thanks for replaying
That is what I am not able to figure out what to use in FIELDS TERMINATED
BY, LINES TREMINATED BY
My fields are terminated by Ü and my lines are terminated by '¢ and that
I have clearly mentioned in my query
LOAD DATA LOCAL INFILE 'd:\\data3.txt&#x
You need to check your syntax. You probably don't have FIELDS
TERMINATED BY and [OPTIONALLY] ENCLOSED BY and ESCAPED BY set
correctly.
True... those options are there for both LOAD DATA LOCAL INFILE and
mysqlimport
example:
mysqlimport -u -p --local --fields-terminated-by='|&#x
cuting this query for this table I am not getting any error..
But I am getting wrong result.
I have tried many combinations for LOAD DATA LOCAL INFILE but I am getting
the results in two ways...
1. all the data getting loaded in first columns of first row.
Or
2. data for all columns getting loaded in f
Hi harish
Thanks for reply
By executing this query for this table I am not getting any error..
But I am getting wrong result.
I have tried many combinations for LOAD DATA LOCAL INFILE but I am getting
the results in two ways...
1. all the data getting loaded in first columns of first row.
Or
2
I went through a lot of trouble with Load data local infile... There are a
lot of things regarding Local that MySql does not allow due to security
reasons. As mentioned before this you could give us the error... that might
help
alternatively try out mysqlimport
http://dev.mysql.com/doc/refman
:04Ü
FISHÜ
1 COUNTRY: JORDAN
2 COUNTRY: SAUDI ARABIA
...
I am trying to import the text file into table. I have tried various ways
but unable to find the solution. the code I am trying to import the file is
as follows
LOAD DATA LOCAL INFILE 'd:\\data3.txt'
is
as follows
LOAD DATA LOCAL INFILE 'd:\\data3.txt' INTO TABLE dsc FIELDS TERMINATED BY
'Ü\n' LINES TERMINATED BY '¢\n' (ch_code, name, info);
Can any one help me in loading this file
Regards
Neeraj Black Bits
Richard Whitney wrote:
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
''
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
Hi.
See
http://dev.mysql.com/doc/mysql/en/LOAD_DATA_LOCAL.html
"Martin Rytz" <[EMAIL PROTECTED]> wrote:
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ _
Hi mysql-community!
I have a problem with mysql 3.23.49a:
If I try to use the statement 'LOAD DATA LOCAL INFILE
'/storage/hosting/uxclients/www.xxx.ch/transfer/golfclub.csv' INTO TABLE
test'
mysql replys: 'The used command is not allowed with this MySQL version&#
anyone has seen similar messages.
> I have master-slave replication setup on 2 Linux boxes running
> MySQL 4.1.5-gamma. On a Windows client, I execute a script that
> contains a bunch of LOAD DATA LOCAL INFILE statements.
>
> The master error log does not complain. But the slave er
e has seen similar messages.
I have master-slave replication setup on 2 Linux boxes running
MySQL 4.1.5-gamma. On a Windows client, I execute a script that
contains a bunch of LOAD DATA LOCAL INFILE statements.
The master error log does not complain. But the slave error log
has the error/warning me
8408 4259 - Fax
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 3:19 PM
To: Logan, David (SST - Adelaide)
Cc: MySQL List
Subject: Re: LOAD DATA LOCAL INFILE issue
Well, as you say, that error message means it's been disabled in e
- Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 2:37 PM
To: Logan, David (SST - Adelaide)
Cc: MySQL List
Subject: Re: LOAD DATA LOCAL INFILE issue
Perhaps the problem is that there is no such option as
--enable-local-i
Hi Michael,
Thanks. I rechecked things but
porkribs /u2/lcscreative/sql_scripts $ mysql --local-infile -u davidl -p
mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 2:37 PM
To: Logan, David (SST - Adelaide)
Cc: MySQL List
Subject: Re: LOAD DATA LOCAL INFILE issue
Perhaps the problem is
ving a few issues with a LOAD DATA LOCAL INFILE command. As you
can see by the command below, I am receiving an error 1148. The
documentation states this is generally because I don't have
--enable-local-infile on in both client and server. I have switched it
on via command line below and when
Hi Folks,
I am having a few issues with a LOAD DATA LOCAL INFILE command. As you
can see by the command below, I am receiving an error 1148. The
documentation states this is generally because I don't have
--enable-local-infile on in both client and server. I have switched it
on via command
lt;[EMAIL PROTECTED]>
Sent: Tuesday, July 13, 2004 11:14 AM
Subject: "LOAD DATA LOCAL INFILE" doesn't show in binlog
> Hi,
>
> I'm running MySQL 3.23.52 with binary logging enabled. All commands seems
to
> be written to the log except for "LOAD DATA LOCAL INFI
Hi,
I'm running MySQL 3.23.52 with binary logging enabled. All commands seems to
be written to the log except for "LOAD DATA LOCAL INFILE". Is there a
setting that needs to be tweaked for this to work?
Thanks for y
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using 4.0.18.
I have scoured the archives and reconfigured my.ini with:
Set-variable = local-infile=1
I have tried it on the command line tooand still I get the dreaded
"command not valid for this version of MySQL" error.
I am using:
WinXP Pro/IIS
MyODBC driver 3.51
MySQL 3.23.58 - I cant go to 4 but the p
This is from the manual. See the 3rd paragraph.
> The REPLACE and IGNORE keywords control handling of input records that duplicate
> existing records on unique key values.
>
> If you specify REPLACE, input rows replace existing rows (in other words rows that
> has the same value for a primary
If I put an index with the duplicates, I only
> get the first set of data with no updates.
>
> Is there something about primary keys I should know about? I've created
> this database with them and tried every combination, but I can't seem to
> get the update part to work.
I'm load a CSV file with five fields into mysql. It loads up fine.
Problem comes in when I try to refresh the data with updates.
I grab this file and convert it to CSV every 12 hours. The data shows
past 24 hours only, so basically I'm trying to make a permanent archive.
I tried creating a PRI
> -Original Message-
>> From: Daniel Kiss [mailto:[EMAIL PROTECTED]
>> Sent: Tuesday, December 09, 2003 3:02 PM
>> To: [EMAIL PROTECTED]
>> Subject: LOAD DATA LOCAL INFILE
>>
>>
>> Hi all,
>>
>>
>> How should I set the parameter
Johnson's posting
(escaped by '\' is default)
> -Original Message-
> From: Daniel Kiss [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 09, 2003 3:02 PM
> To: [EMAIL PROTECTED]
> Subject: LOAD DATA LOCAL INFILE
>
>
> Hi all,
>
> How should I set th
From: Daniel Kiss [mailto:[EMAIL PROTECTED]
> Hi all,
>
> How should I set the parameters of the LOAD DATA LOCAL INFILE
> command for a comma separated text file like this:
>
> "Text field",.4,123
> "Text field with "" included quote",,45
>
Hi all,
How should I set the parameters of the LOAD DATA LOCAL INFILE command for a comma
separated text file like this:
"Text field",.4,123
"Text field with "" included quote",,45
"Text field with "","" a comma between quotes",1.2,
Versions:
> > Server is Win32 MySQL max 4.0.16
> > Client is FreeBSD MySQL 4.0.13
-- R
> Should work.
> What are the server and client versions?
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita
"Reverend Deuce" <[EMAIL PROTECTED]> wrote:
> Egor,
>
> Thanks for the info. However, like I said, I already have "local-infile=1"
> and "set-variable = local-infile=1" in my my.ini on the server. I also have
> already done 'show variable like '%infile%' ' and receive "local_infile
> ON" in the re
t set.
I run the command line client with --local-infile=1
I still receive the same error regardless of the configuration.
-- R
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 22, 2003 5:25 AM
Subjec
"Robert" <[EMAIL PROTECTED]> wrote:
>
> Having problems using 'LOAD DATA LOCAL INFILE' from a UNIX client talking to
> a Win32 server. I've read the documentation several times now and have had
> zero success with this command.
>
> My server
Greetings,
Having problems using 'LOAD DATA LOCAL INFILE' from a UNIX client talking to
a Win32 server. I've read the documentation several times now and have had
zero success with this command.
My server has the appropriate permissions configured in the MY.INI file
(this was
Server hat die MySQL Version
> 3.23.44 und der Import funktioniert. Ich habe die Rechte alle
> angeschaltet, so dass es auch da keine Probleme geben sollte.
>
>
>
> Hier mein Befehl:
>
> LOAD DATA LOCAL INFILE 'csv/gversand.csv' REPLACE INTO TABLE versand
> FIELDS TE
angeschaltet, so dass es auch da keine Probleme geben sollte.
Hier mein Befehl:
LOAD DATA LOCAL INFILE 'csv/gversand.csv' REPLACE INTO TABLE versand
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\"'
Vielen
OS X (10.1 Client and 10.2 Server).
My 3.23.51 builds seem to have the same problem.
Since PHP access it properly, and the MySQL client can with the
proper variable setting, I guess I'll just leave it alone.
- John
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John May wrote:
The other odd
).
Regards.
ROny
- Original Message -
From: "John May" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 09, 2003 3:31 AM
Subject: Re: Load Data Local Infile
> The other odd thing I find is that the MySQL manual states:
>
>
> By default, a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John May wrote:
> The other odd thing I find is that the MySQL manual states:
>
>
> By default, all MySQL clients and libraries are compiled with
> --enable-local-infile , to be compatible with MySQL 3.23.48 and before.
>
>
> However, I'm using a 4.0.
en calling safe_mysqld both with no luck.
In the meantime, I've found that PHP apparently calls MySQL with the
local-infile option on - once I downgraded to 4.2.2 from 4.3.0 that
is. This at least helps things a bit.
- John
If you don't configure MySQL with --enable-local-infile,
nce I downgraded to 4.2.2 from 4.3.0 that
is. This at least helps things a bit.
- John
If you don't configure MySQL with --enable-local-infile, then LOAD DATA
LOCAL will be disabled by all clients, unless one calls mysql_options(...
MYSQL_OPT_LOCAL_INFILE, 0) in the client
Read the mysql m
If you don't configure MySQL with --enable-local-infile, then LOAD DATA
LOCAL will be disabled by all clients, unless one calls mysql_options(...
MYSQL_OPT_LOCAL_INFILE, 0) in the client
Read the mysql manual from msyql.com about
'manual_MySQL_Database_Administration.html#LOAD_
OK, tearing my hair out here...
I am trying to get a LOAD DATA LOCAL INFILE command to work. It
works when I start the MySQL client with "--local-infile=1", but
never in any other situation. Starting without this option, or
submitting the request through PHP or Lasso results in th
Vahri? MUHTARYAN <[EMAIL PROTECTED]> wrote:
> I commented out because they are not working when I use set-variable =
> local-infile=1 in Server and Client .. Mysql is not starting
>
> ?f I use local-infile=1 -- Mysql is starting but still same problem ...
>
> I used --local-infile=1 at c
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Sebastian Stan" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:02 PM
Subject: Re: HEPL: LOAD DATA LOCAL skips recors
&g
At 11:50 +0200 3/14/03, Sebastian Stan wrote:
i have 2 DBFs and i'm doing the same thing on both of them : (i'm
transforming the DBFs in TXTs)
(in foxpro) " copy to .txt delimited with '^' with character '#' "
When :
LOAD DATA LOCAL INFILE
i have 2 DBFs and i'm doing the same thing on both of them : (i'm
transforming the DBFs in TXTs)
(in foxpro) " copy to .txt delimited with '^' with character '#' "
When :
LOAD DATA LOCAL INFILE '.TXT' into table fields
terminated by &
The manual does not give any warnings about using "load data local" when
applying changes via the binary log.
I am having trouble getting my head around how this would work.
IE if you update a table via "load data local" then how can you replicate
these changes using the
you described), and I start the client with the same option,
I get this:
C:\mysql\bin>mysql test --local-infile=1
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 4.0.10-gamma-max-nt-log
Type 'help;' or '\h' for h
[SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 20, 2003 1:07 PM
> To: [EMAIL PROTECTED]
> Subject: re: Bug-Load data local infile
>
> On Wednesday 19 February 2003 17:30, Guddack Thorsten ICM MP SCM GO 21
> wrote:
>
> > I'm using 4.0.10-max-nt of mysql.
On Wednesday 19 February 2003 17:30, Guddack Thorsten ICM MP SCM GO 21 wrote:
> I'm using 4.0.10-max-nt of mysql.
>
> I update to this version from 4.0.5. With this version I have no trouble
> with load data local infile.
>
> But now if i try to use it from the mysql-Comma
Hi List,
I'm using 4.0.10-max-nt of mysql.
I update to this version from 4.0.5. With this version I have no trouble
with load data local infile.
But now if i try to use it from the mysql-Command-line tool i get
an errror 1148, This command is not allowed with this mysql version.
On my s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
HI,
Thanks all for the suggestions given for load data... It indeed helped
me a lot.
Right now i am using J/connector version 3 .
Load data local works fine with version 3.
I hit a new problem. It works fine when
HI,
Thanks all for the suggestions given for load data... It indeed helped
me a lot.
Right now i am using J/connector version 3 .
Load data local works fine with version 3.
I hit a new problem. It works fine when there are below 2 records
in the file. When i tried wiht 4,00,000
* Ahmed S K Anis
[...]
> String filepath = "sys:\\restore\\data1.txt";
> String query = "load data local infile \'" + filepath + "\' into table
> x
>
> it takes as estoredata1.txt as file name not clear why ?
A double backslash will in many e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Yes Mark it worked from the command line.
The Archived resides at the server side.
I ran Load data local infile 'sys:\\mail\\dump.txt" into table X
it worked.
The from a different machine i ran this java pr
Yes Mark it worked from the command line.
The Archived resides at the server side.
I ran Load data local infile 'sys:\\mail\\dump.txt" into table X
it worked.
The from a different machine i ran this java program. The Archived
file still exists at the DB server side.
So i g
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Thanks Mark,
I tried to work with the latest driver. 3.0.4
Now it gave error shown below . Also see code snippet below at the
end
Error code is0
estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Du
Thanks Mark,
I tried to work with the latest driver. 3.0.4
Now it gave error shown below . Also see code snippet below at the
end
Error code is0
estoredata1.txt'for 'LOAD DATA LOCAL INFILE' command.Due to underlying
IOExcepti
on:
** BEGIN NESTED EXCEPTION **
java.io.FileNo
using this command into a Java servlet
LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INTO TABLE news";
It runs well with mysql-3.23.45 but not with mysql-3.23.55
The error message is :
java.sql.SQLException: General error: The used co
Hi all,
please let me now if there is a solution to this.
I am facing the same problem.
Anis
>>> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Wednesday, February 12,
>2003 3:48:16 PM >>>
Hello,
I'm using this command into a Java servlet
LOAD DA
Hello,
I'm using this command into a Java servlet
LOAD DATA LOCAL INFILE \"" + FIC_DB + "\" REPLACE INTO TABLE news";
It runs well with mysql-3.23.45 but not with mysql-3.23.55
The error message is :
java.sql.SQLException: General
Hello
I have a fixed width csv file. To import it I use the
following statement -
load data local infile 'F:/Documents and
Settings/Insane/Desktop/test.csv'
into table `insane`.`user_details_copy` fields escaped
by '\\' enclosed by
'' terminated by '' lin
Egor,
>> Any hints how to make LOAD DATA LOCAL work in spite of this
>> "improvement"?
> Stefan, currently I have no Windows box on hands, to check it out on
Win32, but I
> remember that it works for me at least on 4.0.6 with local-infile=1 in
> my.cnf.
as far as
PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 03, 2003 11:19 PM
Subject: Re: LOAD DATA LOCAL
I posted the same question two weeks ago. The only suggestion was to add
flags to the my.cnf file:
[mysqld]
local-infile=1
[mysql]
local-infile=1
But this didn't work.
I'v
On Friday 03 January 2003 22:38, Stefan Hinz wrote:
> I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD
> DATA LOCAL (keep getting error 1148). I tried:
>
> - Starting the server with --local-infile=1, and with --local-infile.
> - Starting the mysql clie
.23.49.
I then upgraded to 3.23.54a which appears to have the command turned on
when compiled - the configure line says --enable load data local - but it
doesn't work for this version either (on my system).
I wrote a work around script to allow upload of the file through a form on
the web
Hi,
(I posted this question once before in a Re: that everyone seems to have
missed ;-)
I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD
DATA LOCAL (keep getting error 1148). I tried:
- Starting the server with --local-infile=1, and with --local-infile.
- Starting the
Terence, Rich,
> > I have tried:
> > LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE lcopen;
> > but it shows:
> > ERROR 1148: The used command is not allowed with this
> > MySQL version
This is because of security issues, as the manual says:
In MySQL 3.
sound like you may want to add the following to your my.cnf file for
MySQL
[mysqld]
local-infile=1
[mysql]
local-infile=1
- hcir
On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote:
Hi,
I have just upgraded to 3.23.54
How to input bulk data into table?
I have tried:
LOAD DATA
Hi,
I have just upgraded to 3.23.54
How to input bulk data into table?
I have tried:
LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE
lcopen;
but it shows:
ERROR 1148: The used command is not allowed with this
MySQL version
How come? What method can I use to input bulk data?
Hi,
I have just upgraded to 3.23.54
How to input bulk data into table?
I have tried:
LOAD DATA LOCAL INFILE "lcopen1.txt" INTO TABLE
lcopen;
but it shows:
ERROR 1148: The used command is not allowed with this
MySQL version
What did I miss?
What method can I use to input bulk data?
Thanks for the suggestions.
So far I haven't been able to get this to work except on the client command
line. I'm trying to use some PHP scripts with mysql_connect() and have
added MYSQL_OPT_LOCAL_INFILE to the connection script as well, but no go.
I added
[client}
local-infile=1
[mysql]
local
Guo wrote:
Hi:
I am using mysql v4_0_5 both clinet and server. I cannot get load
data local infile to work after many different tries. Does anyone
make it work with this version? It worked for when I used v3.23.52
try adding these line to your my.cnf file (mysql config file)
[mysqld]
local-infile=1
[mysql]
local-infile=1
- hcir
On Thursday, December 12, 2002, at 09:52 AM, Yuyi Guo wrote:
Hi:
I am using mysql v4_0_5 both clinet and server. I cannot get load data
local infile to work after many
Hi:
I am using mysql v4_0_5 both clinet and server. I cannot get load data
local infile to work after many different tries. Does anyone make it
work with this version? It worked for when I used v3.23.52.
Thanks for any tips, Yuyi
Hi,
When trying to use 'LOAD DATA LOCAL INFILE' with Apache2.0.43 (running a
module) and MySQL 3.23.53, it returns the error the command is not
supported. This is because the function is disable for security issue, but
when I tried to start mysql with 'c:\mysql\bin\mysqld-nt --loc
Hi.
I have a MySQL database running on a remote web server.
I have a text data file sitting on my PC here.
I want to get the data from the text file to the database and am having
difficulties! I log onto the database and I'd like to issue
LOAD DATA LOCAL INFILE "c:/thedata.txt&q
Sarah,
Wednesday, December 04, 2002, 12:48:15 AM, you wrote:
SK> We updated mysql yesterday to 3.23max and have just discovered that "load
SK> data local infile ." no longer works unless you enable it somewhere
SK> specifically. I've tried starting mysql with the option -local-infile=1 in
SK>
We updated mysql yesterday to 3.23max and have just discovered that "load
data local infile ." no longer works unless you enable it somewhere
specifically. I've tried starting mysql with the option -local-infile=1 in
several different files and on the command line. I can make
absence.txt
JC> and, with that done, the
JC> LOAD DATA LOCAL INFILE "absence.txt" into table absence;
JC> command in the mysql client successfully did load it.
JC> (It didn't work when put into the /usr/local/mysql/scripts directory
JC&
Victoria and Michael:
Thanks very much.
Following on your suggestions, I then went ahead and put the text file
into my directory:
/usr/local/mysql
so that the file was then /usr/local/mysql/absence.txt
and, with that done, the
LOAD DATA LOCAL INFILE "absence.txt" into tab
ient host into a
JC> database by running the client mysql and executing the following
JC> command:
JC> mysql> LOAD DATA LOCAL INFILE "absence.txt" into table absence;
JC> When "absence.txt" is located in
JC> "/User
November 2002 14:12
To: [EMAIL PROTECTED]
Subject: LOAD DATA LOCAL INFILE
Hello all ---
I posted this yesterday, perhaps before my subscription took effect,
and so I am not sure that it got distributed. So, forgive the
repetition in sending, if that's the case. A
n seems to say that one can load a tab-delimited text
file located in the current directory of the client host into a
database by running the client mysql and executing the following
command:
mysql> LOAD DATA LOCAL INFILE "absence.txt" into table absence;
When "absence.txt&
OAD DATA LOCAL INFILE "absence.txt" into table absence;
When "absence.txt" is located in
"/Users/jack/Desktop/SQL_stuff/samp_db/", then the command:
mysql> LOAD DATA LOCAL INFILE "/Users/jack/Desktop/SQL_stuff/samp_db/
absence.txt" into table absence;
Pallavi,
Wednesday, November 20, 2002, 11:01:51 AM, you wrote:
PAP> i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
PAP> Apache 1.3.24 .
PAP> i have encounter following error for load data local infile when i
PAP> tried to use an example on mysql site's docume
Hello Pallavi,
> i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
> Apache 1.3.24 .
> i have encounter following error for load data local infile when i
> tried to use an example on mysql site's documentation file :
> mysql> use test;
> Databas
hello everybody,
i m using redhat linux 7.2 with & mysql 3.23.49a-max-log with
Apache 1.3.24 .
i have encounter following error for load data local infile when i
tried to use an example on mysql site's documentation file :
mysql> use test;
Database changed
mysql&
uot;Disconnect failure: $DBI::errstr\n";
- hcir
On Monday, Oct 7, 2002, at 18:51 America/Anchorage, Ronald Petty wrote:
> I just tried the following and got
>
> ysql> load data local infile "/home/repett0/contact.data" into table
> CONTACT;
>
I just tried the following and got
ysql> load data local infile "/home/repett0/contact.data" into table
CONTACT;
ERROR 1148: The used command is not allowed with this MySQL version
mysql>
I too use perl and dbi
What is goin
I have found to do a LOAD DATA LOCAL INFILE is no longer possible
using perl-DBI, even though local-infile=1 is in the [mysql], [mysqld],
and [client] sections of my.cnf.
I am not sure what prompted the engineering powers-that-be to
change the default for this version, 3.23.49, of mysql, but it
Sorin,
Saturday, October 05, 2002, 8:33:23 AM, you wrote:
SC> 1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
SC> file?
SC> My.ini file is below:
SC> [mysqld]
SC> basedir=C:/mysql
SC> datadir=C:/mysql/data
SC> enable-local-infile
SC> local_infi
1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
file?
My.ini file is below:
[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
enable-local-infile
local_infile=1
When I perform the LOAD DATA LOCAL INFILE 'file_name.txt' INTO... command
from a client applica
I'm having problems with php scripts that use 'LOAD DATA LOCAL INFILE'. Each time I
run a script, I get an error in the server log
saying MySQL query failed: "LOAD DATA LOCAL INFILE " : The used command is not
allowed with this MySQL version.
We're using php v
THANKS!!
that works!
- hcir
> I have had luck by removing the word LOCAL from the statement.
>
> -=Bryan=-
>>
>> from the mysql command line, load data local infile DOES
>> work, am trying to get this to work from Perl
>>
>> $sth = $dbh->prepa
Try leaving out the word local. This corrected the same problem on XP Prof.
BobJ
- Original Message -
From: "nellA hciR" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Thursday, September 12, 2002 2:32 PM
Subject: load data local infile
I have had luck by removing the word LOCAL from the statement.
-=Bryan=-
> -Original Message-
> From: nellA hciR [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 11:33 AM
> To: MySQL List
> Subject: load data local infile
>
>
> i have read sever
1 - 100 of 165 matches
Mail list logo
