MySQL: "LOAD DATA INFILE" says "file not found"

Posted . Visible to the public.

This might be due to AppArmor denying the MySQL server access to most of the filesystem. You can instead use
LOAD DATA LOCAL INFILE ...
to pipe data through the MySQL client, which can read everything the executing user can.

Tobias Kraze
Keywords
csv, import, database
License
Source code in this card is licensed under the MIT License.
Posted by Tobias Kraze to makandra dev (2011-02-01 15:39)