Dumps your database and excludes some tables. This is useful i.e. for development (reduce size of the dump) or can help to provide GDPR compatible dumps without customer data.

Separate each table to strip by a space. You can use wildcards like * and ? in the table names to strip multiple tables. In addition you can specify pre-defined table groups that start with an @.

Example:

$ n98-magerun2.phar db:dump --strip="dataflow_batch_export unimportant_module_* @log @stripped"

Available Table Groups:

• @admin Admin tables.
• @oauth OAuth tables.
• @log Log tables.
• @sessions Database session tables.
• @stripped Standard definition for a stripped dump (logs, sessions, dotmailer).
• @sales Sales data (orders, invoices, creditmemos etc).
• @quotes Cart (quote) data.
• @customers Customer data - Should not be used without @sales.
• @trade Current trade data (customers and orders). You usally do not want those in developer systems.
• @development Removes logs and trade data so developers do not have to
• @search Search related tables.
• @idx Tables with _idx suffix.
• @dotmailer Dotmailer tables.
• @2fa Two Factor Auth tables.
• @newrelic_reporting New Relic reporting tables.
• @aggregated Aggregated tables.
• @replica Replica tables.
• @klarna Klarna tables.
• @temp Temporary indexer tables.
• @mailchimp Mailchimp tables.

Run the command with --help to see a up-to-date list of available groups.

You can extend or modify the groups by creating your own config ~/.n98-magerun2.yaml or project-specific config in app/etc/n98-magerun2.yaml file.

Example:

commands:
  N98\Magento\Command\Database\DumpCommand:
    table-groups:
      - id: "n98"
        description: "Tables starting with n98"
        tables: "n98*"
      - id: "foo"
        description: "Mix groups and single table names"
        tables: "foo bar @log"
      - id: "development_custom"
        description: "Removes logs and trade data so developers do not have to work with real customer data"
        tables: "@development @n98"

Verify with db:dump --help if your new groups are registered.