forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: mbalire on November 10, 2010, 11:15:00 am

Title: transfer my old gallery to a new gallery
Post by: mbalire on November 10, 2010, 11:15:00 am
i could like to transfer my old gallery to a new gallery but make the old gallery  a category for example i have bigbrother season 4 as a new gallery but i want to to combine my old gallery of bigbrother season 3 as a category in the this new gallery of season 4 and also to maintain the views nos and the comments of the old gallery in season 3.

am struck i don't know how to achieve that so please help me.

url:www.bigbrotherafrica.com/gallery    new gallery

www.bigbrotherafrica.com/new    old gallery
Title: Re: transfer my old gallery to a new gallery
Post by: Αndré on November 10, 2010, 11:21:48 am
Seems that both galleries are already up and running? If so, you'll have to know your way around in MySQL to manipulate the database accordingly. That may be an easy task but may be tricky, depending on the complexity of both galleries.
Title: Re: transfer my old gallery to a new gallery
Post by: mbalire on November 10, 2010, 11:23:51 am
thanks for that but which tables so i combine sothat it works?
Title: Re: transfer my old gallery to a new gallery
Post by: Αndré on November 10, 2010, 11:32:45 am
You need at least the pictures table. Depending on how much albums you have, you can think of creating them new in your 'main' gallery, or import the albums table. The same applies for the category table. If you have comments, you'll have to import the category table, too. If you have detailed vote and hit stats, .... . You have to learn how the Coppermine database works. And you always have to verify that all IDs are unique. So when you import tables, you have to check if the IDs are not already taken. If so, you'll have to assign new IDs and adjust all relating IDs in other tables.
Title: Re: transfer my old gallery to a new gallery
Post by: mbalire on November 10, 2010, 11:55:55 am
thats so much with that knowledge let me try to import the tables and i will communicate with you if anything happens.
Title: Re: transfer my old gallery to a new gallery
Post by: Αndré on November 10, 2010, 12:04:26 pm
I'll promise you it won't work.

I just recognized that your old gallery is cpg1.4.27 and your new gallery don't has the version information. I alert you to blindly import anything!