[Bug 244406] [NEW] File load data infile'file-name' fails

[John Gelm]

Public bug reported:

I am migrating from 7.04 to 8.04.  The environment is Ubuntu 64bit
desktop w/LAMP added.

Here is the error in 8.04:
mysql> load data infile '/var/www/tradesim/foliofn/MA46255006_open_tax_lot.csv' into table otl_csv;
ERROR 29 (HY000): File '/var/www/tradesim/foliofn/MA46255006_open_tax_lot.csv' not found (Errcode: 13)
mysql> 

The message is a permission error, but I have 777'ed the entire /var/www
to no avail.

root at voyager:/var# ls -lh /var/|grep www
drwxrwxrwx 54 root root  4.0K 2008-06-28 13:25 www

root at voyager:/var# ls -lh /var/www|grep tradesim
drwxrwxrwx 19 gelmjw gelmjw 4.0K 2008-06-14 10:48 tradesim

root at voyager:/var# ls -lh /var/www/tradesim | grep foliofn
drwxrwxrwx  5 gelmjw gelmjw  12K 2008-06-30 14:08 foliofn

root at voyager:/var# ls -lh /var/www/tradesim/foliofn/MA46255006_open_tax_lot.csv 
-rwxrwxrwx 1 gelmjw gelmjw 14K 2008-06-30 14:08 /var/www/tradesim/foliofn/MA46255006_open_tax_lot.csv

** Affects: mysql-dfsg-5.0 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
 File load data infile'file-name' fails
https://bugs.launchpad.net/bugs/244406
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.