I'm moving my site to a professional host now, but going through the photo albums I've got some rather large pictures. Does anyone know a way to resize the photos and have the database updated correctly? I've done a few manually, resizing and editing the database for the dimensions and filesize. But there are many more photos, in fact I may remove the full size images all together.

Help!

Bump!

There must be a hack to refresh the database with the images it finds.

For example. I've got a 1280x1024 image in the database. It'd be great to be able to resize this rather that remove it and upload it again at the smaller size.

I had a look at my database on this and it would appear that the database only contains data about the image, and not the image itself.

It should therefore not be too difficult for a PHP script to be written that read each file in a directory, gets the image dimensions and filesize attributes and writes that to the database. It is certainly within the realms of doable.

The trickiest part would be matching the file with the right one in the database, but if the filenames are unchanged then this would not be too hard.