mysql probably does not have search permission on /home/alex.
copy the file to /tmp and see what happens.
Alex Safonov wrote:
>Greetings,
>
>just saw a message with an example of inserting a BLOB
>value using load_file(). Can't get load_file() to
>work:
>
>mysql> select load_file('/home/alex/pos
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql> select load_file('/home/alex/post.html') from
test;
+---+
| load_file('/home/alex/post.html') |
+---+
|