newbie: loading image into MySQL table

Jivanmukta wrote:
> Hello,
> How can I load image to MySQL table? I need a solution for Windows and
> Linux. I tried LOAD_FILE() but it returns me NULL.
> Thanks in advance.

Load file is the way to go BUT you need special user privileges to do it

It works fine for me, but I had to add some stuff to the loading users
privileges to allow it to.

Sadly, I cannot remember exactly what it was.
 >> Stay informed about: newbie: loading image into MySQL table 

On Oct 1, 6:44 am, Jivanmukta wrote:
> Hello,
> How can I load image to MySQL table? I need a solution for Windows and
> Linux. I tried LOAD_FILE() but it returns me NULL.
> Thanks in advance.

Here's a script that uses INSERT.
http://www.telegraphics.com.au/svn/blobstore/trunk/blobstore.sh

It's for bash, but I am sure it's going to be even simpler in Windows'
very powerful CLI scripting shells.
 >> Stay informed about: newbie: loading image into MySQL table