Moving wordpress blog to new domain

by Nish Vamadevan on 19/03/2008 · View Comments

I have finally decided to move this wordpress blog to the parent domain (www.fnode.com) and going to be concentrating on more Tech, Online, News, and Reviews and I have decided to use this domain for mainly Journals and Tip / How-To purposes. I think that way, I can separate the media side of things from personal journals.

This is how I moved my wordpress blog from nishv.com to fnode.com

  • Install wordpress on fnode.com
  • Went to nishv.com and copied the wp-content Directory and replaced it with the Directiory on fnode.com (So all the theme, plug-in and the uploaded contents are all there…)
  • Went to nishv.com and used phpMyAdmin to drum an .sql file of the database. (You may prefer .gz depending on the file size)
  • Went to fnode.com and used phpMyAdmin to drop all the tables on the wordpress database.
  • Imported the backed up database from nishv.com

Ran the following SQL Queries…


UPDATE wp_options SET option_value = replace(option_value, 'http://www.nishv.com', 'http://www.fnode.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET guid = replace(guid, 'http://www.nishv.com','http://www.fnode.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.nishv.com', 'http://www.fnode.com');

That’s it, All set, now you can tweek the blog!

Leave a Comment

blog comments powered by Disqus

Previous post:

Next post: