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;