Narrative Disorder… in Japan!

NB.. For those of you who have stumbled on this page looking for directions and aren’t interested in a review of the shopping district of Osu Kannon (to wit: is it really the best place to go for cameras et al.) - scroll down to a little above where the photos begin.

Okay, I’m not actually accusing any person or persons of deliberately spreading propaganda but false impressions have definitely been made. If at any time during your stay in Nagoya, however short or long that may be, you happen to ask anyone where the best place to buy [insert anything at all except fresh food and furniture] you will no doubt be given the same answer: Osu Kannon.  In fact, one of Superman’s colleagues during his orientation day asked where he could buy a camera and was either sent or taken to Osu to do that that very day. When I was planning the purchase of my new camera I was given the same answer "Osu Kannon" however, in every case, that is where the specific advice ends.

Follow up question: Oh? What shops should I go to?

Answer: Any of them, there’s heaps.

FUQ the second: Is it cheaper?

Answer: Yeah. (Now, no Japanese person would actually say "yeah" but I’m trying to get across the non committal nature of any further statements about Osu.)

FUQ the third: How do I get there?

Answer: Osu Kannon station - you’ll see it.

This vagueness isn’t limited to humans in the real world either, NOONE and I am including the ENTIRE INTERNET AND IT’S COMMUNITY could give me a specific place to go (as in which shop to go to for a camera or even for electronic goods) or even how to get to this plethora of shops. The best I could do was that it was near the temple but the general idea was that the shopping area was easy to find. The truth is if you aren’t with a local and you aren’t that interested in temples, or are hell bent on finding this easy-to-find-thing and so don’t have time for temples - you won’t find it easily at all. So, before I continue with my review here is the thing I couldn’t find anywhere on the net:

PRECISE, ILLUSTRATED DIRECTIONS TO OSU KANNON SHOPPING DISTRICT FROM NAGOYA STATION

1. Take the Higashiyama Line (the yellow one on the maps) going towards Fujigaoka (not Takabata) and get off at the next stop which is Fushimi - if you hit Sakae you’ve gone too far.

2. At Fushimi follow the signs from the platform to transfer to the Tsuramai line (the light blue one on the maps)  and get on a train on the side that says "to Toyotashi" (not Kami Otai) I say "on the side that says" because the trains will have various destinations on them including Toyotashi because it is a line which goes beyond the subway system(Toyotashi is the Toyota station). You can get on any of the trains on the Toyotashi side except one that is express or limited express or the like.

3. Take the Tsurumai line train one stop to Osu Kannon.

4. At Osu Kannon, exit by exit 2 (if you haven’t worked out the extreme importance of station exits in Nagoya for both locating places and avoiding the extreme weather well, now you know.)

5. Upon reaching street level and not being able to see anything that looks particularly like what you were expecting, walk forward for about 10 metres, if that,  (you’ll be on the left side of the road from your point of view) till you come to the first corner - it has a konbini (convenience store) on it and, when looking slightly to your left, gives you this view:

 

6. If it is hot I heartily recommend you go into the konbini which is ooc to the left of this shot and get yourself a large bottle of drink to take with you on the journey that awaits you.

 

7. Walk down the road in the picture and go through the gate as in the picture below. I can actually see the very edge of the entrance to the shopping area in this photo but I bet you can’t!

 

8. After passing through the gate, take a moment to enjoy the view and be reminded that you really, really are in Japan and it really, really has places just like in the pictures! Also note the lady in the bottom left of the picture has a parasol - if you are coming to Nagoya in the summer buy one when you get here and use it - no matter how silly you feel. My scalp was sunburned while taking these shots and I was in the sun for all of 5 minutes!

 

9. After you have or have not been inside the temple (there’s a free handout with history on it in English inside and the woodwork inside is beautiful but I’m not one for taking photos inside sacred places, sorry) follow the pale concrete path past the temple and you will see this at the end:

 

 

 

