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