MySQL Forums
Forum List  »  Knowledge Base

import images into blob
Posted by: Peter M.
Date: November 07, 2009 07:03AM

Hello everybody,

first of all I do not want to discuss the pros and cons of the two approaches to store images (Either on filesystem or in the database)

Until now i store my images on the filesystem and only have the path to the image stored in the Database.

For some reasons i decided to give the other approach a try and directly store images in the database in a BLOB.

However, i already have images stored on my filesystem which should not get lost.

So, i'm looking for a method to convert the storing of images from approach A to approach B. e.g. filling my new BLOB column automaticly with the images, which are stored on the filesystem.

It would be realy great if this would be possible with an SQL-Script. Any ideas?

Thanks in advance

Options: ReplyQuote

Written By
import images into blob
November 07, 2009 07:03AM
November 20, 2009 06:21AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.