WP-CLI aliases sync example

sync-prod.sh

read -r -p "Would you really like to reset your development database and pull the latest from production? [y/N] " response

if [[ "$response" =~ ^([yY][eE][sS]|[yY])$ ]]; then
    wp @development db reset --yes &&
    wp @production db export - > sql-dump-production.sql &&
    wp @development db import sql-dump-production.sql &&
    wp @development search-replace https://example.com https://example.dev
fi

wp-cli.yml

path: web/wp
@production:
  ssh: web@example.com/srv/www/example.com/current
@development:
  ssh: vagrant@example.dev/srv/www/example.com/current

#!/usr/bin/env bash
read -r -p "Would you really like to reset your development database and pull the latest from production? [y/N] " response

if [[ "$response" =~ ^([yY][eE][sS]|[yY])$ ]]; then
wp @staging db reset --yes &&
wp db export sql-dump-dev.sql --add-drop-table &&
wp @staging db import - < sql-dump-dev.sql &&
wp @staging search-replace http://strefatradera.l http://strefatradera.ufff.pl
fi