Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

newbie: loading image into MySQL table

 
   Database Help (Home) -> mySQL RSS
Next:  Oracle University Oracle 11i / R12 HRMS Training  
Author Message
Jivanmukta

External


Since: Oct 14, 2008
Posts: 15



(Msg. 1) Posted: Thu Oct 01, 2009 3:44 am
Post subject: newbie: loading image into MySQL table
Archived from groups: comp>databases>mysql (more info?)

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.

 >> Stay informed about: newbie: loading image into MySQL table 
Back to top
Login to vote
Captain Paralytic

External


Since: Jan 14, 2008
Posts: 245



(Msg. 2) Posted: Thu Oct 01, 2009 4:08 am
Post subject: Re: newbie: loading image into MySQL table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On 1 Oct, 11:44, 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 IMO the best method, although there are others.

The very first hit in the Google search:
store images mysql
gives anotherone.

 >> Stay informed about: newbie: loading image into MySQL table 
Back to top
Login to vote
The Natural Philosopher

External


Since: Oct 01, 2009
Posts: 27



(Msg. 3) Posted: Thu Oct 01, 2009 7:25 am
Post subject: Re: newbie: loading image into MySQL table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
toby

External


Since: Aug 21, 2008
Posts: 6



(Msg. 4) Posted: Thu Oct 01, 2009 8:22 am
Post subject: Re: newbie: loading image into MySQL table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Java mysql show table status - Hi, I am using java to retrieve a resultset with "show table status" mysql command. I am having problem reading the [name] and [engine] column. In the metadata object it is showing as VARCHAR but when I do getString() it is returning me the o...

newbie needs help - worthless site

[newbie] Schema Relation in SQL - I want to create search engine in MYSQL & this is my scheme relationship https://lh4.googleusercontent.com/_VoNFL4VpX6g/Tc3cfFtC20I/AAAAAAAAACI/xNJzQLjGO-w/umkm%20skema.png whether the scheme of relationships that I make it right? correction please

Tuning Mysql 4.1.10 - I have a freebsd box with 1 gig of memory for mysql/php, I was wondering what my my.cnf should look like, I am doing alot of searches and writes on ISAM tables, I currently have the following: [client] port=3306 socket=/tmp/mysql.sock [mysqld]..

Mysql InnoDB PHP - i have a strange problem : MySQL 4.0.21 innodb and php 4.3.9-1 all tables are in innodb type. For a simple select statement, sometimes i get result and sometimes nothing (i.e mysql_num_rows()>0 or mysql_num_rows()==0). It's a random behaviour. If my....
   Database Help (Home) -> mySQL All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]