writing a image file from a blob

[gibby7]

Back in the day I made the mistake of allowing images to be written to the database in the form of a mediumblob. Does anybody know of a way to get php to write the blob data to a live jpg or gif file directly to a web folder? The table has grown to the size of 10MB and sooner or later it is going to start smashing server speed. I would like to patch this before the phone starts ringing.

Thanks

~G

[MarkR]

Writing images into a blob seems like a reasonable decision to me; saving them all out to a file should be straightforward enough- if you know how to get the binary data out, you can save them to files.

Just write a simple script to do it and run from the CLI.

Mark

[gibby7]

Ok. I got that part but can somebody tell me where to start looking for how to write out a file from a database?