To save the image in mysql

gaurav_g11

I want to get the information about the
following question.

How to save the image in mysql?

gaurav_g11

To save the image in mysql?

Anon

to save image in mysql data base
select the field type=Bloab
then insert the image

Anon

That should be blob shouldn't it? Besides, why store it in a db? Why not just store a 'location' in the database? So, when you need to get a particular image, the db spits out something like "www.images.com/images/image0022.jpg" and browser sets out to retrieve it.

If there is an advantage to actually storing the image itself in the db, what is it?

For what it's worth....

Later on,
Morpheus() (Terrence)

thewitt

One of the advantages of storing image data in a database is that backups of the database are all-inclusive. You don't need to have a backup of the file system that is coincidental at a point in time with the database backup in order to restore the data.

I have an application where the images are generated in a factory from an inline inspection tool. These images need to be kept in context with the history records from the lots in progress. If I were to store the images outside the database, then data integrity would be suspect.

As it stands now, I can restore a database backup from 5 years ago, and I know that I have the lot history data, all measurement data, and the supporting images that went with the inspections, all in one place, all in one convenient restored database.

Trying to do this with multiple backups of both database files and RMS files always results in something being missing.

-t

Anon

FANTASTIC!

This is one of those times when I don't mind being schooled. The needs that I've had as of late are so different that my vision suffered, so to speak.

In the application that I'm developing now, as well as the one previous, the images are actually stored in a location povided by the user. Something akin to ebay. Going further, the chances are that a person selling an item prolly wouldn't change the location of his image even though I were to restore a db at 3 AM. He would prolly never know.

Anyways, once again, I stand corrected and thanx for showing a perspective that I lacked experience to consider.

Morpheus()