Moving My “Old WordPress Site” to Other Domain

Since I have decided to “refresh” this site and moved all of my old post to other site, I have to find the way to move all of my site without loosing any data (or file). I’ve searched all over the internet, and found some method to do this.

I’ve decided to combine and summarize some method to be more easy and simple for me. See my step by step below:

1. First come first, the most important step, backup your public_html folder (Or just folder wp-content, your choice ) using FTP (or file manager in cPanel) and also backup the MySQL Database (use the export tool in phpMyAdmin will help).
2. Install New WordPress in New Domain.
3. Restore all your backup files (make sure the path is correct).
4. Do the following procedure to update your “New Database” using phpMyAdmin or MySQL CLI/Shell:
   update URL location:

   UPDATE  wp_options SET option_value = replace(option_value, 'http://adi-sunardy.net',  'http://price4knowledge.com') WHERE option_name = 'home' OR option_name =  'siteurl';

   update internal links

   UPDATE wp_posts SET guid = replace(guid, 'http://adi-sunardy.net',  'http://price4knowledge.com');

   update previous post

   UPDATE wp_posts SET guid = replace(post_content,'http://adi-sunardy.net',  'http://price4knowledge.com');

   Note: adi-sunardy.net is my old-domain and price4knowledge.com is the new-domain. Please adjust it base on your needs.

5. Check .htaccess, regenerate from WP Admin Panel if needed.
6. I still want to use my old domain, so i won’t redirect it to my new domain. But, if needed, you can adjust .htaccess to redirect your old-domain to new-domain with following code:

    RewriteEngine on
   RewriteCond %{HTTP_HOST} adi-sunardy.net
   RewriteRule ^(.*) http://price4knowledge.com/$1 [R]

7. Recheck your New Site by visiting your new-domain using web browser, find any error and fix it.
8. Another methods? Find it from the official WordPress Site

It should be done by now.

Please be advised. I’ve encountered a problem regarding my feedburner feed after moving my site. The old feedburner link is not valid anymore, but by default my new-site’s feed always being forwarded to this “non-valid feedburner link”. I’ve gone directly to the MySQL database using phpMyadmin, do search query for the old feedburner link and update the value in table wp_option, field option_name = smart_feed* accordingly

Maybe you also want to read:

1. New face, new post! Hi, I’ve been thinking for long time and finally decide...

Tagged as: domain, PHP/MySQL, Wordpress