Hosting Formula

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

My friend challenge me to move hostingformula.info to another host that not support ssh in shortest time.

I’m agree and do that in less than 30 minutes.

How?

Domain preparation :

1. Change dns to new host

Login to old host using ssh :

1. backup db and save sql file in wp-content folder
# cat wp-config.php
# myqldump -uwinhowsn_hosting -p winhowsn_hosting > hosting.sql
# mv hosting.sql wp-content/

2. Compress folder
# tar cvzf wp-content.tar.gz wp-content

3. download to my computer using ftp client or just download it from browser using this address :

http://hostingformula.info/wp-content.tar.gz

Login to new host using cpanel :

1. Download latest wordpress file and save to my pc

2. Upload to main root and extract the file to public_html folder

3. Create database from cpanel menu

4. Install blog using famous ‘5 minutes’ installation of wordpress.

5. Rename wp-content to wp-content_old

6. Impor sql from downloaded file after drop all existing tables.

7. Pack wp-content.tar.gz to wp-content.zip minus sql file.

8. Upload wp-content.zip using file manager

9. unzip wp-content.zip

Done.

All things clear

Fortunately my dns propagation work effective for me in less than 4 hour. Of course dns propagation is another work.