- 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 make up error messages, report them
exactly.
Can't get stat of 'filename' (Errcode 2)
Filename being the fully qualified path of whatever file I am trying to
infile.
I tried local infiling the following two files
/usr/bin/znew (exists on both machines)
/usr/games/worms (exists only on client machine)
What are the modes on both files?
Both files are world readable.
Even though I specified local on the infile
statement, mysql successfully imported
/usr/bin/znew into the specified table.
/usr/games/worms was returned the same
can't stat file (errcode 2) message.
Then its mode is probably different. Perhaps execute-only.
Modes are the same.
It looks like the LOCAL argument is being
ignored all together.
Mmm ... doubt it.
Why is the load data local infile statement successfully importing files
that reside
on the mysql host but not the mysql client machine? With local specified,
the host
shouldn't even be looking for files located on it should it?
Is it posible that my host is 3.23.23-beta, and
that my client is a newer version of mysql and
that the client has local disabled? Whats the
quickest way to find the version of my client? I only
have access to mysql through perl/php
Invoke the mysql_get_client_info() function. It'll tell you
the version of the client library.
I only have access to the database via perl or php. How do I call
the C API function mysql_get_client_info() from perl?
It's entirely possible, likely even, that the client library has been
updated. But based on your /usr/bin/znew, /usr/bin/games experience,
that seems unlikely.
Is there a way to find out what startup options
were specified for Mysql through perl dbi or
php access?
Not that I know of.
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Darren Vollmer [EMAIL PROTECTED]; [EMAIL PROTECTED];
Victoria
Reznichenko [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 5:12 PM
Subject: Re: Re: problem with load data local infile
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 that is in the databases directory on the Mysql host. The
server
found the file even though I specified local. Don't know if that
means
anything or not, or if that is normal mysql behavior.
exp;
load data local infile 'table.frm' replace into table testtable
Shouldn't mysql be looking for table.frm on my client machine and
not
the
server?
LOCAL requires only that you be able to read the file.
With the LOCAL keyword, the program on the client machine reads the
file
and sends it to the server to be inserted into the table. The MySQL
server
takes those records, and it's what accesses the table.frm file.
How could the client access table.frm? That file isn't even on the
client
host necessarily.
Something that might account for the difficulty, if you've upgraded
MySQL
recently:
A change was made in MySQL 3.23.49 that causes LOCAL to be disabled
(by
default?). You may be able to re-enable it by invoking mysql with
the
--local-infile option. Try mysql --help to see if that option is
listed
in the help message.
By the way, what was the error message you got?
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 6:14 AM
Subject: Re: Re: problem with load data local infile
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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check: