Just upgraded. Actually I finally upgraded to WordPress 3.0.
This blog has far too much spam for me to handle. Now I won’t be going through the spam to pull out legitimate comments. It has just become unmanageable. 
I’ve been slowly moving images into Amazon S3. My main purpose to do offload images to another server. This current server is quite badly hit due to hot-linking actually. All the old images hot-linked will be broken. I am not too concern about that. I have updated all my blog posts to reflect the new image urls.
These are the MySQL find and replace commands for URL address changes:
UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "'http://beconfused.com/images/", "'http://beconfused.com/new-address/")UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "\"http://beconfused.com/images/", "'http://beconfused.com/new-address/")UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "'http://www.beconfused.com/images/", "'http://beconfused.com/new-address/")UPDATE `wp_posts` SET `post_content` = replace(`post_content`, "\"http://www.beconfused.com/images/", "'http://beconfused.com/new-address/")
Not that my WordPress posts table is called ‘wp_posts’, yours may be called something else.
The above code changes all HTML links and images to the new address. Notice it starts with a quotation, this is to ensure what is being changed is part of a HTML attribute. Single and double quotations will be changed.
You can execute it in phpMyAdmin.
Long time since I’ve actually blogged.
Firstly, my university has ended. Yeah!
And then, I started learning Japanese formally, it has been interesting.
I have also decided to follow up on my driving lessons.
Things have gotten less busy and I’ve finally have got the time to do a bit of consolidation of my websites.
This blog is going to be partially hosted in Amazon S3. I’ve tolerated lots of years of hot-linking, this time I’m partially disabling some images from hot-linking due to raising costs.
It’s been a while I write much in this blog. I haven’t place effort in maintaining this blog. Things are failing randomly, the template isn’t working too well.
Sometimes, in the train, I would have some ideas of a new template. Something that would re-energize this rather quiet blog. I never got about doing it; I have neither time nor the ability to concentrate sitting in front of the computer, making a new layout.
This blog has been through a lot. It’s been through a total of 7 migrations, of which the previous one is the most major. Each time I migrate, I lose a little part of the blog. I lost some data this time. Previously I lose some plug-ins I wrote myself and — tadah — I did not backup.
This time around, my loss is mainly on comments. I lost about 4 days worth of comments and 1 post. I did a weekly backup but that isn’t enough apparently.
The loss isn’t great. I can take it. The resolution took about half a day with three blogs to fix.
Looking at the brighter side, my new host is cheaper and easily to scale vertically. The server uses both nginx and Apache this time — with nginx serving static content such as images and Apache serving dynamic content. I have also made daily backups instead of weekly ones. May this blog continue to grow.
There has been a really bad moment where my database instance went corrupted. I lost some recent data, particularly comments in this blog. I tried all ways to fix the issue but can’t. The only way would be to input all the missing comments manually which would be quite a challenge.
I have moved to a better server. This time, I’m at Rackspace Cloud. It’s a carefully made decision and I hope this website will serve you better in time to come.
The past year, I’ve been really busy with school and work. I barely have the mood to update the blog. When I am free I spend most of my time in front of the computer sometimes just trying to cheer myself up. And my slow host also killed my interest in blogging.
But today I had enough and migrated. A new server and with lots of little things to fix. My age old theme, the 200+ unanswered emails. I’m sorry. I won’t answer back the emails but I promise to answer them from now on.
Things are getting better and I have this bit of positivity about life again.
As for beconfused, I guess that would convert to more posts and better content.