Replicating the CMS Database

The following tables need to be included in the database replication process. The table prefix, such as default, equals the instance name.

From version 6.7.0

default_objs
default_blobs
default_permissions
default_news

From the default_blobs table only those entries are required in which blob_name equals %.blobs (select * from default_blobs where blob_name like '%.blob').

Up to version 6.6.1

default_attributes
default_blobs
default_channels
default_contents
default_links
default_news
default_obj_class_attrs
default_obj_classes
default_objects
default_permissions

Steps required after replication

The replication of the tables *_blobs, *_objs (or *_objects, respectively), and *_news produces constraints that cannot be satisfied since they refer to tables that are not replicated. Therefore, it is required to remove these constraints immediately after each replication process:

ALTER TABLE instanceName_permissions DROP FOREIGN KEY internet_permfk_1;
ALTER TABLE instanceName_news DROP FOREIGN KEY internet_newsfk_1;