Hi,
did some searching and couldn't find anything that really helped me with this . . .
I have been using Coppermine for almost 2 years and I now have over 500 images uploaded. When I first started using Coppermine I didn't really think about the long term consequesces of my folder structure, I now realise I need something more logical. My Hosting provider gives me an SQL Administration tool as part of their Control Panel that I can use to view and change fields in the various tables. What I would like to do is re-organise my images into logical folders and sub-folders, etc. and fix some of my early errors, like uploading images to the userpics folder ::)
What I need to know is what I need to change in the database ? Would it simply be the filepath entry in the CPG_pictures table for the images I wanted to move ? I am happy to do all this manually 1 file at a time during which I would take the album off-line.
thanks in advance ;D
Quote from: RaptorUK on May 24, 2005, 06:46:15 PM
What I would like to do is re-organise my images into logical folders and sub-folders, etc. and fix some of my early errors, like uploading images to the userpics folder ::)
not recommended. Leave as-is.
Quote from: RaptorUK on May 24, 2005, 06:46:15 PMWould it simply be the filepath entry in the CPG_pictures table for the images I wanted to move ?
yes
Quote from: RaptorUK on May 24, 2005, 06:46:15 PMI am happy to do all this manually 1 file at a time during which I would take the album off-line.
You can do several files in only 2 steps:
- move the files in one folder (e.g. albums/userpics/foo/bar/*.*) to another folder (e.g. albums/foo/whatever/)
- in your db control panel, run a query like
UPDATE `yourCopperminePrefix_pictures` SET `filepath` = 'foo/whatever/' WHERE `filepath` = 'userpics/foo/bar/';
Warning: backup both your complete file structure and your database before doing all this.