Creating a logical folder structure . . . after 500 images have been uploaded.

[RaptorUK]

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   

[Joachim Müller]

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.

Would it simply be the  filepath  entry in the  CPG_pictures  table for the images I wanted to move ?

yes

I 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
  Code Select Expand
  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.