10. Welcome to Osu covered shopping district! See? You’re not silly if you couldn’t easily find it from the station! Under the soaring roof you will see lots of shops, some tiny and shallow some double-fronted and deep and lots and lots of people! Not that all of Osu is undercover, many cross streets are not and so there is plenty of light and fresh air (I don’t think it’s actually air conditioned at all.)

 

It really is very nice IF it’s not too hot and IF you’re not "on a mission" to find something specific and get home and out of the heat again. In one cross street we found the Fuji Sengen Shrine which dates back to 1495…

 

 

 

…but is made minute next to the shrine to commerce!

 

 

While I said you can’t get everything you can get a large variety of things though sometimes you have to look hard - is this a gun shop in low-violence Japan?

 

 

 

Actually no - it’s a bike and scooter shop - of course.

And if your aquarium needs stocking…

… not much of a range but at least you can officially include fish in the list of the "Everything" Osu Kannon has and it was certainly unexpected!

Below is the biggest electronics store we found though there are a few small ones less easy to see as you push your way through the throng (which doesn’t look that much of a throng at this point in time.

 

Cleverer shrines than the poor little Fuji Sengen know how to keep themselves relevant… get themselves swept up in the crowds!

Yes, that is a shrine! On the right of the above shot there are tables which were set up with things for kids to do though whether this had anything to do with the shrine I don’t know. Still, despite the better traffic flow, not many people were paying any attention to the shrine itself and just whizzed by - though maybe that’s because its guardians had their bibs on for lunch and looked hungry!

 

THE REVIEW - IS OSU KANNON THE BEST PLACE TO BUY ELECTRONICS OR, INDEED, ANYTHING?

After having spent two days schlepping round Nagoya looking for the best prices on the specific camera I wanted as well as looking at pricing on denshi jisho (electronic dictionaries) AND the Wii, I am confident in saying that the thing about Osu Kannon is:

It is NOT cheaper and it does NOT have everything. It’s a myth.

In fact, the range at all the electronics shops (once we found them) is remarkably limited in comparison to the large stores and the prices are no better than anywhere else in the city. I’m sure that if Japanese prices are better than in your home country and Osu is the first place you go to shop you would remember it fondly as  a place for a bargain but it is an illusion.

Specifically on the things we were comparing:

We found the Wii in all but one shop to be 25,000 yen just as it was at Bic Camera and Eiden and 113 yen more expensive than our Tsuyata down the road in the one shop where it was different it was 24,700 - 87 yen cheaper than Tsuyata.

I wasn’t able to find any DSLRs that weren’t Canon or Nikon and they were the same price as Bic Camera (though a Nikon D80 was 10,000 more expensive than Top Camera in Sakae) - digital cameras were mostly just Canon but I have no idea about them since I wasn’t in the market - I have a feeling anything truly commercial might be cheaper because they might buy it in bulk since they don’t feel the need to supply different colours or styles of everything as other stores do. Though, of course, you can’t get much more commercial than the Wii at the moment!

Denshi Jisho were much more expensive on their tickets (by up to 7,000yen compared with Bic Camera which is a lot for something which costs around 40,000yen)  but the "discount" when you enquired (which many shops do and is the closest you’ll get to haggling in Japan) brought them down to Bic Camera prices - and they didn’t have the range that Bic Camera has (I couldn’t have got the model I wanted in pink for example )

So, why is everyone sent there? Superman asked at work after our Osu experience and was, frustratingly, given the answer that it’s one of those "you have to know where to go" places. To that my responses are a) fair enough but that means that what is being advertised to tourists is not accessible to non-locals and so it still should not have the profile it does among tourists and b) AARGH!! If you (whoever it was, I don’t actually know so it’s not personal but I know Superman was asking for days and I asked at a department dinner) knew that and you know which are those stores to go to why did you not tell one of us when we asked outright????? To which, of course, the answer is: the Japanese don’t give straight answers … sigh.

I have my own, kinder theory though and it means ignoring the issues of range and price which are what are likely at the top of a westerner’s mind when they ask "Where’s the best place to buy [insert product]?"

