Archive for December, 2009

Tips for upgrading to WordPress 2.9 on 1and1

Thursday, December 24th, 2009

A few days ago I upgraded this blog from WordPress 2.8.5 to 2.9. Here are some tips on what I did in case you run into any of the same issues that I did. My blog is hosted by 1and1 and some of the information may be specific to them.

This isn’t meant as a full upgrade guide – just a collection of tips that may help you.

First make sure you backup your data! There are some general wordpress backup tips on a post I did about a previous upgrade.

1. Export the SQL database

In the MySQL admin panel I selected these extra options: ‘Add DROP TABLE’ and ‘Complete inserts’, and then chose to save the file as a .gz (gzip) archive. If you need a free application to read .gz archives then I recommend 7-Zip.

Oneandone MySQL icon

2. Export the XML data

Export the XML post data from the WordPress admin panel (Tools->Export).

3. Zip and downloaded the blog files

Zip up the actual files on the server. On 1and1 the easiest way to do this is to logon to your admin panel, go to the Webspace Explorer, right-click on the directory and select ‘zip’.

You can then right-click on the zip file and choose download to copy it down to your computer.

4. Verify the data

I verified that the exported SQL data, XLM and .zip files were valid. The easiest way to verify the SQL and XLM data is to look at it in a text viewer such as NoteTab Light and make sure that the data at the end of the file is valid. Sometime a download can silently fail and you can end up with truncated data. If you try to restore the data from a truncated file then the restore will fail.

Verify the .gz file by making sure it will open in 7-Zip.

Click on the upgrade button

I finally was ready to click on the upgrade button. I clicked on it and a second or two later I got the message:

‘The update cannot be installed because WordPress 2.9 requires MySQL version 4.1.2 or higher. You are running version 4.0.27’

How I got around it

The partial answer is contained in the post here. However I’ll add a few bits of information on what I did differently.

I created a new MySQL 5.0 database from the MySQL admin panel. On the 1and1 business hosting package I think you can create two MySQL databases so you don’t need to delete the existing one first. Don’t delete it – you may need it if everything goes wrong with the upgrade!

I didn’t import the data by using the XML backup. I imported the data into the new MySQL 5.0 database from the gzipped SQL archive that I’d created in step 1 above.

You can import the SQL data from the MySQL admin panel by going to the tab to execute SQL commands, and then selecting the .gz file. Importing the SQL file through a .gz file gets around the 2MB size limit in the MySQL admin panel.

Importing from the .gz file rather than the .XML will import all your database data, and plugin settings, whereas if you do it from the .XML file you may have to manually re-enter various settings into your blog.

In your wp-config.php you will have to ensure that the DB_NAME, DB_USER, DB_PASSWORD and DB_HOST have been updated with the settings of your new MySQL 5.0 database.

Upload the wp-config.php file and if everything has gone right your blog should still be working and look exactly the same as before. Your blog will be using the old version of WordPress but will be accessing the data from the new MySQL 5.0 database.

You should now be able to click on the upgrade button and the blog should upgrade in less than 5 seconds.

This worked fine for me on 1and1. If you have loads of plugins or a heavily customised theme you may find more problems. If this is the case you can try deactivating plugins, or switch to the default theme.

If you really can’t get things to work you should be able to roll back to your pre-2.9 WordPress blog by restoring the files that you zipped in step 3 above. You MySQL 4.0 database should still be there (as long as you didn’t delete it).

Upgrading WordPress can often be a pain but at least having upgraded the SQL database from 4.0 to 5.0 should avoid more problems in the future. And now with WordPress 2.9 you can look forward to batch updating your plugins rather than doing them one at a time!

Upgrading Samsung N140 RAM to 2GB

Tuesday, December 22nd, 2009

The Samsung N140 netbook – as reviewed here, is a great machine – but it is much better if you upgrade the 1GB RAM that it ships with to 2GB. Here’s a quick guide, with photos, of how I upgraded the memory of mine.

First you’ll need to buy a 2GB RAM module – they aren’t expensive and you can buy them from computer shops or online. You need to be careful to make sure you get the right type. You’ll need a 2GB DDR2 SDRAM at 800 MHz such as this 2GB RAM module from Amazon.

Make sure you back up any important work first in case it all goes wrong. If you manage to fry your original memory module and the new memory module then you won’t be able to boot up the N140!

Shut down computer fully – don’t hibernate or put it on standby otherwise it may get confused by the extra RAM when it wakes up.

Remove the battery.

