josephdsouza86/wp-sync-db-cli

WP Sync DB CLI Addon

Installs: 0

Dependents: 0

Suggesters: 0

Security: 0

Stars: 0

Watchers: 0

Forks: 41

Type:wordpress-plugin

dev-master 2022-03-03 16:30 UTC

This package is auto-updated.

Last update: 2024-10-29 06:41:42 UTC


README

An addon for WP Sync DB that allows you to execute migrations using a function call or via WP-CLI

Example usage

The following two variations of the wpsdb migrate command are possible by supplying either a profile id or connection info string.

Target a user created profile already stored in the system/database

wp wpsdb migrate --profile=1

profile represents the profile number as seen in the Migrate tab's "saved migration profiles" list in WP.

Manually target a connection string (no profile)

wp wpsdb migrate --connection-info=https://example.com\n6AvE1jnBHIZtITuNCXj2eZArNM8uqNXC --action=pull --create-backup=1

connection-info is the string found on the target site's Settings tab. The line break is replaced with the \n equivalent character in order to pass the whole string on a single line.

action can be set to either pull or push depending on the direction of the DB sync

create-backup is a bit field that indicates whether the DB should be backed up prior to a transfer. This defaults to 1.

Target a profile and fallback to a connection string

wp wpsdb migrate --profile=1 --connection-info=https://example.com\n6AvE1jnBHIZtITuNCXj2eZArNM8uqNXC --action=pull --create-backup=1

In this example we can attempt to target a profile that doesn't yet exist before the migration and instead fallback to the manual profile arguments provided. Once the migration is complete if we re-run this command, then the profile will have been migrated over and this will be used. This is useful from an automation point of view.