Replicating tables from one website database on another

3 posts by 2 authors in: Forums > CMS Builder
Last Post: November 11, 2015   (RSS)

By terryally - November 10, 2015

Hi,

I am running three websites with the identical database structure for three different (but related) businesses.

I've just restructed site #1 and now I want to replicate that across the other two. I tried to do that by:

  • In Admin > General > Backup & Restore, I backup the new tables individually from site #1
  • I run a test import (Restore) one table on site #2 through Admin > General > Backup & Restore
  • Nothing appears in the Section Editor listing, so I try to create the table but error message says that table already exists in the database
  • I go to MySQL and I see it there. I run an SQL query to drop the table and re-create it. It appears as a table in MySQL but not in CMSB

With that not working, I then FTP up the schema from site#1 to site#2 and it finally appears in the listing.

Is there a faster, more efficient method to achieve this?

Thanks

Terry

By Damon - November 10, 2015

Hi Terry,

Here are the steps I take to import data from one CMS Builder to another:

1. From the current CMS Builder, run the Database Backup in CMS Builder (Admin > General Settings - Backup & Restore). Choose either "all database tables" or just select just the ones you want, one at a time.

2. From current CMS Builder, download via FTP the database backup file and schema files (Section Editors) /data/schema/ and uploads.

3. To the new CMS Builder, upload via FTP database backup, schema files and uploads.

4. Login to new CMS Builder installation and click on Admin > Section Editors which will trigger CMS Builder to create database tables based on the schemas (Section Editors) if the don't already exist.

5. Under Admin > General Settings, go to Database Restore, choose the database backup file previously uploaded and click the Restore button.

The is the fastest way that I use to copy data/uploads from one CMS Builder installation to another.

Hope this helps.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/