Migrate a database from local to staging/production with WP CLI and SSH

command-line.sh

##
# This assumes the following folder structure
# Local environment:
# ./app/
# ./app/www/
# ./_db_dumps/
#
# Production/staging environment:
# ./wordpress/current/
# ./_db_dumps/
###

# Local, in: ./app/www/ folder
wp db export latest.sql && mv *.sql ../../_db_dumps/
# Local, in: ./
scp _db_dumps/latest.sql user@host:_db_dumps/
# Server, in: ./wordpress/current/:
wp db import ~/_db_dumps/latest.sql && wp search-replace "localdomain.test" "productdomain.com" --all-tables