That's the output of the stat command:
  File: `/var/www/apache2-default/filas/admin/upload/rankeo_pos.csv'
  Size: 2909            Blocks: 8          IO Block: 4096   archivo regular
Device: 802h/2050d      Inode: 672206      Links: 1
Access: (0666/-rw-rw-rw-)  Uid: (   33/www-data)   Gid: (   33/www-data)
Access: 2008-01-07 23:43:21.000000000 -0600
Modify: 2008-01-07 23:43:21.000000000 -0600
Change: 2008-01-07 23:43:21.000000000 -0600

as you can see the file is rw for everybody and all the path has access
rights. Let me explain again, perhaps my english isn't good enough: I create
a mysql root user with the following command:
*mysqladmin* -u *root password* "my_passwd"    and if I connect with this
user like:
$db = mysqli_connect("localhost", "root", "my_passwd");
mysqli_select_db($db, 'filasPOS');

I can use the load data statement without errors. But when I tried to
connect with the user filasPOS (you can see the grant statement that I use
with this user at my first post, and Moon's Father by the way, the output of
the grant statement was: Query Ok, 0 rows affected) like this:
$db = mysqli_connect("localhost", "filasPOS", "mypasswd");
mysqli_select_db($db, 'filasPOS');

and try to use the load data statement I got the error. I think this really
is a mysql problem and no an OS file permision problem, because mysql always
use the user mysqld is running to access the file specified by load data,
and the user you use to connect to mysql has nothing to do in that, am I
right? So, why this work properly with the root user but not with the
filasPOS user? Thanx for the help

2008/1/7, Chris <[EMAIL PROTECTED]>:
>
> Mauricio Tellez wrote:
> > Hi, I'm developing a PHP/MySQL app, and I use "load data infile" to feed
> > data to MySQL. At the develop server I haven't any error, the app works
> > great, but when I upload to the production server, all the "load data
> > infile" statements fails with an error like this: can't stat
> > path/to/my_cvs_file
>
> That's usually a file permission problem rather than a mysql one.
>
> If you have root access to the server, su to the mysql user and try:
>
> stat path/to/my_file
>
> does that work or give the same error?
>
>


-- 
Mauricio Tellez

Reply via email to