Copying and dupicating a CMSB database

Hi Kurt,

Hi I agree with Robin, but that's only a part of the goal that I think that you are trying to accomplish.

Depending on the complexity of your site, this can be a relatively quick process or can take some time. The "Devil" will definitely be in the "details".

Others may have a different, and even easier approach, but here's mine.

First, you'll need to be using the same version of CMS Builder for both domains in order for this to work, so upgrade each install to the latest version before you begin. (remember to back up the database and other CMS files before you upgrade)

Also, you'll need all of the 3rd party programs, CSS files, javascript files, and any other that made the old site work installed on the new site before you proceed. Don't forget to adjust any required information to reflect your new site.

Then:

1) copy all of the .ini.php files from the cmsAdmin/data>schema folder of the old site into the cmsAdmin/data>presets folder of the new site. (these store the complete structure of the old section editors and act as templates for the new site's section editors)

2) create all the section editors in the new site using the choices in the "select preset" list (these are taken from the presets you just copied, so they will have the parameters of the old site editors)

3) Backup the database from the old site using admin>general>database settings>database backup and thencopy the backup .sql.php file from the old cmsAdmin/data/backups folder to the new site in the same directory

4) Restore the copied database to the new site

5) Copy all the images and uploads from your old site's uploads and thumbs sub folders to the new site in the same locations. If you've created special upload locations, copy those over as well.

6) Copy all the web pages from your old to your new site and, using the code generator in your b=new site admin area, adjust the path to the load viewer library file to reflect your new site's path. While you're there, make sure that any absolute link references reference the new site as well.

7) With the possible exception of being able to see images and other uploads on the new site that should do the job

CAN'T SEE IMAGES AND UPLOADS
If the images and uploads don't appear, and there are not many, Id suggest re-uploading the images and uploads to the appropriate records.

If there are a lot of them, read on:

ACCESSING THE IMAGES AND UPLOADS
All upload information is stored in a separate MySQL table called uploads. This table includes path information to the images on your site.

If the path structure is not identical, the images and uploads won't be found and they won't appear on your new site.

UPDATING THE NEW TABLE
First, upload one new image to your new site. This will insert a new record in the uploads table with all the path information for your new site

Then, backup just that table from the new site and adjust the path information to match that new upload's information so your images and uploads will appear on the new site.

This should be pretty easy to do using something like Navicat for MySQL http://mysql.navicat.com/. but if not, there's a step by step description in a recipe in my CMSB Cookbook http://thecmsbcookbook.com that should help called "BATCH UPLOADING OF IMAGES"

Hope that helps get you on your way.

Jerry Kornbluth