Skip to content

Instantly share code, notes, and snippets.

@harryfinn
Created March 24, 2016 11:59
Show Gist options
  • Save harryfinn/65f90d419b3f2ba688de to your computer and use it in GitHub Desktop.
Save harryfinn/65f90d419b3f2ba688de to your computer and use it in GitHub Desktop.
WP-CLI DB migrate instructions

Instructions for using WP-CLI to migrate a WordPress DB

# Export current (local) DB
wp db export db.sql

# Copy file from local to server (may need to amend server path if not in html folder)
# The example below is for local to remote, simply swap these 2 around for remote to local
scp -r db.sql www-data@IP_ADDRESS:/var/www/html

# SSH onto box (should be same connection details as above)
ssh www-data@IP_ADDRESS

# Run the WP CLI DB importer
wp db import db.sql

# Use --dry-run first to check that changes will be OK in DB
wp search-replace old-site-url.co.uk new-site-url.co.uk --dry-run
wp search-replace old-site-url.co.uk new-site-url.co.uk

# Delete imported DB file
rm db.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment