How to copy wordpress from one domain to another? – CPanel

Please see the attack bash code bellow. Save it as update-wordpress-domain.sh for example and then do a chmod +x on it. Please edit/change/modify the db name, db user and password in the script the run it. It will ask for old domain and then for new domain. Then it will do the necessary changes:

#!/bin/bash

SQL_USER="db-user"
SQL_PASS="db-password"
SQL_DB="db-name"

echo -e "Enter old domain: c"
read OLD_DOMAIN
echo -e "Enter new domain: c"
read NEW_DOMAIN

if [ -z "$OLD_DOMAIN" ] || [ -z "$NEW_DOMAIN" ]; then
    echo "old url and/or new url are empty. please define them!"
    exit 1
fi

# Save a mysqldump first!
DATE=`date -I`

mysqldump --opt -u $SQL_USER -p$SQL_PASS $SQL_DB > $SQL_DB.$DATE.sql

echo "Updating the database"

mysql -u $SQL_USER -p$SQL_PASS $SQL_DB -e "UPDATE wp_options SET option_value = replace(option_value, 'http://$OLD_DOMAIN', 'http://$NEW_DOMAIN') WHERE option_name = 'home' OR option_name = 'siteurl';"
mysql -u $SQL_USER -p$SQL_PASS $SQL_DB -e "UPDATE wp_posts SET guid = replace(guid, 'http://$OLD_DOMAIN','http://$NEW_DOMAIN');"
mysql -u $SQL_USER -p$SQL_PASS $SQL_DB -e "UPDATE wp_posts SET post_content = replace(post_content, 'http://$OLD_DOMAIN', 'http://$NEW_DOMAIN');"
mysql -u $SQL_USER -p$SQL_PASS $SQL_DB -e "UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://$OLD_DOMAIN','http://$NEW_DOMAIN');"
echo ""
echo "Done!"

Then run it as ./update-wordpress-domain.sh

Please keep in mind that the script has to be run locally via SSH on the server where the database is actually located!.

The script will first create a mysql database dump, before actually change anything in the current database.