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
0 Comments