WordPress database transfer BETWEEN LIVE AND DEVELOPMENT SITES without a plugin

Written by James McDonald

June 7, 2022

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

Submit a Comment

Your email address will not be published.

You May Also Like…

MacOS USB Creator

Just toasted my Windows 10 Pro install with a Windows 11 upgrade. Think it will be unrecoverable (because of Bitlocker...