Document how to merge separate Drupal and CiviCRM databases into a single shared database
It used to be recommended to have separate Drupal and CiviCRM databases. For small deployments, a shared database is now recommended:
By default, new installations of CiviCRM will copy the MySQL connection details from the CMS, creating a shared database. It is also possible to install CiviCRM on a separate database. As a rule of thumb:
- A shared database works well for small deployments (eg a few thousand records and a single administrator or developer).
- Separate databases work well for large deployments (eg a million records and multiple administrators/developers).
https://docs.civicrm.org/installation/en/latest/general/requirements/#mysql-connection
How can you merge a separate Drupal and CiviCRM database into a single shared database?
Remaining tasks
Add topic(s) under sysadmin documentation:
- doc: https://docs.civicrm.org/sysadmin/en/latest/ (under "special situations")
- git repo: https://lab.civicrm.org/documentation/docs/sysadmin/
Document these steps:
- mysqldump one or the other DB
- remove DEFINERs (for triggers) (see https://stackoverflow.com/a/9447215)
- import into the other DB
- update settings