https://interactivetools.com/forum/forum-posts.php?Copying-and-dupicating-a-CMSB-database-72480 Wed, 07 Oct 2026 09:37:54 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2211128#post2211128
Jerry
]]> Tue, 03 May 2011 09:28:39 -0700 forum-posts.php?postNum=2211128#post2211128 https://interactivetools.com/forum/forum-posts.php?postNum=2211126#post2211126
Yes, thank you and it was completely successful.[:)] Thanks to you and your very detailed guide. The assistance recieved on this forum from the staff at IT and good folks like you are invaluable.



Kurt
]]> Tue, 03 May 2011 09:04:06 -0700 forum-posts.php?postNum=2211126#post2211126 https://interactivetools.com/forum/forum-posts.php?postNum=2211116#post2211116
Did you ever accomplish your goal?

Best,

Jerry Kornbluth
]]> Mon, 02 May 2011 21:47:46 -0700 forum-posts.php?postNum=2211116#post2211116 https://interactivetools.com/forum/forum-posts.php?postNum=2210950#post2210950
I couldn't agree more.

Backing up is imperative. Especially before any updates, upgrades, or other mucking about with their data/

I even offer my clients a "Peace of Mind" backup service for all their web based files via FTP, using the "backup jobs" settings in WS-FTP Pro.

I back up all their files once a month for a subscription fee.

So far it's a win-win situation.

Jerry Kornbluth
]]> Fri, 22 Apr 2011 21:09:22 -0700 forum-posts.php?postNum=2210950#post2210950 https://interactivetools.com/forum/forum-posts.php?postNum=2210948#post2210948
The other day I wanted to duplicate a site, but re-skin it for a new client. I simply did my "process" but didn't change some settings. On the new host, I deleted all the first client content ready for the new client content and the new site was still referring to the old database... I deleted all my original clients content on their live site.

Luckily I had backed up a few days earlier and only lost a bit, and the client was fine.

I then purchased thed auto back-up plugin and installed it on all sites!
]]> Fri, 22 Apr 2011 17:19:42 -0700 forum-posts.php?postNum=2210948#post2210948 https://interactivetools.com/forum/forum-posts.php?postNum=2210870#post2210870
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
]]> Wed, 20 Apr 2011 12:39:05 -0700 forum-posts.php?postNum=2210870#post2210870 https://interactivetools.com/forum/forum-posts.php?postNum=2210862#post2210862
You can backup your whole database from the General Settings page in CMS Builder. That will create a backup file in your CMS Builder backup folder. Usually: /cmsAdmin/data/backups

Then move the backup file to the new CMS Builder backup folder on the new server. Once the file is copied over you can use the restore festure in General Settings to recover the data.

Hope that helps,
Robin
]]> Wed, 20 Apr 2011 11:42:47 -0700 forum-posts.php?postNum=2210862#post2210862 https://interactivetools.com/forum/forum-posts.php?postNum=2210847#post2210847

Is this something that can be done, and if so, can a SQL dummy handle the task, or do I need to get this done by the con$ulting team?



Kurt
]]> Tue, 19 Apr 2011 16:41:57 -0700 forum-posts.php?postNum=2210847#post2210847