d-shade Posted September 15, 2006 Share Posted September 15, 2006 Hello Ive been using a modified photo gallery script that saves images into the mysql database. I didn't have too much of an issue at first but now that database is starting to get pretty big and thought maybe I would start running into problem.So im wondering if there is a way i can make some sort of automated script to go through all the table and dump all the images into folders and also create a new table. with all the info put into it.these are the feilds im using in my tableId, Views, Bytes, Format, Caption, Comment, ShotAt, PublishedAt, Width, Height, Image, Thumbnailthe biggest problem im having right now is trying to get the images saved onto the server.the Image and Thumbnails are both blob feilds and both contain image data. Quote Link to comment Share on other sites More sharing options...
michaellunsford Posted September 16, 2006 Share Posted September 16, 2006 [code=php:0]$result=mysql_query("SELECT * FROM `table`");while($myrow=mysql_fetch_assoc($result)) { $im=imagecreatefromstring($myrow['Image']); imagejpeg($im,$myrow['Id'].".jpg",80);}[/code]will save all the images to the scripts current directory. after you're satisfied that all the images have been successfully extracted, you can use phpmyadmin to drop the image field across the entire database. Quote Link to comment Share on other sites More sharing options...
d-shade Posted September 18, 2006 Author Share Posted September 18, 2006 alright thanks.Ill try it outUpdate:It worked out great! Finally got all the images off the mysql database. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.