Touch a radiator or other earthed object to get rid of any static charge that is in your body. If you have one then wear a static strap that is connected to an earthed object. Static is one of the big killers of RAM so be careful!

Remove the screw on the memory cover on the base of the N140. Then you’ll have to pull the cover off – I had to apply a bit of force to get it to open.

samsung n140 underneath memory

Pull the clips outwards and the old RAM should click up.

samsung n140 memory slot 2

Remove the old RAM.

Carefully insert the new RAM into the socket and make sure it clicks back down into place.

samsung n140 memory slot

Put the memory cover back on, re-insert the battery and turn on.

Hold your breath! Hopefully it works and you should see 2GB (or more probably 1.99GB) listed in the System Properties page. You can hold the Start key, Fn key and Pause/Brk to bring up the System Properties page. If it doesn’t then re-open the memory cover and make sure that the memory is correctly plugged in.

Keep the old memory safe – in case of emergency you can always plug the old memory back in.

Takamatsu Japan, what to do there

Monday, December 21st, 2009

Takamatsu is not a city that many people think of when visiting Japan, but it is the city that I happened to find myself in for a short while.

It is in the Kagawa prefecture of Shikoku Island. Shikoku is the smallest of the four main islands that make up Japan and is positioned south west of Osaka. Shikoku Island is most famous for its 88-temple pilgrimage. It is joined to the mainland by a number of bridges, including the Seto Ohashi Bridge, one of the longest in the world.

Takamatsu is situated on the North side of the Island and has a harbour area that faces into the Seto Inland Sea. The city has a population of around 400,000. It has a large shopping, restaurant, and nightlife area.

Ritsurin Park

Ritsurin Park is a 75-hectare park of 6 ponds and 13 small hills that has been designated as a “national place of special scenic beauty”.

ritsurin park takamatsu

Inside the landscaped park are a huge variety of plants, trees and flowers. Pick up a map and it will show you a few suggested walking routes.

The park faces Mt. Shiun which makes it easy to get your bearings. Look out for the famous view of Bairin-kyo Bridge. You’ll also find plenty of colourful Koi fish in the large interconnected ponds and lakes.

If you have more time there is a tea house where you can be served Japanese green tea (there is an extra charge for this).

Takamatsu Castle / Tamamo Park

Takamatsu’s castle, properly called Tamamo Castle is located near the harbour area of Takamatsu. It is one of the “three water castles” of Japan, taking its moat water from the Seto Inland Sea.

tamamo castle takamatsu

The castle is nice, but you will find more impressive castles elsewhere in Japan. However you should still go here to have a look, and have a walk through the Tamamo Park grounds.

If you are in Takamatsu in during late October / beginning November then Tamamo Park is the location for a festival of chrysanthemum flowers. You may also find Bonsai trees on display.

Covered shopping streets

The main shopping area of Takamatsu consists of a number of covered shopping streets. Take a walk along Tamachi, Minamishinmachi, Marugamemachi, Kataharamachi, Hyogomachi, Lion-Dori and Tokiwamachi. You’ll find hundreds of shops and many restaurants.

There are clothing shops, household goods, Udon restaurants, book shops, souvenir shops and more. This is an especially good place to shop if it is raining as you can get across large areas of the city without being too exposed to the elements.

Harbour and Sunport area

Takamatsu is a harbour city and the relatively new Sunport area has been built to show it off.

takamatsu harbour sunport and lighthouse

Go to the observation deck of the Sunport building and you’ll be able to see across the Seto Inland Sea. In the Sunport Tower building you’ll also find some good restaurants, coffee shops, clothes shops, and more.

Have a walk along the harbour area and you can see the regular passenger and car ferries sailing to and from the harbour. It is worth taking a walk along the harbour promenade to the red lighthouse, which sits on at the end of a long pier.

seto inland sea takamatsu

From the harbour area you can get a ferry to one of the many islands that are close by such as Naoshima, Shodoshima, Megishima and Ogishima.

Naoshima Island

Naoshima can be reached by ferry in less than an hour from Takamatsu port. Once there you should get a bus to the Art House Project and buy a ticket which will allow you to look at art installations which have been placed in a number of old Japanese buildings.

There is also a very small James Bond museum on the Island if you are a fan.

naoshima island

Shodoshima Island

Less than an hour be ferry will get you to Shodoshima Island. I’d recommend going to the Kankakei Mountain where you can either get a cable car or walk to the top. Once at the top there are viewing areas, food, shops, and more walking paths.

