Page 1 of 1

How to copy page tree-structure - SOLVED

Posted: Wed Apr 23, 2008 7:18 am
by enriqe
Hi folks.

I have a site (running 1.1.4.1.) and now I need to migrate it to another place.
I already installed clean newest version (1.2.4.) on a new place.

And now I need to copy whole page structure.
How to avoid recreating pages one-by-one ?


Appreciate your help !
Thanks !

Re: How to copy page tree-structure

Posted: Wed Apr 23, 2008 8:24 am
by enriqe
I got it !  ;D
My site is now up and running. Yes !

Here is how I did it :

  • - I installed new CMSMS and deleted all content (except one starting page which can't be deleted)
  • - now create STYLESHEETS and TEMPLATES (I did this manualy but I think you could just import your old data into DB - you need to know which tables to import)
  • - then I entered DB tool PhpMyAdmin and changed IDs of Templates (in table _TEMPLATES) so they are the same like my original IDs (don't forget to change also record in table _TEMPLATE_SEQ so it contains the highest ID of template)
  • - now I exported DB data from my old site - but only from tables _CONTENT* (there are 4 tables)
  • - Final step is to import (through SQL plain text file) those 4 tables into your new DB. And that's it.
  • - (of course I needed to upload all images and files through FTP to the same directories)
PLEASE KEEP IN MIND, that this was migration from CMSMS 1.1.4.1. to CMSMS 1.2.4. - in other versions in doesn't have to work.

Thank you guys for such open system - easy to deal with !!!
:-*  :-*  :-*

E.

Re: How to copy page tree-structure - SOLVED

Posted: Wed Apr 23, 2008 8:31 am
by RonnyK
If you first upgraded the other site as well, you could have done a DB-backup nd DB-restore without having to do any hard work.....

There are both DB-tools and File-tools available, another option would have been SitePusher, which would have moved the original site to the new live environment....

Ronny