Copying Blob Data fro Mysql table to External file (1 Viewer)

somashekhark

Registered User.
Local time
Today, 17:49
Joined
Dec 22, 2006
Messages
17
We have saved image in the Mysql database as blob. We want to save these pictures as external file in Jpeg format. Please help us to solve this problem.

Thanks in advance
 

rich2600

Total access newb.
Local time
Today, 05:19
Joined
Mar 12, 2007
Messages
10
We have saved image in the Mysql database as blob. We want to save these pictures as external file in Jpeg format. Please help us to solve this problem.

Thanks in advance

If you don't have any preset connection collations ex(utf8_unicode_ci) that preset and stripped all randomized characters from the blob data, it should be simple as extracting the data inside the rows and copy and paste them into a Notepad, and saving the file, and changing the file-extension to .JPEG. It is said many places that storing images this way is risky and very easily corrupted. So it may not work.
 

Users who are viewing this thread

Top Bottom