Getting an image out of mysql

consiglieri

Joined: 2009-09-12
Posts: 6
Posted: Sat, 2009-09-12 20:48

Hi

I was taking a look at the mysql tables generated by Gallery, and began to wonder - excatly which table holds the actual image? I mean if I wanted to extract the image - say if my oroginal was lost - how would I get my image out of mysql?

Thanks
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Sat, 2009-09-12 23:02

None of them do. There is no binary data stored in the database. The images are stored in your g2data directory.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
consiglieri

Joined: 2009-09-12
Posts: 6
Posted: Sun, 2009-09-13 07:12

Thank you for reminding me what an idiot i am. I should ofcourse have known that since I installed the gallery, even if it is a while since I did.
Still, thanks for setting me straight!
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16503
Posted: Sun, 2009-09-13 16:37

You're not an idiot. I live and breath Gallery so it's totally understandable that someone who doesn't will forget how it's setup :)

Don't ask me questions about G1 as I've forgotten most of what I knew about it. It would probably take me 10-20 minutes to figure out how to change colors of something :)
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here