Manually migrate production WP DB to local environment, using WP CLI

wp-cli-migrate.md

This guide assumes you’re using https://localwp.com for your local environment.

Pull DB from the production server

• wp db export ~/.mysqldump/wp_transfer.sql

Transfer DB from the production server to local

• Connect to server via FTP
• Transfer ~/.mysqldump/wp_transfer.sql to your desktop

Replace the DB in the local site

• Open Local
• Right click on the local site and select ‘Open site shell’
  • wp db import ~/Desktop/wp_transfer.sql —dry-run to verify, then
  • wp db import ~/Desktop/wp_transfer.sql
  • If this command fails, try this workaround: https://localwp.com/community/t/lightning-open-site-shell-not-working/14150/7 mysql -u root -proot local < ~/Desktop/wp_transfer.sql

Replace URLs in the local DB

https://developer.wordpress.org/cli/commands/search-replace/#examples