I think, and I may be wrong of course, that they think that it’s the most entertaining place for a non-local to go. With very best intentions they are sending us to somewhere where we certainly won’t get ripped off but which will be an experience we would not have where we live (and lets face it if you have that sort of money you live where you can "experience" a mall any time.) I think they want to show off the city and give us a good time here and Osu Kannon is definitely, infinitely more interesting than a mall - you just have to be in the right state of mind.

CONCLUSION

If you are looking to buy a very particular thing and you want to be able to get in, find out the price and get out again if it’s not lower than the other places you’ve tried - this is not the place - it will drive you INSANE. If, however, you are the kind of person that considers "Shopping" a noun (which, at least grammatically, all Japanese do) and you enjoy spending hours wandering about among throngs of people in what is definitely a tourist-worthy spot rather than an air-conditioned, light-conditioned, character-less mall then it is probably an excellent place for you.  It certainly looks like a giant market with cleaner, more professional stores rather than stalls - and it is - but that also means that the lack of overheads which allows market vendors to sell products more cheaply is missing and therefore so are the cheap prices. In fact, I’d bet the store owners are paying at least as much as anywhere else in the city, if not much more, for their position on this popular strip! You will be able to make all sorts of purchases from a $5 parasol to a $500 wallet or a $4000 entertainment system - but you will get the quality you pay for no more, no less.

For  me, though, the shopping experience in Osu Kannon misses what I find to be the key to the Japanese shopping experience. The truly Japanese experience is found in the larger stores where the range is bigger than anything you find in Australia or my limited experience of the States. Sure, in the States you can buy huge amounts of things but they don’t stock 37 different shades of the same felt tip pen, or give you the choice between plastic ties to tidy up your electrical cords or soft, velvety ones or Velcro ones with tiny soft animals on the end or computer mice which flip open transformer-style and become a Skype phone!  When it comes to electrical goods at Osu Kannon, IF you find the model you want you’re unlikely to get a choice of colour and they will only stock what ever everyone else is buying (except for those weird wild-west-style places selling oddly cumbersome and heavy things made out of thick, poor quality leather which I just can’t imagine would have much of a market) - and the prices don’t make up for the lack of that experience. If you are the kind of shopper that wants a bargain, get your camera/denshi jisho/whatever elsewhere and go to Osu when the heat is low and the day cloudy and you are in a lazy, wandering mood.

 

Note: My days of looking for the best price on the Pentax K20D and the Tamron 18-250mm with Macro lens took me to Top Camera in Sakae - they had the Pentax body for 20,000yen cheaper than anywhere else and the lens was also a little cheaper than Bic Camera (which was the only other place I could find that particularly new, 3rd party lens) Their prices on all the other camera bodies were also substantially cheaper except for the Olympus E520 which was cheapest at Asahido Camera. For kit lens bundles they were pretty good though some bundles were cheaper at other places  and Bic Camera had the biggest range of lenses. Top Camera Sakae is super easy to find - take exit 6 at Sakae station (Higashiyama or Meijo lines) and literally pivot to your right as you reach street level - minimal time in Nagoya’s extreme weather.

 

but ain’t they cute!!

I spend a fair bit of my days listening to Radio National podcasts while pottering around cooking or doing housework so the speakers on my PC are often quite high so I can hear it over both the distance and the noise of cooking or chopping or the dishwasher chugging away. I often worry that I drive my neighbours mad (though I’m sure they’d have said something by now, and I never hear a peep from their side) so clearly I NEED to spend $1000 US on this baby… hehe

The MIURO (Music Innovation Utility Robot) connects wirelessly to your PC, or you can plug an ipod into the top of it, and FOLLOWS YOU AROUND (avoiding obstacles itself)  adjusting its position to give you optimal listening pleasure!! You can pause it by qiving it a quick pat on the head, or FF or REW by patting it either on the left or the right respectively and you make it follow you by letting your hand linger lovingly on its head till it smiles! hehe

Here’s a demo video - it’s in Japanese but it’s fairly clear ^_^

