I’ve been largely engaged in other activities, other than blogging. I haven’t been able to spend as much time on this blog. I’ll be doing a major cleanup of the website though. Eventually I’ll be doing a bit more sharing of the interesting bits that I come across rather than writing full pieces. Do look forward to it. 
WordPress 3.3 is out:
Easier Uploading
We’ve streamlined things! Instead of needing to click on a specific upload icon based on your file type, now there’s just one. Once your file is uploaded, the appropriate fields will be displayed for entering information based on the file type.
Adding photos or other files to posts and pages just got easier. Drag files from your desktop and drop them into the uploader. Add one file at a time, or many at once.
We’ve added the rar and 7z file formats to the list of allowed file types in the uploader.
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.