Re: Odd behavior of 'load data'

2008-01-07 Thread Mauricio Tellez
sage- > From: joe [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 08, 2008 12:01 AM > To: 'Mauricio Tellez' > Subject: RE: Odd behavior of 'load data' > > You may need to use LOAD DATA LOCAL INFILE. > > > -Original Message- > From: Ma

Re: Odd behavior of 'load data'

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

Re: Odd behavior of 'load data'

2008-01-07 Thread Moon's Father
You should paste the result of command show grants for 'filasPOS'@'localhost',not the message pasted here. On Jan 8, 2008 12:04 PM, Mauricio Tellez <[EMAIL PROTECTED]> 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 hav

Re: Odd behavior of 'load data'

2008-01-07 Thread Chris
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 sta

Odd behavior of 'load data'

2008-01-07 Thread Mauricio Tellez
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 The