I wanted  to be able to blog happily from Japan during our orientation week and to keep in touch without the fuss of mobile phone “roaming” issues so I pulled out my old tablet PC and have spent the last couple of days giving it a good tune-up.  I bought my tablet back in 2003, giving in to my gadget-girl proclivities and going for the first generation of these marvelous machines. I loved the idea of being able to handwrite my fiction and have no need  for typing it out later. When I was first shown the tablet, the salesman showed my the input panel which could be either an on-screen keyboard which could be pecked at or a space into which one could hand write. I was disappointed - the panel could be docked either at the top of the screen, which meant that one’s hand, wrist & forearm covered any document into which you were trying to write, or it could be docked at the bottom -where there is nowhere to rest your hand and which quickly causes cramping. So the savvy salesman showed me the “write anywhere” feature. I fell in love. One could open up any application and write anywhere on the screen and it had no trouble converting even my odd, psuedo-copperplate handwriting and inserting it as type at the cursor. You could rest your hand wherever it was comfy on the screen so writing without being at a desk was easy. I loved my tablet.

Then came Service Pack 2 and it’s little parasite Windows XP for Tablet PC 2005. In their “wisdom” Microsoft decided to removed the “write anywhere” feature. They replaced it with a small button which would appear under your tablet pen when you hovered it over a cursor for an annoyingly long moment (and only in certain compatible applications). Once the damn thing appeared, you had to tap it to open up a smaller input panel under your hand- seemingly a good replacement accept that the thing disappeared if you lifted your pen too far from the screen or paused for a moment to think.  No number of complaints on the forums could prompt from Microsoft even an acknowledgement that the new feature was not for at least some a satisfactory replacement (to put it politely.)So, my tablet became a $4000 laptop with a 12nd screen and none of the features that that hind of money would get, like an onboard disc-drive let alone a DVD player.  I hooked it up to a full-sized keyboard & mouse and made good use of it, but it wasn’t my dear tablet anymore.

So now I have a  need for a portable computer again, I figured I’d see what the state of play is now. After  literally  hours of updates it seems that very little has changed. The annoying floaty thing is not quite so delicate and stays around long enough to get a good run up an a thought but it still only applies to some applications (this one excluded, I’m afraid) and there is still no return of the original beloved feature. Microsoft, it seems, is  happy for a company called  Evernote to make a fortune providing a plug-in which provides the “write anywhere” feature for which we really should not need to pay. However, as I  hand write this post  on my tablet, on my knee in front of the tv, switching the input panel from the  lower dock to the upper as my hand begins to  cramp, then back again as it becomes too annoying glancing down and having to move my hand to check the conversion every few words - I will no doubt succumb at some point.  Frankly, beyond the satisfaction and creative flow  that handwriting provides, the idea of “populating” my blog’s database, and in  turn the “series of tubes”, in longhand is just too delicious.

Last night I was up till 5a.m. getting the final step of my blog upgrade done - moving it to its own domain (see that up there? www.narrativedisorder.com ? that was HARD, that was lol). I’m not deluded that many people read it or that there was an urgency at all but it was a new challenge damn it! And it was one of those thing where you are just holding on to all the new info and if you stop before it all coalesces into sense you’ll never understand it!

In the end it actually wasn’t that hard but since I spent 7 hours and what felt like a large amount of our download limit attempting at least 6 different variations on "how to" guides, first from wordpress.org then from desperate google searches, and finding each one to be incompatible with my own hosting situation in someway or missing or assuming a vital element or understanding here or there, (deep breath) I figured I’d do my bit to help other people like me (with more courage than knowledge OR sense) and give you the "How to" I would have liked to find last night. Maybe it will help someone. If you read through this and feel trepidation about following the first few steps then you should probably either leave things as they are or get yourself a blog host who can do everything for you. After all, this is very similar to upgrading to another wordpress version which will need to be done at least every couple of years so you probably need someone else to do it for you.

Important note: my new domain is registered under and hosted under the same plan as my other domains and so the databases were going to be on the same server - I have no idea how that effects things but I’m assuming it has some effect (THAT’s what a newbie I am to this stuff - I probably shouldn’t have a self-hosted worpress but I love working this stuff out hehe)

