Write file from BLOB mysql python

Question

I'm trying to get a file from a database and write it to disk. The file is stored as BLOB.

Now I have the following code:

#!/usr/bin/python
import MySQLdb

db2 = MySQLdb.connect(host="localhost",
                      user="root",
                      passwd="root",
                      db="digit")

cur = db2.cursor()
#get the name of the file
cur.execute("SELECT Name FROM ContentFiles WHERE ID=3")
nombre = cur.fetchone()
#open file and write into.
with open(nombre[0],"wb") as output_file:
    cur.execute("SELECT File FROM ContentFiles WHERE ID=3")
    ablob = cur.fetchone()
    output_file.write(ablob[0])

Any help would be appreciated. Thanks :)

I debugged and it gets the file and write it into disk, but when I open it shows an error saying:

Not a JPEG file: starts with 0x2f 0x39

blfuentes · Accepted Answer · 2012-09-10 07:51:00Z

5

I found the solution, I needed to use the decode('base64') ... it was an easy problem :/

cur = db2.cursor()
#get the file
cur.execute("SELECT mimetype,File,Name FROM ContentFiles WHERE ContentID=10414")
archivo = cur.fetchone()

imagen = open(archivo[2],'wb')
imagen.write(archivo[1].decode('base64'))
imagen.close()

answered Sep 10, 2012 at 7:51

blfuentes

2,8275 gold badges47 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Write file from BLOB mysql python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related