coppermine-gallery.com/forum

Support => Older/other versions => cpg1.3.x Support => Topic started by: Deus on October 06, 2005, 12:43:14 AM

Title: copying database tables
Post by: Deus on October 06, 2005, 12:43:14 AM
I am in the process of setting up another site just for the psp browser.
only trouble is, i dont want to go through the whole process of copying files, and batch adding 20,000+ images.

So my question is, can i copy the relevant database tables to the new subdomain?
the original path is ripoffbritain.org/wallpaper/albums
the new path is psp.ripoffbritain.org/albums

does anyone know if this is possible and what problems it might cause?

TIA
Deus
Title: Re: copying database tables
Post by: artistsinhawaii on October 06, 2005, 12:54:52 AM
If you are on the same domain and don't mind sharing the database. Just change the paths in your new copy's  Config settings... : Target address for the 'See more pictures' link in e-cards .

Just remember that file additions/deletions in one will affect the other.

Dennis
Title: Re: copying database tables
Post by: Deus on October 06, 2005, 01:10:48 AM
never thought of that, nice one... but just had another idea, this one is much more complex...

how about a detection system that dynamically changes the config... ie, detects what browser your using and resizes images (this would have to be pre done) changes the layout etc...

or maybe a detection to redirection would be easier?
Title: Re: copying database tables
Post by: artistsinhawaii on October 06, 2005, 01:50:31 AM
Quote from: Deus on October 06, 2005, 01:10:48 AM
never thought of that, nice one... but just had another idea, this one is much more complex...

how about a detection system that dynamically changes the config... ie, detects what browser your using and resizes images (this would have to be pre done) changes the layout etc...

or maybe a detection to redirection would be easier?

For the most part all you will have to do is either copy the new thumbs_imagefile.jpg, normal_imagefile.jpg, and imagefile.jpg from one to the other. Or delete from the other if you deleted it from one.   The paths would already be  inserted in or deleted from the database, respectively.

Course if you have users creating albums and uploading, deleting like crazy... this would be a headache.  ;)

Dennis