New ClickWP.com

logo-clickwp

I finally launched the new ClickWP website, after almost a year of planning, designing, and 4 weeks of furious coding. Along with it is an all new branding by Reese Spykerman as well.

Read More »

Comments Closed

barack-in-malaysia

Barack Obama visited Malaysia and made quite the impression.

Malaysia won’t succeed if the non-Muslims do not have the same opportunity

Source: The Malay Mail / Yahoo! News

I appreciate your support, Mr President!

Comments Closed

Welcome Aaron

Aaron’s first selfie.

3.6kg & 50cm long, even bigger than his brother!

Comments Closed

Zack’s birthday

Zack’s recently gotten into Toy Story, so this year I got him Woody and Buzz Lightyear. I had to buy them from DisneyStore.com and have them shipped all the way, which was a bit of a hassle, but Zack’s reaction was so worth it. And I have fun playing with them too

Webfaction hosting gives you lots of flexibility and power, if you can live without cPanel

webfaction-logo

Webfaction is an unpretentious, down-to-earth web host that gives you great performance and value. Cool hipsters types may not host their sites here (they’re on Media Temple) but in my 9 months using Webfaction I’ve been well and truly impressed. Webfaction has provided the greatest performance and value for any web host I’ve ever used, and I happily recommend them.

Fantastic performance

Shortly after switching one of my customers to Webfaction, they had a post go viral. As a result, they received 24k pageviews over a period of 3 days. Webfaction held up like a champ.

24,000 pageviews in 27 hours - no problems

24,000 pageviews in 27 hours – no problems

There were no hiccups, database errors or even slow pages. Of course, I had W3 Total Cache installed and configured but the credit has to go to the web server. Webfaction can also serve your site from multiple servers with automatic load balancing if you need it.

Just 2 weeks ago, a customer of mine who was on Media Temple complained that her site was struggling and that the WordPress dashboard was taking almost 30 seconds to load on average. I switched her to Webfaction and her site immediately started loading quicker and her performance issues have largely been solved.

Read More »

Comments Closed

Useful SQL queries for migrating a WordPress database

First, if at all possible, use the WP Migrate DB Pro or BackupBuddy plugins to migrate your WordPress database. The money spent will save yourself a lot of frustration and hair pulling, and hours if not days of cleanup and massaging of the WordPress database.

But if that’s not possible, welcome to my world for the past week. I’ve had to migrate a WordPress database without my favorite migration tools. After scouring the web for tutorials and tips, I’m compiling them here for easy reference.

Gather Your Tools

First thing you need is to get your hands on the following:

1. Database name, prefix, user and password.

You can find these defined in the wp-config.php file. In the following examples, be sure to swap out the database name wordpress and prefix wp_ with the correct values from your situation.

2. Access to phpMyAdmin so that you can interact with the database.

We’ll be running the commands below through the SQL tab in phpMyAdmin.

phpmyadmin-sqlquery

Running SQL queries on your database with phpMyAdmin

You could also connect directly to MySQL through the terminal / shell prompt. Good luck if you don’t have phpMyAdmin.

3. Backup, Backup, Backup

Don’t say I didn’t warn you. Export your untouched database and lock it up. If all goes wrong, restore to this backup.

Change the Site URL

The first thing you would want to do is to change the site URL. You can browse the wp_options table for the siteurl and home options values directly, or you can use this SQL command:

UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldsiteurl.com', 'http://www.newsiteurl.com') WHERE option_name = 'siteurl' OR option_name = 'home';

Next, you’ll want to replace all instances of oldsiteurl.com in your post’s contents and GUID.

UPDATE wp_posts SET post_content = REPLACE (post_content, '//www.oldsiteurl.com', '//www.newsiteurl.com');
UPDATE wp_posts SET guid = REPLACE (guid, '//www.oldsiteurl.com', '//www.newsiteurl.com');

Read More »

Comments Closed

Sweden With Love

Happy day! We are finally live! A brand new online experience. #swedenwithlove. Beautifully designed by @thedarlingtree. xo

Sweden With Love was a ClickWP project for Ulrica Wihlborg. It features a custom WordPress theme built on the Genesis Framework. Jo Klima from The Darling Tree created the design while I was responsible for coding the theme and site implementation.

Read More »

Comments Closed

Every mobile phone I’ve ever owned #PhonesIveOwned

Earlier today I got into a conversation with Pei Chyi about the mobile phones we’ve used before. I’ve only ever used Apple and Nokia phones (with 1 anomaly on the list) and if I couldn’t have an iPhone today I would still use a Nokia. Windows Phone is more appealing to me than Android.

It’s fun recalling the epitome of consumer technology of years past as the exercise makes you appreciate what you have now even more. Without further ado, I present to you the complete list of David Wang has ever owned.

Nokia 3210

Nokia 3210

My first ever mobile phone was the venerable Nokia 3210, arguably the best mobile phone ever made. Acquired after Sixth Form in 1999, it wasn’t the latest and greatest but it was my old faithful. Since there were no apps to buy, I spent money on different coloured covers and keypads – mine was red with gel buttons. And who needed apps, when you had Snake? Battery life for SMS and Snake was incredible too, especially since it only had a monochrome 84 x 48 pixel / 32 x 22 mm screen.

Nokia 8250

Nokia_8250

My next phone came into my possession through some rather dubious means… I found it on the sidewalk, really! I was really happy to have found the phone too, since it was the bee’s knees with it’s butterfly-shaped button and blue backlight! Don’t remember anything else about this phone though.

Nokia 6220

nokia_6220

My next phone was my first camera phone. On top of that it had a color display! It wasn’t a very popular model, but it was in my opinion better than the silly Nokia 7260 or Nokia 3200 that were it’s contemporary peers. I remember snapping crappy pics every opportunity I could but everything else about the phone was pretty forgettable.

Read More »