MySQL Forums

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
Peter