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!
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
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 below and when I do
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
[EMAIL PROTECTED] wrote:
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
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
'
Regards,
- Original Message -
From: John May [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 2:17 AM
Subject: Load Data Local Infile
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
msyql.com about
'manual_MySQL_Database_Administration.html#LOAD_DATA_LOCAL'
Regards,
- Original Message -
From: John May [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 09, 2003 2:17 AM
Subject: Load Data Local Infile
OK, tearing my hair out here...
I am trying to get a LOAD
]
Sent: Monday, June 09, 2003 2:17 AM
Subject: Load Data Local Infile
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
-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
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
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
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
THANKS VERY MUCH! That worked!
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 9:15 PM
Subject: re: Re: LOAD DATA LOCAL INFILE not allowed this version?
[.]
Put local-infile=1 in the [mysqld] and [mysql
The command
LOAD DATA LOCAL INFILE C:\\MO10.txt
INTO TABLE stud1
fields terminated by /
lines terminated by '\r\n';
produces:
ERROR 1148 at line 1: The used command is not allowed with this MySQL vers
Could someone explain why??
I'm running version MYSQL Ver 11.18 Distrib 3.23.51
One can disable all LOAD DATA LOCAL commands in the MySQL server by starting
mysqld with --local-infile=0.
In the case that LOAD DATA LOCAL INFILE is disabled in the server or the
client, you will get the error message (1148):
The used command is not allowed with this MySQL version
http
[EMAIL PROTECTED]
To: Uriel Wittenberg [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED]
Sent: Monday, September 09, 2002 8:31 AM
Subject: RE: LOAD DATA LOCAL INFILE not allowed this version?
One can disable all LOAD DATA LOCAL commands in the MySQL server by starting
mysqld with --local-infile=0
Hello,
Below is a thread from March.
Basically, I am having the same problem in
v3.23.49 (release version, not Alpha).
I also have Linux RedHat 7.2, same as Tom.
I compiled MySQL from source using gcc v2.96 .
Here are the details of my problem:
The SQL command
LOAD DATA LOCAL INFILE
Before I get started, let me say that I have looked at the manual, gone
through a number of posts to the lists and read Paul's MySQL book. I've
tried a lot of things over the course of the past three hours and am hoping
that someone can shed some light on this one.
When I do the load data
[snip]
Texas AM University,College Station, TX,1999,Design, install, test
and run blah, blah.,Whatever Industry
LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY
',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n';
[/snip]
Have you tried this...
LOAD
[snip]
Texas AM University,College Station, TX,1999,Design, install, test
and run blah, blah.,Whatever Industry
LOAD DATA INFILE 'd:\\text.csv' INTO TABLE projects FIELDS TERMINATED BY
',' OPTIONALLY ENCLOSED BY '\' ESCAPED BY '\\' LINES TERMINATED BY '\n';
Have you tried this...
LOAD DATA
Before I get started, let me say that I have looked at the manual, gone
through a number of posts to the lists and read Paul's MySQL book. I've
tried a lot of things over the course of the past three hours and am hoping
that someone can shed some light on this one.
When I do the load data
Hi list!
I have a problem when trying to read data into tables with LOAD DATA LOCAL
INFILE.
I get this error:
ERROR 2013: Lost connection to MySQL server during query
When looking at the MySQL site it says that I should increase the
max_allowed_packet=# option (default 1M). However, my file
At 23:34 -0500 4/20/02, Darren Vollmer wrote:
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client
Darren,
Friday, April 19, 2002, 3:33:50 PM, you wrote:
DV I am having problems with load data local infile.
DV The mysql host server is running 3.23.23
DV I was able to successfully use load data local infile before to import data
DV off of a client machine onto the mysql host but now all i
The file does exist. The file and its directory are 0777 permission.
Darren
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 4:32 AM
Subject: Re: problem with load data local infile
Darren,
Friday, April 19, 2002
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should have permissions to go through dirs ...
DV Darren
--
For
Darren,
Saturday, April 20, 2002, 2:34:06 PM, you wrote:
DV The file is in a world readable directory tree.
DV Shouldn't the LOCAL qualifier make mysql read the file from the client
DV running and not the host?
DV I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
DV
1 - 100 of 129 matches
Mail list logo