Search code examples
mysqlblob

How to write an image blob to a disk?

I have a table that contains image BLOB field.

I want to be able to submit a query to the database and have the BLOBs written to the Windows file system.

Is this possible?

Solution

  • Yes, it is possible. You can use SELECT command with INTO DUMPFILE clause. For example -

    SELECT
  data_column
FROM
  table1
WHERE
  id = 1
INTO DUMPFILE 'image.png';

    From the reference: If you use INTO DUMPFILE instead of INTO OUTFILE, MySQL writes only one row into the file, without any column or line termination and without performing any escape processing. This is useful if you want to store a BLOB value in a file.