At 6:34 -0500 4/20/02, Darren Vollmer wrote:
The file is in a world readable directory tree.
Shouldn't the LOCAL qualifier make mysql read the file from the client
running and not the host?
I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
FRM file
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 6:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
I noticed what you mentioned about
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
It can't stat *filename*? Don't
error message
then
can't get stat of 'filename' (Errcode 2)?
Thanks for your help and patience
Darren
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:36 PM
Subject: Fw: Re: problem with load data local infile
- Original
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 machine is the machine running the webserver and MySQL
I am having problems with load data local infile.
The mysql host server is running 3.23.23
I was able to successfully use load data local infile before to import data
off of a client machine onto the mysql host but now all i get is a
can't stat file errcode2 message.
I know that the pathname I
I never saw this message make this list so I'm reposting it.
- Original Message -
From: Darren Vollmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 7:33 AM
Subject: problem with load data local infile
I am having problems with load data local infile
| NULL |
Thomas | Fluffy | Harold | cat | f| 1993-02-04 | NULL |
Thomas +--++-+--++---+
Thomas 2 rows in set (0.03 sec)
mysql load data local infile /home/tomb01/data/pet.txt into table pet;
Thomas ERROR 1148: The used command is not allowed
Thomas Birchmire writes:
I have the same problem using Linux RedHat 7.2. Just what do I have to
configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on
i686?
The rest of MySQL works as advertised.
Regards Tom Birchmire
loca-infile is not a variable.
load data local infile /home/tomb01/data/pet.txt into table pet;
ERROR 1148: The used command is not allowed with this MySQL version
mysql quit
Sinisa Milivojevic [EMAIL PROTECTED] wrote:
Thomas Birchmire writes:
I have the same problem using Linux RedHat 7.2. Just what do I have
Thomas Birchmire writes:
I tried putting --local-infile in my server script and local-infile in the
/etc/my.cnf file. I also placed a number or logging cammands in the startup
script hoping to catch lower level messages. There appears to be little
effect on anything.
Regards, Tom Birchmire
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa [EMAIL PROTECTED] writes:
Description:
LOAD DATA LOCAL INFILE ...
leads to 'The used command is not allowed with this MySQL version'
This happens regardless of whether I have a
local-infile = 1
in my /etc/my.cnf
Milivojevic [EMAIL PROTECTED] writes:
Sinisa [EMAIL PROTECTED] writes:
Description:
LOAD DATA LOCAL INFILE ...
leads to 'The used command is not allowed with this MySQL version'
This happens regardless of whether I have a
local-infile = 1
in my /etc/my.cnf. In neither
Rob Steele writes:
Thanks. I don't think this feature is working as the documentation says
it should. Section 4.2.4 of the manual says:
By default all MySQL clients and libraries are compiled with |
--enable-local-infile|, to be compatible with MySQL 3.23.48 and before.
That
Description:
LOAD DATA LOCAL INFILE ...
leads to 'The used command is not allowed with this MySQL version'
This happens regardless of whether I have a
local-infile= 1
in my /etc/my.cnf. In neither case does the local-infile variable show
up with SHOW VARIABLES.
How-To-Repeat:
Fix
: Wednesday, February 20, 2002 5:00 PM
To: MySQLMailingList
Subject: LOAD DATA LOCAL INFILE (Only loads 20,000 or 41,000 Records)
his is my first post here so please excuse any irrelevancies.
I am trying to load a .csv file that contains 41943 Records of Data.
I am only able to load 20972 Records
/tbl_mapZipCodes.csv
and contains 41943 lines that match the following comma-seperated structure:
'Pleasantville','NY','00401'
'Holtsville','NY','00501'
'Holtsville','NY','00544'
Here is my query
mysql LOAD DATA LOCAL INFILE
'/usr/local/httpd/htdocs/projects/databases/tbl_ma
- INTO TABLE
to have load data local infile or the like, set a field for
each region for each file as it is imported.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
I want to set a field for all of the records I import while importing
using load data local infile. The field is not specified in the file I
am importing. Is there a way to do it? Mysql database importing tab
delimited file
.
To: [EMAIL PROTECTED]
Subject: load data local infile
I want to set a field for all of the records I import while importing
using load data local infile. The field is not specified in the file I
am importing. Is there a way to do it? Mysql database importing tab
delimited file
. I then
issue a command like:
load data local infile Products.data into table Products;
Occasionally I will get the response:
Query ok, 29 rows affected (0.00 sec)
Records: 29 deleted: 0 Skipped: 0 warnings: 0
But the vast majority of the time I get the response:
Query ok, 0 rows affected (0.00
Hi !
If off-topic, forgive me, please.
Environment:
Win98 / mysql3.23.42-max / mm.mysql-2.0.7 / jdk1.3.1
Description:
I'm trying to load data from file to table using following query:
LOAD DATA LOCAL INFILE 'C:\\WINDOWS\\TEMP\\rec222.txt'
INTO TABLE ext_call_info_ip FIELDS TERMINATED BY '\t
Hi,
I have some text files (logs) that are tab delimited containing 3 columns.
I'm loading them into MySql using the LOAD DATA LOCAL INFILE commands, but I
want to load them into a table that has 4 fields, with the 4th field having
a value equal to the name of the file being loaded
Post a couple of lines from your data file. Does .csv insist on all
values single quoted?
On Thu, Aug 16, 2001 at 09:03:36PM -0700, Yeong CN wrote:
Hi.
This is the script I write to upload a .csv file into my online mysql database :
$sql_query=LOAD DATA LOCAL INFILE '$textfile
trying to populate a table on a server (in my case a
Sun box) with data from a delimited text file from a client machine (in my
case located in the root of the C: drive on a Win32 machine). Using the
command LOAD DATA LOCAL INFILE filename.txt INTO TABLE tablename;
results in the error: File
:
The problem arises when trying to populate a table on a server (in my case a
Sun box) with data from a delimited text file from a client machine (in my
case located in the root of the C: drive on a Win32 machine). Using the
command LOAD DATA LOCAL INFILE filename.txt INTO TABLE tablename;
results
Thanks for responding, but the full path is not the answer.
I have tried every conceivable full path (see original message) and it does
not help. In fact, the only thing that has ever worked was using no path
info and putting the file in the root of the C: drive on my local machine.
But for
I suppose that only way to reorganize unique field is to use another table.
- Original Message -
From: Irmund Thum [EMAIL PROTECTED]
To: Rus [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 13, 2001 8:53 AM
Subject: Re: mysqlimport - LOAD DATA LOCAL INFILE
Rus schrieb
Rus schrieb:
Maybe it's problem with end_of_line symbol.
You could use PHP to insert records directly into db.
- Original Message -
From: Irmund Thum [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, February 12, 2001 2:30 PM
Subject: mysqlimport - LOAD DATA LOCAL INFILE
101 - 129 of 129 matches
Mail list logo