Montag, 28. Juli 2008

LOAD DATA INFILE

In case you get such an error

Can't get stat of '/dir/file' (Errcode: 13)
SQLState: HY000
ErrorCode: 13

from the SQL command

LOAD DATA INFILR '/dir/file/'

The reason might be quite simple: try "local" keyword, namely

LOAD DATA LOCAL INFILE '/dir/file/'


It causes mysqlto read data files from the client host.