Category “Blog”

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

Standard Chartered KL Marathon 2013 – already looking forward to 2014

Last Sunday I ran the 10km (Speed) race at the Standard Chartered KL Marathon. It was such a great experience for me and I’m already looking forward to next year.

I got a big kick weaving my way through the pack at the beginning of the race, running alongside thousands of fellow runners in downtown KL, disrupting traffic and running flat out at the finish line.

StanChart KL Marathon 2013

Me completing my 10K at SCKLM2013. This picture cost me SGD30…

The event is the most popular road race in Malaysia and this year saw a record-breaking 33,000+ runners. SCKLM had to be postponed from its original date in June due to the haze situation, but the event last week was top notch. I felt that it was really well-organized and let the runners really enjoy the race. Read More »

Happy Malaysia Day!

malaysia-flag-langkawi

Dearest Malaysia,

Happy 50th birthday! As we celebrate this milestone together, I’m reminded of how much I love you. I love your awesome natural wonders, your beautiful people, your colorful celebrations and your delicious food.. mmm, I love me a good nasi lemak.

Of course, things aren’t always great. No country is perfect. I don’t blame you, I blame the twats who have grown thick in the head after staying in power for so long. I’m sure we’ll fix the problem in time.

Malaysia is my home and I’m proud to call myself Malaysian. I love you more each year and I want my children to love you as much as I do.

Happy Malaysia Day, and may you grow ever more beautiful every year.

 

Picture credit: sam4605 on Flickr

Comments Closed

Tips for refreshing afternoon naps (to increase your productivity)

old hairdresser sleeping at work

Recently I’ve started to wake up at 5am to get a head start to my day. I usually rise this early 4-6 times a week. I’ve found that I manage to accomplish a lot more when I wake up so early. Some days I begin the work day at 6am, other days I go for a run first. All in all, waking up at 5am is a real productivity booster.

The problem is that by lunch time, I’ve already been awake for 6-7 hours and I’m tired out. I need a nap to top off my batteries if I want to make it through the day. Afternoon naps FTW! And with all that  “practice”, I’ve developed a few tips to make make the most of my naps.

Most important tip: Naps should be 15-20 minutes long only, 30 minutes at most. Any longer and you’re more likely to be groggy the rest of the day. Read More »

Self-employment is a license to say NO

shutterstock_18863395

Many people go self-employed and gleefully say, “look at all the things I can do.” Self-employment offers the freedom to say YES to all sorts of interesting projects that they wouldn’t have time for with a full-time job.

But the true freedom offered by self-employment is the ability to say NO. Now you can choose to avoid mediocre projects, uninteresting obligations and avoid the drudgery of chores you had no choice but to do when you had a job.

Your time is precious and irreplaceable, so you should absolutely be saying NO more often than YES. Now you can focus your time on the projects that actually excite you, your family and loved ones, your calling – i.e. the stuff that truly matters.