MySQL Forums
Forum List  »  Newbie

Extracting .jpg files from a database
Posted by: Don Johnson
Date: November 19, 2009 02:13PM

I have run an online forums system for years and have a pretty good understanding of how the mysql database works and how to do simple things in MyphpAdmin from the server's control panel.

I need to extract a large number or images, mostly .jpg files from a table called 'attachments'. I want to move them to a folder or other location on the server and end up with the original filenames, such as "butterfly.jpg", or "locomotive.jpg".

Currently, when the images display on an html page, right-clicking reveals a cryptic name consisting of a date and a long numerical designation.

Any help would be greatly appreciated. Please keep your answer simple!

Options: ReplyQuote


Subject
Written By
Posted
Extracting .jpg files from a database
November 19, 2009 02:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.