Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By weimeng on
I have Drupal running well on a multi-site configuration, with shared users and shared content. However, due to the growth of one of the sub-sites, it has become necessary to separate this sub-site's content from the other sites.
So far, via settings.php, I have set these tables to be specific to the sub-site: blocks, cache, system, url_alias and variable.
In order for the sub-site to have it's own independent taxonomy, nodes and user permissions/roles, what other tables do I need?
So far I know the following are required:
permission
node
node_access
node_comment_statistics
node_counter
role
term_data
term_hierarchy
term_node
term_relation
term_synonym
vocabulary
vocabulary_node_types
On the flip side, I also realize it might be easier to just share the user-related tables, while creating a separate copy of all the tables for the sub-site. In that case, which are the tables required?
Comments
painful
switching configurations of a live site like this is real hard. you need to know the internals to get the IDS and sequences right. answering this question is a huge task.