+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: Mass Updates to image folders via MySQL how to? (/thread-6536.html)
Mass Updates to image folders via MySQL how to? - oldsportbiker - 2010-02-02
I'd like to move all of the contents of 40 folders to 1 folder. Rather than doing this 1 image at a time in the admin front end, I'd like to :
- Run Clear Image Cache
- FTP copy all of the images to the new folder
- MySql update the images table with the new albumid (folder) value.
Does this plan sound feasible? Has anyone else done this?
Mass Updates to image folders via MySQL how to? - kagutsuchi - 2010-02-02
Zenphoto is filesystem-based, so you should be able to simply move the images from one folder to another. Then you can refresh the database and everything should be fine.
Mass Updates to image folders via MySQL how to? - sbillard - 2010-02-02
If you have database data for the images (descriptions, etc.) that is not physically in the image metadata, then you will need to update the album ID of the image records.