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;