Use WP CLI to migrate a WordPress database with search-replace

gistfile1.txt

#On the source WP site:
wp db export wp-export.sql --all-tables 

#On the destination site

#First import the new DB
wp db import wp-export.sql

## Replace basic URLs
wp search-replace oldsite.com newsite.com --skip-columns=guid --all-tables
## Replace URL escaped strings
wp search-replace "https:\/\/oldsite.com\/" "https:\/\/newsite.com\/" --skip-columns=guid --all-tables
## Replace URL encoded strings
wp search-replace 'http%3A%2F%2Foldsite.com' 'http%3A%2F%2Fnewsite.com' --skip-columns=guid --all-tables