Hosting Formula

As I said in previous post about general steps taken to move wordpress blog to new host. Finally I have chance to demonstrate it.

Objective :

I have VDS account and need to move one of my blog for lowering cpu usage of my account. I decide to move one of my blog at http://www.knockdownhouse to new hosting place.

Requirement :

1. Shell acess enabled in both side, hosting account and destination account. In this case I use hostmonster.

2. Access to dns for modification ns entries.

Steps :

Compress blog and backup database in my VDS account.

1.  Login to my server using putty.

2. The format for login I use is :

username@ip address, this way I can save my steps. I just need to enter password of my VDS.

Click Open to start login.

3.  Enter password :

Just type the password, the screen won’t echo what you type.

Press Enter when your done.

4. If you type right password you’ll see $ prompt.

Last login: Tue Apr  1 10:30:18 2008 from home.hostingformula.info
[h3xxx173@bursalowongankerja /]$

5. Type ‘ls’ in $ prompt to list all files.

[h3xxxx73@bursalowongankerja /]$ ls

bin  dev  etc  ftp  home  include  lib  opt  proc  sbin  tmp  usr  var  www

My files located /var/www/html, go to that folder using cd command

[h3w27173@bursalowongankerja /]$ cd /var/www/html/

[h3w27173@bursalowongankerja html]$ ls

books         phpmyadmin          wp-comments-post.php  wp-pass.php
cars          plugins             wp-commentsrss2.php   wp-rdf.php
digitalfusi   poweredby.png       wp-config-sample.php  wp-register.php
fm            readme.html         wp-config.php         wp-rss.php
howtoset      router              wp-content            wp-rss2.php
index.php     users               wp-cron.php           wp-settings.php
info.php      vdsbackup           wp-feed.php           wp-trackback.php
knockdown wp-admin            wp-includes           xmlrpc.php
license.txt   wp-app.php          wp-links-opml.php
manager       wp-atom.php         wp-login.php
manager.html  wp-blog-header.php  wp-mail.php

www.knockdownhouse.com located in knockdown directory.

6. Go to knockdown directory and backup database.

[h3w27173@bursalowongankerja html]$ cd knockdown/
[h3xxxx73@bursalowongankerja knockdown]$ nano wp-config.php

nano wp-config.php is command to see database name, db username dan password.

backup database using this command :

[h3xxxx73@bursalowongankerja knockdown]$ mysqldump -uusername -p databasename > filebackupname.sql

[h3xxxx73@bursalowongankerja knockdown]$ mysqldump -uhxxxx173 -p knockdown > knockdown.sql

enter your database password to start backup.

7. Compress knockdown into single file.

[h3xxxx73@bursalowongankerja knockdown]$ cd ..
[h3xxxx73@bursalowongankerja html]$ tar -cvsf knockdown.tar.gz knockdown

8. Send knockdown.tar.gz to my hostmoster account.

[h3xxxx73@bursalowongankerja html]$ scp knockdown.tar.gz oneone5@101info.net:/h                       ome/oneone5
The authenticity of host ‘101info.net (74.220.215.239)’ can’t be established.
RSA key fingerprint is 75:fd:40:aa:b7:56:xx:11:yy:6b:b5:zz:2c:b5:71:b6.
Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added ‘101info.net,74.220.215.239′ (RSA) to the list of known hosts.
onezero5@101info.net’s password:
knockdown.tar.gz  100% 2179KB 544.9KB/s   00:04
[h3xxxx73@bursalowongankerja html]$

Done.

Blog successfully transfered to my account.

In next post I’ll continue migration process in hostmonster side