Re: Store pictures in DB (load_file() revisited)

2002-10-01 Thread gerald_clark
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

Store pictures in DB (load_file() revisited)

2002-10-01 Thread Alex Safonov
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') | +---+ |