• LinkedIn profile said that the feed URL to my blog is inaccessible. How to fix this?
  - you can test your feed on http://validator.w3.org/feed/

• If you manage mysql database via a graphical interface but find phpMyAdmin overwhelming, I recommend Adminer. http://www.adminer.org/en/

• I get my domain name from yahoo when is just USD 9.90 (yes during promotion) and now it goes up to USD 35. Intend to switch. Thanks to Twitter, I got my answer. http://www.blacknight.com/transferdomain.html

Recently, I was hire to move Wordpress site/blog to a new hosting

These SQL statement help me when page and post did not show up on the new host

UPDATE wp_options SET option_value = replace(option_value, ‘http://www.old-domain
.com’, ‘http://www.new-domain.com’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;

UPDATE wp_posts SET guid = replace(guid, ‘http://www.old-domain.com’,'http://www.new-domain.com’);

UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.old-domain.com’, ‘http://www.new-domain.com’);

Where do I run the SQL script?

Every WordPress site/blog uses a MySQL Database which can be accessed through your phpMyAdmin even if you are not using cPanel hosting. Login to MySQL database that houses WordPress tables via phpMyAdmin or login to the DB server and run MySQL client as root.

No confidence of moving Wordpress site/blog to a new domain or location?

Not sure what I am talking about? Hire me and let me solve this tricky Wordpress migration. Contact me mryap [at] ymail.com

Wordpress is a popular blogging software. It is now being increasingly used to manage website.

If you have a Wordpress-driven website and your websites goes blank, try this.

Are you able to log-in to Wordpress Admin?

If yes, access your site directory via FTP, and see whether Themes folders is in wp-content directory. 

Upload the themes folders (you do have a backup right?) and try reload the website.
Your Wordpress-driven website should be restored.

Today, I help a tech-savvy client whose websites goes blank after updating a Wordpress plug-in. While viewing the source code, the code is empty.

First, I try deactivating Wordpress plug-ins that cause the problems. This does not work.

Next, I try to purge the Wordpress database and upload a fresh new one (i.e. a backup of sql file). Neither this works.

Finally, I decide to do the above. Access the website directory via FTP to see what files are missing.

For some reason, the themes folders go missing.

Take-Away

It advisable and good practice NOT to test or update plug-ins, themes on the live website.

Allocate on the same webhost the same Wordpress site and do any theme, plug-in updates to assess before making the changes on your live site.

Lastly, backup every thing.