Replicating tables from one website database on another
3 posts by 2 authors in: Forums > CMS Builder
Last Post: November 11, 2015 (RSS)
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.
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Hi Damon,
Thanks very much. This worked perfectly with one little itsy bitsy tweak i.e. a change to the name of the customUploadDir in a couple of the schema files where I had used a custom upload directory.
Thanks again.
Terry