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' INTO TABLE
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
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 first column
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 user -ppassword --local --fields-terminated
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' INTO TABLE dsc FIELDS
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
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'.
Why this error-message
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!
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 '\\r\\n';
When I try it using 3.23.55 I get
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
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
'' LINES TERMINATED BY '\\r\\n';
When I try it using
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 messages above. The data seems to be the
same on master and slave
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 messages above. The data seems
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 either
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 line
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 I do a show
- Adelaide)
Cc: MySQL List
Subject: Re: LOAD DATA LOCAL INFILE issue
Perhaps the problem is that there is no such option as
--enable-local-infile
in the mysql client. I believe you want --local-infile. Client options
are
detailed in the manual http://dev.mysql.com/doc/mysql/en/mysql.html.
Michael
Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - 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
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 your help,
David
: 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 INFILE. Is there a
setting that needs to be tweaked for this to work
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.
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
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
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.
If you don't specify IGNORE or REPLACE keyword, LOAD DATA LOCAL works the same as
IGNORE
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 or
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
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,44
Thanks,
Dan
--
MySQL General Mailing List
For list archives
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
Text field with , a comma between quotes,1.2,44
I believe it's
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 parameters of the LOAD DATA LOCAL INFILE
command for a comma separated text file like this:
Text
LOCAL INFILE
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,44
Thanks,
Dan
--
MySQL General Mailing List
For list
=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
Subject: Re: LOAD DATA LOCAL INFILE question...
Robert [EMAIL PROTECTED] wrote:
Having
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 result set.
I
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.net/
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 has the appropriate permissions configured in the MY.INI file
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 verified using
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 TERMINATED BY ';' OPTIONALLY ENCLOSED BY '\'
Vielen Dank fr die Hilfe.
Gru Bjrn
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 the command
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_DATA_LOCAL
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 manual from
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, then LOAD DATA
LOCAL
-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.12-max
).
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, all MySQL clients and libraries are compiled
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
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 command
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 file.txt delimited with '^' with character '#'
When :
LOAD DATA LOCAL INFILE 'file.TXT' into table table on mysql fields
terminated by '#' OPTIONALLY ENCLOSED
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 file.txt delimited with '^' with character '#'
When :
LOAD DATA LOCAL INFILE 'file.TXT' into table table on mysql fields
- 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
At 11:50 +0200 3/14/03, Sebastian Stan wrote:
i
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 binary log, because when
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-Command-line tool i get
an errror
: 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.
I update to this version from 4.0.5. With this version I have
\binmysql 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 help. Type '\c' to clear the buffer.
mysql load data local infile 'c:/test.txt' into table umlaut;
ERROR 1148
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 server
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
-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
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 error: The used command is not allowed
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 DATA LOCAL INFILE \ + FIC_DB + \ REPLACE INTO TABLE news
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 command is not allowed with this MySQL version
at org.gjt.mm.mysql.MysqlIO.sendCommand
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.FileNotFoundException
-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.Due to underlying
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 guess local option
-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 program
* 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 environments be reduced to a single
backslash. Your result
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 '' lines terminated by \n' IGNORE 1
LINES ( id
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 client with --local-infile[=1
: 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've tried using the flags on startup of MySQL as shown
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 I remember from MySQL trainings
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
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 server
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.23.49 and MySQL 4.0.2, we added some new options
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?
Terence Ng
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?
Terence Ng
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
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]
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
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
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
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 INTO TABLE
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 --local-infile=1
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 it work
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 or in the /usr/local/mysql/data directory.)
JC
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 is located in
/Users/jack/Desktop
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. Anyway
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 /Users/jack/Desktop/SQL_stuff/samp_db/, then the command:
JC mysql LOAD
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 table absence
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;
does work.
But the command:
mysql LOAD DATA LOCAL INFILE
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 show tables
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;
Database changed
mysql show tables
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 documentation file :
[skip
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_infile=1
SC When I perform the LOAD
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
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 going on?
Thanks
Ron
Petty wrote:
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 going
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 application using
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 version 4.1.2 and MySQL 3.23.49
i have read several archives/docs on this but still can not get this to
work
from the mysql command line, load data local infile DOES work,
am trying to get this to work from Perl
$sth = $dbh-prepare(load data local infile
'/users/hcir/desktop/t2/0001' into table s0001);
$sth-execute
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 read several archives/docs
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 several archives/docs
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-prepare(load data local infile
'/users/hcir/desktop/t2/0001
Uriel,
Monday, September 09, 2002, 4:21:40 AM, you wrote:
C:mysql -r -N fall02 \mysqluw\mysql.txt
UW (i.e. using the mysql command from DOS, and running a batch file)
UW And I didn't change any configuration defaults since installing mySQL on
UW this machine.
Put local-infile=1 in the
1 - 100 of 157 matches
Mail list logo