The process is divided into the following sections (as soon as I wrestle out how to make these anchors for jump-to links I will ):

BACKING UP YOUR CURRENT WORDPRESS DATABASE
BACKING UP YOUR CURRENT WORDPRESS FILES
CREATING AND CONFIGURING YOUR NEW DATABASE
CREATING AND CONFIGURING YOUR BLOG ON YOUR NEW DOMAIN
NEARLY THERE - A FEW LAST, IMPORTANT THINGS

 

HOW TO:

1) FIRST BACK UP YOUR FILES AND DATABASE - I CANNOT STRESS ENOUGH HOW IMPORT THIS IS!

If you are confident with backing up our database and files then skip to NOW TO YOUR NEW SITE

"Back-up" is simply jargon for making a copy of your files as they are at a certain time so that if you try to change something and it doesn’t work out you can return the files to the state they were in before you mucked around (or the server crashed or was infected or whatever) If this "how to" doesn’t work you will need these files to return your blog to the state it is in now - you should be doing this regularly anyway but I know I only learned how to do it recently and a lot of people don’t so, no judgement or assumed knowledge, here’s how to do it:

note: these instructions are for phpMyAdmin which is what many hosts will give you to work with - if it’s something else then find out what is right for you.

Remember there are 2 things to back up - your files (wp_content/themes etc…) and your Database

1. On your computer, make yourself a folder in which you will store your backups - put it anywhere you like which fits your organization (mine I put mine in the same place I keep all my blog back-ups and named it "blogmovefiles" to isolate it but if you need to put it on your desktop to make it clearer to you then do that)
2. Login to phpmyadmin of your old blog database in whichever way your host gives you (if this scares you or can’t work out how to do it from FAQs provided by your host, seriously consider getting a non-self-hosted blog)
3. You will see tabs across the top of the page (looking like a really poor old fashioned web page lol) but first look at the column on the left and find your database name (it will be in the left panel and won’t look like a button or a link - just text and will have an alphanumeric name which won’t necessarily make any sense to you) - click this and you should see your DB tables come up in the main window with check boxes beside them.
4. Click the "check all" link underneath your tables
5. Click the export tab
6. Click the Structure and Data radio button
7. Click "Save as file"
8. Click "Go"
9. You will see a "browse" window - click it and find where you want to save (just like you would to save any file you are downloading to disk) and click "Save"

When the download is complete - you have backed up your DB! Close the window phpMyAdmin is in.

 

The files are probably more familiar to you - these are the files which sit in the directory to which IE or Firefox point and they tell the browsers how to layout the page and how to communicate with the database you just backed up etc… If you have ever uploaded a theme to use on your blog (without using some plugin to do it) then you have seen your file director.

There are a couple of ways to do this: using an ftp application like filezilla or using whatever file management application your host provides you (my host has quite a good web-based application but I am used to ftp from the command line days so I prefer to use filezilla)

1. Login in to your current blog ftp site either using your ftp application or your hosts web-application
2. If you are using filezilla or similar ftp app: click through the local folder tree to open the file into which you are going to store these files - giving it a file next to your database back up is a good idea.
3. Click your way through the file structure on your site till you find your current blog folders and files (in other words to the directory which is also your blog address) highlight all the folders and files in that directory

If you are using your hosts file management system no doubt there will be an option to copy whichever checked or highlighted files and you will be given "save to disk" option withthe usual "browse" function to choose where to save - but you will have to work that out for yourself -this will start them copying form your site to your computer

4. If you are using filezilla simply drag the highlighted files and folders to the open folder on the left panel and wait for the files to flicker through the queue until it is done

Whichever method you are using, this will take quite some time so grab a cuppa and watch a video or occupy yourself somehow while it happens - but be around in case any errors pop up (which they shouldn’t)

Note that most ftp servers have a time-out limit which will be much shorter than the time it will take to do this. If you are using filezilla the right hand panel in which you could click through to your website (the remote host) will go blank but for a message saying that you are no longer connected to the site when the time-out limit is reached. You will notice, though, that the queue will keep flickering - this is because it will be in "passive mode" which basically means that it will keep going connecting and reconnecting by itself till it is done but you won’t be able to view your files. Don’t do anything, don’t try  to reconnect just wait for it to do its thing.