shodoshima kankakei mountain

Yashima flat top mountain

A short Kotoden train journey from Kawaramachi station will get you to the base of the Yashima flat top mountain. From there you can either walk up or get the bus. On the top you will find an aquarium with many types of fish, as well as a dolphin and sea lion show. There is also a great view across the Takamatsu harbour to see, and a temple – one of the 88.

yashima flat top mountain takamatsu

There are other attractions around Yashima as well such as the folk museum and a number of shrines.

Hill walking

Takamatsu is surrounded by hills. Some of them are easy to walk up. Mount Inari is in easy walking distance from the town centre. The nearest station is Ritsurin Koen Kitaguchi. The walking paths aren’t very visibly marked. The best thing to do is to walk around the hill until you find the path. I found a path entrance on the North side of Mount Inari.

Walking up took about two hours as I took some wrong turns – the route is not very visible so a bit of trial and error may be needed. Once at the top you get a small view of parts of the city – note that there are many trees at the top obscuring your view so go up for the fun of the walk – not the view.

mount inari takamatsu

You might want to note that there were very few other people in the area so if you have an accident you’ll be in trouble! And as the hill is covered in tall trees no one will see you. I’d suggest you don’t do a walk like this alone – and make sure you do it on a dry day as some of the paths can be slippy.

Other hills and mountains in the area are likely to be walkable if you do a bit of exploring. Certainly a walk up Mount Yashima will give you a great view of the Takamatsu harbour.

88 temple pilgrimage

Shikoku Island is famous for its 88 temple pilgrimage. The temples are scattered all over Shikoku Island, however quite a number of them are in easy reach of Takamatsu. If you go to look at any of them keep a look out for the pilgrims who will be dressed in white.

nagaoji temple

Kotohira – 1400 steps

Take the Kotoden train to Kotohira station and you will be able to see one of the most famous Shinto shrines in the country. To reach the main shrine you will have to climb 785 steps up Mt. Zozusan. Another 583 steps will take you as high as you are allowed to go.

Along the way you’ll pass a number of shops, shrines and statues. There’s a great view from the top.

Travelling around Takamatsu

Takamatsu is very easy to get around. The town centre and Sunport areas close together. Walking is the most convenient way to get around the centre. There is a local Kotoden tram network that will take you further outside of Takamatsu. Takamatsu mainline train station will allow you to get trains around Shikoku and also onto the main Japan Island. Taking a JR train over the Seto Ohashi Bridge to Okayama will give you great views of the Seto Sea.

If you are likely to be using the local trams frequently (along with the Kotoden local busses) then it may be worth getting an IruCa card. The IruCa card is a smart card that you ‘charge up’ with credit. You can then use the Kotoden tram and Kotoden busses without needing cash.

On the trams you’ll need to swipe your card over the scanner at the start and end of your journey. At larger stations such as Kawaramachi there are ticket barriers to make sure you do this. At smaller stations such as Hanozono there are IruCa readers on the platform. When you leave the train the train’s ticket inspector will watch you to make sure you swipe out!

On the Kotoden busses you’ll need to enter by the door in the middle of the bus. You’ll then have to touch the IruCa reader by the door with your card. When you exit through the front door of the bus you’ll have to touch the card on IruCa reader at the front of the bus.

iruca card takamatsu

You can also use the IruCa card to pay for items in some shops and for items in some vending machines displaying the IruCa logo.

Takamatsu long stay information

If you are staying in Takamatsu for longer than a normal holiday then there are a number of useful places, and organisations that can make your life easier.

Takamatsu if home to Kagawa’s International Exchange Centre, also know as the I-PAL Centre. Here you can do Japanese classes very cheaply, get access to foreign magazines and newspapers, and take part in their Japanese language salon where you can practice your Japanese with local residents. They also can offer interpreter and legal help if you need it.

If you don’t have your own internet access then you should check out e-topia in the Sunport Tower. Here you can use their computers for surfing the web (you just need to fill in a quick form to do this), or if you have your own laptop you can sign up for their secure WPA2 encrypted WiFi access. You might need to take a Japanese speaker with you in order to be able to get through the sign up process.

Alternatively there is an internet connected computer in the library in the I-PAL Centre (they have WiFi too), and you will find free WiFi access near the North end of the covered shopping arcade.

If you are looking to meet new people then you should join the newly formed Kagawa Foreigners United Network (K-FUN) who are organising events in the Kagawa area.

For practical information on living in the Kagawa prefecture have a look at the International Affairs Division website.