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