5. When it says it is done - verify all the files have been uploaded by comparing it to the local files and folders in your backup folder

When the queue is finished - congratulations! You have backed up your files!!

NOW TO YOUR NEW SITE

2) Create a new, blank database on your server - your host should give you a way of doing this and I am not going to give any advice just follow their instructions - with my host it is literally a one click process. IMPORTANT NOTE DOWN THE DATABASE NAME, THE NEW ADMIN USER NAME THEY PROVIDE AND THE PASSWORD These will all be odd alphanumeric things which should be easy to locate or at the least should also be sent to you via email when you create the database. The best way to note this down is to copy and paste into a text file you can easily access, say on your desktop - or make sure you know where your email is - you will need this information at the end.

3) Configure and populate your new database in one go! Essentially all you need to do is import the .sql file which you exported from your old database. Here’s how to do it with phpMyAdmin (you will have to work out anything else yourself):

1. Login to phpMyAdmin on your new database
2. Just as before, click the database name on the top left
3. Click either the Import tab or the SQL tab if there is no Import tab (I assume this is a variance between version of phpMyAdmin)
4. Find the "browse" button and click and navigate to your backup .sql file
5. Click "go"
6. When it’s finished, click the "structure" tab and you will see that your new database now looks like your old one did

4) Update your new database with your new domain info - the following instructions are essentially how to do find and replace function via SQL - don’t panic just follow the instructions carefully

