Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: copying database tables  (Read 2904 times)

0 Members and 1 Guest are viewing this topic.

Deus

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 153
    • DJ-Daz
copying database tables
« 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
Logged
https://daz-stuff.uk
DJ tutorials, E-Bikes, Movies and videogames.
(https://daz-stuff.uk/daz/signature.png)

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: copying database tables
« Reply #1 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
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.

Deus

  • Contributor
  • Coppermine frequent poster
  • ***
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 153
    • DJ-Daz
Re: copying database tables
« Reply #2 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?
Logged
https://daz-stuff.uk
DJ tutorials, E-Bikes, Movies and videogames.
(https://daz-stuff.uk/daz/signature.png)

artistsinhawaii

  • VIP
  • Coppermine addict
  • ***
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 856
    • evj art and photography
Re: copying database tables
« Reply #3 on: October 06, 2005, 01:50:31 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
Logged
Learn and live ... In January of 2011, after a botched stent attempt, the doctors told me I needed a multiple bypass surgery or I could die.  I told them I needed new doctors.
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 17 queries.