Transfer a WordPress site between Live and Development environments or domains using the command line

Take a database backup

mysqldump --databases wpdb -uroot -p > wp.sql

From LIVE to Development Environment

sed -ibak 's+https://toggen.com.au+http://localhost:8080+g' wp.sql

FROM DEVELOPMENT TO LIVE

sed -ibak 's+http://localhost:8080+https://toggen.com.au+g' wp.sql

IMPORT DATABASE TO MYSQL SERVER

mysql -uroot -p wpdb < wp.sql