1. Still in phpMyAdmin, click the "SQL" tab
2. You will see a largish blank box with something like "Run SQL query/queries on database <your db name>"  above it
3. Into the blank box copy and paste all of the following: 
   UPDATE wp_options SET option_value = replace(option_value, ‘ http://www.old-name.com’, ‘http://www.new-name.com’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;

4.  Once you have pasted it in, replace http://www.old-name.com with your old web address (include /blog or /wordpress if necessary) - making sure to leave the apostrophes around it and similarly with http://www.new-name.com with your new blog address.

5.  Double check you have got all your spelling exactly right then click "go"

6.  You should get a nice confirmation message - IF you get a long wall of text with the word error scattered through don’t panic, just click the "back" button at the bottom and double check your spelling etc… of the old and new addresses and try again

7.  Once you get your confirmation message, highlight everything you pasted into the blank box and delete it so that it is blank again - you now need to do the same thing another two times with slightly different commands:

8.   Into the blank box copy and paste all of the following: 
UPDATE wp_posts SET guid = replace(guid, ‘http://www.old-name.com’, ‘http://www.new-name.com’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;

9.  Again, replace http://www.old-name.com with your old web address (include /blog or /wordpress if necessary) - making sure to leave the apostrophes around it and similarly with http://www.new-name.com with your new blog address.

10. Double check you have got all your spelling exactly right then click "go"

11. Once you get your confirmation message, highlight everything you pasted into the blank box and delete it so that it is blank again - now for the last one!

12. Into the blank box copy and paste all of the following:  
UPDATE wp_posts SET post_content = replace(post_content, ‘http://www.old-name.com’, ‘http://www.new-name.com’) WHERE option_name = ‘home’ OR option_name = ’siteurl’;

13. Again, replace http://www.old-name.com with your old web address (include /blog or /wordpress if necessary) - making sure to leave the apostrophes around it and similarly with http://www.new-name.com with your new blog address.

14. Double check you have got all your spelling exactly right then click "go"

15. Once you have that final confirmation - well done, you have now changed your blog address in your database!

DO NOT TRY TO TEST YOUR SITE YET

Now, what do with those file backups

1. CREATE AND CONFIGURE YOUR BLOG ON YOUR NEW DOMAIN
2. Essentially this is your wordpress install and it’s really easy
3. Login to your ftp site using your ftp application (like filezilla) or whatever your host provides you with to upload multiple files in such a way that you maintain directory structure (this is why I prefer to use an ftp application - it’s so easy!)
4. In your remote host panel (right frame in filezilla and most other ftp applications) click through to the directory which you just typed in when you replaced http://www.new-name.com in the SQL process (DO NOT CHANGE YOUR MIND NOW lol)
5. In your local host panel (left frame in filezilla and most other ftp applications) find your backed up files and highlight them all, files, folders, the lot
6. Drag the files from your computer (the local host panel) to your site (the remote host panel)
7. Again you will need to find something to do while this uploads- it will probably take a little longer than your back-up took
8. When it says it is done - verify all the files have been uploaded by comparing it to the local files and folders in your backup folder
9. DO NOT TRY TO TEST YOUR SITE YET

 

NEARLY THERE - A FEW LAST, IMPORTANT THINGS

Easy things first:

1. Still in your ftp application, click your way to your new /wp_content/cache delete this folder then log out from your ftp site (you’ll be coming back but for now it’s safer to log out)
2. Open your web browser and delete your cache and cookies

Less easy thing now but critical.

What you now have is a lovely new database and a lovely new install of wordpress but they are not yet talking to each other.

1. The file that connects them is the wp-config.php file which is one of the files in the directory that is your wordpress address - this file needs to be changed
2. Find the database name, username and password which you noted down when you created your new database (if you didn’t note it down then go to your database administration panel which your host provides on your site control panel/dashboard and find it)
3. Now find the wp-config.php file in the back up you made and highlight and copy it.
4. Right click anywhere on your desktop and choose paste - you now have a copy isolated from your backup copy and safe to play with
5. Now, open this file in notepad (double clicking should do this but if you are prompted to choose a file to open it in then choose notepad) Inside it should look something like this:

<?php
// ** MySQL settings ** //
define(’DB_NAME’, ‘d1234567′);    // The name of the database
define(’DB_USER’, ‘u12345678′);     // Your MySQL username
define(’DB_PASSWORD’, ‘abc1234′); // …and password
define(’DB_HOST’, ‘MYSQLHOST’);    // 99% chance you won’t need to change this value
define(’DB_CHARSET’, ‘utf8′);
define(’DB_COLLATE’, ”);

// Change SECRET_KEY to a unique phrase.  You won’t have to remember it later,
// so make it long and complicated.  You can visit https://www.grc.com/passwords.htm
// to get a phrase generated for you, or just make something up.
define(’SECRET_KEY’, ‘letmein’); // Change this to a unique phrase.

// You can have multiple installations in one database if you give each a unique prefix
$table_prefix  = ‘wp_’;   // Only numbers, letters, and underscores please!

// Change this to localize WordPress.  A corresponding MO file for the
// chosen language must be installed to wp-content/languages.
// For example, install de.mo to wp-content/languages and set WPLANG to ‘de’
// to enable German language support.
define (’WPLANG’, ”);

/* That’s all, stop editing! Happy blogging. */

define(’ABSPATH’, dirname(__FILE__).’/');
require_once(ABSPATH.’wp-settings.php’);
?>

6.   Very carefully without touching or moving anything else, change the following:

In:
define(’DB_NAME’, ‘d1234567′);    // The name of the database

change d1234567 to your new database name

In:
define(’DB_USER’, ‘u12345678′);     // Your MySQL username

change: u12345678 to your new database admin user name

In:
define(’DB_PASSWORD’, ‘abc1234′); // …and password

change: abc1234 to your new database admin password

7.   Save the file

8.   Now log back in to your ftp site using either filezilla or the file management facility provided by your host

9.   In the local host panel navigate to your desktop and find the wp-config.php file.

10.  Drag the file over to the wordpress directory - the file will begin to copy and you should get a confirmation dialogue asking if you want to over write the old wp-config.php file - select over-write and click ok (if you do not get this then you have uploaded it to the wrong place - simply find where you put it, delete it and try again)

11.   Log out of your ftp site

 

NOW you can go to your new blog address and test that everything works!

You will not have a cookie for logging in to that address so you will have to log in again - if you have forgotten your password simply use the "forgotten password" link and it will be sent to you.

Wow that’s a long post and it’s a long process but not actually hard and I’m pretty sure I’ve covered everything. Again, if you read through this and don’t feel that you can at least follow along then you should probably either leave things as they are or get yourself a blog host who can do everything for you.

 

GOOD LUCK!!!

Err… wow. I almost hate to admit it, since I always prefer open source if I can get something suited to my technical ability (i.e., I’m not brave enough to go linux), but I am seriously impressed. Windows Live Writer may not have a flash Flash upload media gui but it has something better - it does exactly the same thing simply (and without the flaws). With the same process as you’d use to insert a picture into a word processing file it uploads right into your blog server using the default path and name structure in the settings on your WP dashboard. It is UTTERLY compatible and takes no more configuration than inputting the blog URL.

Writing in this window is definitely much more enjoyable than using the dashboard to write a post. I can insert more media more easily than I can on the dashboard, my categories have been imported into Writer so no need to reenter them as I was concerned I would.

I can control my layout more (see how this is an indented block quote? All I did was hit tab at the beginning of this sentence!) and use all the usual keyboard shortcuts for editing and formatting and all with the added bonus of my lovely cherry blossom graphic on the wysiwyg page - of course that’s not quite as it would appear on the blog but it feels more customized who doesn’t like that?

If you aren’t quite ready to publish, you can store drafts either to your blog admin and/or locally (which means you can keep blogging your “where is my adsl!!” rants offline when moving or having ISP issues hehe) You can also Open any already published post or page right from WLWriter and edit it then simply click publish to update your changes.

If you need to manage your blog outside of the writing process there is a simple link to the right of the writing window which takes you to your dashboard underneath a “view site” link. A button with a speech bubble icon (which looks as though it may light up when there are comments to manage) which takes you directly to the comment page of your dashboard.

And there is plenty to keep you occupied, click the “Add a plug-in” button at the bottom of the insert list to the right of the editor frame and you have not only hours of potential procrastination but inspiration for the potential of your blog with many plug-ins to enhance your blogging experience. For example after I have finally published this I will be gong back to my Geisha of Gion review and testing a couple of plugins which allow you to link Amazon info to book images.  These plugins installed smoothly and easily just like any other application and required no ftp into my wordpress file on my netfirms server which would be beyond many bloggers. This also means that if you have more than one blog on different platforms, or wish to change platforms you do not need to find plugins to do the same job for each platform and install them and work out how to use them twice!

I’ll be testing this for a while to see if there aren’t glitches afterall but at the moment I’m pretty well sold (can you tell?) If you want to try it yourself you can find the download page or more information by clicking here

Oh and by the way, you can set it to remind you to add categories and tags before you publish hehe

Technorati Tags: Windows Live Writer,Blogging,Wordpress

Proud clutterbug that I am I am nevertheless spending today trying to get my digital world in check. I can handle cluttered physical spaces because my memory is physical (I know I reached over here when I put that down…) but I’m really having trouble with email at the moment. Which address to use when signing up to a forum or buying software (thus opening that address up to spam possibilities) and which to use as personal email or for reciepts via email…? Sigh. While doing this, or probably more truthfully while procrastination from the sheer mind-boggliness of the task, I decided I was tired of dreary old Thunderbird and before I went the whole hog on Incredimail I thought I’d see if Microsoft’s next generation of Outlook Express (a program I always thoroughly abhored) was actually any good. When downloading WLM I was offered the chance to install Windows Live Writer - a desktop blogging tool which is apparently compatible with wordpress.

So this is essentially a test post to see if it posts at all and how it connects tot he wordpress dashboard. Certainly the layout of text and images is good but there seems to be no upload media option as from the WP dashboard (if flawed.) It looks as though if the picture above is to show I will have to use filezilla if I want it hosted on my server. It is possible that I could get myself a Skydrive account, another MS/windowslive project which appears to give everyone 5gig of password protected space. Whether you can use Skydrive to host images I have not yet investigated but I would prefer to host my images on my own site along with my other wordpress files.

Time to press publish and see what we get.