Moving wordpress blog to new place and new domain

Another client ask me to move their blog to new vps server, something new in this case is the operating system of their vps server :

OpenSolaris

Yup, I have little experience in this OS but I still accept the job for $10.

Here’s the steps :

Secure copy with scp

# scp /data2/jails/outside/usr/home/alamster/outside.tar.gz arasyid@72.233.106.191:/home/alamster

Extract the file

#gzip -dc outside.tar.gz | tar xvf -

Edit wp-config.php

#/opt/csw/bin/nano wp-config.php

Edit with suitable content.

Call MySQL

find out where mysql

# ps -eaf | grep mysql

mysql  8107     1   0   Apr 22 ?           5:26 /usr/mysql/5.0/bin/mysqld –user=mysql –datadir=/var/mysql/5.0/data –pid-file

# /usr/mysql/5.0/bin/mysql -uroot -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9005
Server version: 5.0.67 Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> drop database demo;
Query OK, 10 rows affected (0.03 sec)

mysql> create database demo;
Query OK, 1 row affected (0.00 sec)

mysql> exit
Bye

Import db

# /usr/mysql/5.0/bin/mysql -uroot -p demo < pctoutside.sql

Search and replace in MYSQL

# /usr/mysql/5.0/bin/mysql -uroot -p

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9007
Server version: 5.0.67 Source distribution

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.

mysql> use demo;
Database changed
mysql>

update wp_options set option_value=replace(option_value,’http://outside.demo.com’,'http://www2.demo.com’);

update wp_postmeta set meta_value=replace(meta_value,’http://outside.demo.com’,'http://www2.demo.com’);

update wp_postmeta set meta_value=replace(meta_value,’http://172.88.1.13′,’http://www2.demo.com’);

update wp_posts set post_content=replace(post_content,’http://172.88.1.13′,’http://www2.demo.com’);

update wp_posts set post_content=replace(post_content,’http://outside.demo.com’,'http://www2.demo.com’);

update wp_posts set guid=replace(guid,’http://outside.demo.com’,'http://www2.demo.com’);

update wp_posts set guid=replace(guid,’http://172.88.1.13′,’http://www2.demo.com’);

Finish

all things goes back to normal in new place and new domain.

P.S :  I change the domain for education purpose

Related posts:

1. Moving WordPress Blog to new host
2. Migrating wpmu blog to new host
3. Install wordpress for home development : setting domain
4. Moving to hostmonster with scp
5. How to install cache solution for wordpress blog