WordPress database backup and restore

I heard from a Chinese blog that it seems blogs hosted by weblogs.us were blocked by China’s “Great Fire Wall”. I am a little bit astonished because weblogs.us is not a large scale BSP at all. Anyway, it happens.

I ever considered to buy web hosting space and domain name to build my own homepage as well as blog. Now I have to consider it again, though the service offered by weblogs.us is unbeatable at this price ($0, thanks JD!). So I just tried to backup the database at weblogs.us and restore it on my local server as a rehearsal. It works well. With phpmyadmin, I can backup the whole database or any of the tables, then restore it by phpmyadmin on my local server. After restore, I need to browse the “options” table and modify the wordpress URI manually. Then I can access http://localhost/wordpress/wp-admin/. A theme needs to be selected if the theme used on weblogs.us is not installed on localhost yet, otherwise the blog will turns out to be empty. After that I have a mirror site of my blog on local.

Ref: Backing Up Your Database at WordPress.org Codex


A radio blog.


Integrate Gallery and WordPress

I finally integrated Gallery with the Blix theme by taking the following link as a reference. It’s not a simple mission to do that, I really hope there will be such a plugin out soon.

Scattered ยป Gallery Integration with Kubrick and WordPress 1.2

Pixelpost link

The archive of addons and templates for pixelpost.

PIXELPOST – Small Photoblog Software

A hot weekend

I really have not updated this blog for some while. Seems I was not too busy nor too lazy, but I just felt there’s nothing special or new to post and share with the possible readers.

We ran out to watch the movie “Mr. and Mrs. Smith” during this weekend. The movie is okay, maybe a little bit less than what I expected. The cast is good, and some gossip news makes it more famous (I assume you know what I am saying). I personally would prefer this movie as a marriage comedy more. The dramatics are turned out in a way of war, however. It’s not totally my preferred style though.

I spent one or two hours last night to configure the Gallery v1 on this site. I have been a loyal user of it and I still think it’s one of the best album software out of there. So I just make a copy here in case I want to use it for my new photos, including my baby’s of course.

This weekend is really hot here in mid-west. Hope it will be cooler next week so we can also save some bucks on our bill. :P

Parents got U.S. visa

This morning (June 14 China time) my parents just got their visas to US in Shanghai. They are going to spend several months with us here in this summer. The greatest thing is they are going to see their granddaughter’s birth and we are going to share the big happiness together! Yao Yao’s gotta meet her dear grandparents in her first days. :) And they will help us a lot on taking care of the little one for sure, that’s another important thing for me and my wife.

Anyway, it’s really good for all of us.

Long time no update

Actually it’s only about one week. But the truth is one week is not a short time in network era. Things just change so fast even by seconds.

Well, it’s already June. It’s very hot here in Midwest these days since last weekend. So the summer is right here and the short short spring just disappears in no time, whew.

My baby is going to join us in less than 100 days. Yes, that’s really exciting! We just cannot help waiting to see what she looks like. We have prepared most of the stuff for her coming. And today her first box of diapers just arrived. :) We are just running a weblog for her and I have also prepared a photo album for baby photos, though that’s still a little bit early. I also built a photoblog to record those coming precious moments in my life, also in my wife and my baby girl’s. All these will have their links here soon.