Drupal

db-sync-tool can automatically detect database credentials from Drupal applications (>= v8.0).

How It Works

The tool uses drush to extract database settings from Drupal installations.

See the Drush documentation for more information.

Prerequisites

• Drush must be installed and accessible on the system
• PHP CLI available

Command Line

Example for receiver mode:

db_sync_tool \
    --type Drupal \
    --origin-host <ORIGIN_HOST> \
    --origin-user <ORIGIN_USER> \
    --origin-path <ORIGIN_PATH> \
    --target-path <TARGET_PATH>

Configuration File

Point the path to the Drupal installation directory:

# config.yaml
type: Drupal
target:
  path: /var/www/local/drupal
origin:
  host: prod.example.com
  user: ssh_user
  path: /var/www/html/drupal

Complete Example

type: Drupal
target:
  path: /var/www/local/drupal
origin:
  host: 192.87.33.123
  user: ssh_demo_user
  path: /var/www/html/drupal
  name: Production
ignore_table:
  - cache_*
  - sessions
  - watchdog

Common Ignore Tables

Drupal projects often exclude cache and session tables:

ignore_table:
  - cache_*
  - sessions
  - watchdog
  - flood

Next Steps

• Configuration Reference - All configuration options
• Sync Modes - Different synchronization modes