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 [email protected]:/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 🙂