4/12

Well, it was all going rather well in day 2 of the GREAT MOVE.

I found that, on the new hosting company, I can work on it without it being ‘live’ – meaning the existing one can remain in place.

Except ……..

It seems that the SQL database I am using is, in fact, the existing SQL database!

WTF?

But, it seems a slightly bastardised version of the existing SQL database.

Time for a break whilst work takes over.  And then we shall see.

Update 1:  The support team at the new hosting company assure me that I have must have restored it/transferred the data otherwise, what I am experiencing “is not possible”.

However, I think it may have something to do with the fact that I created an alias in order to set up the blog before cutting the old one.

But, and this is where the really worrying bit comes, am I looking at the old database or the new one?  If the new one, how can the data have come across when I haven’t, as yet, tried to restore it?  If the old database, then how am I able to look at it if they are held on different servers?  And, what will happen when I cut off the old one?  Will the old database and the new database disappear?

And, even more worrying is: How safe is the data if it can “suddenly” appear in the “new” database without me having done anything?

Bugger.

Update 2 – 10/12:

We’re almost a week on from the above.  Nothing has changed.  My blog is still being hosted on the other servers.  However, today I found something that said it would be easy, so I updated the nameservers (pointing the blog to the correct, new servers), killed the database, restored the database from a backup and checked it was OK and, finally, transferred all the WP files from the backup I created.

Perfect.

Except, of course, not quite.

Not quite as in it didn’t work.  I checked all the passwords, made small adjustments where I found errors and ……..

Still problems.

Then, I suddenly remembered that, the reason I was going to do this at home, last weekend, was that home was where the full file download was.  Here, the copying of files kept timing out – at home, it was fine (except for 3 files).

So, now I can do nothing, until I get home.

So, given the fact that it was a long weekend you may ask why I didn’t do it.  Well, Friday, I did other things, including booking the meat for Christmas and Boxing Day and wandering around looking for presents.  Actually, having wandered around, I found some things but, in the end, I didn’t want to buy them because, for me, now, Christmas Eve is the time for these things and I really wanted to come back on Christmas Eve and do it.  Nowadays this is part of what makes Christmas great.

I did pop into Euronics to see if they had a turntable (the main present for F) as I couldn’t wait for Christmas Eve for this.  They didn’t but, whilst I was there, I looked at televisions (F wants to get me one for Christmas) and fridges (as mine is very old and, sooner or later, will die.)

Saturday, during the day, was mostly spent searching for, researching about and phoning around for the said turntable.  The one I wanted which was supposed to be ‘arriving soon’ at a very local shop, was, in fact, not arriving, they told me.  It was not arriving because it hadn’t been ordered.  However, I could have a different one for only a couple of hundred Euro extra.  I told them I’d think about it.

Then, on another site, I found one.  Not the one I had been looking for exactly but, whilst researching, it seemed that Technics was the make to go for and this was a Techincs.  I phoned them.  They had 2.  And, yes, they would be open on Sunday.

Sunday morning came and, after breakfast, I went to get it.  Perfect.  Whilst waiting for the bus back to town, I saw that someone had posted some crap post about me being 40% happy and thought, “You know nothing”.

And then I got home.

I had forgotten to put the chair against the power lead to the fridge.

Piero had part-chewed through the wire and, somehow, managed to short it without killing himself.  So, now I had no fridge.  I told F and we ended up at Euronics where, for Christmas he bought me a new fridge (to be delivered on Wednesday) and we (together) bought a new telly, which we took home straight away.

But, obviously, to put it up, we had to clean behind where the telly is.  And, so, in the end, I didn’t sit down at the computer until about 5.30 – which was too late to do the move.

So Sunday, was, in the end, a mixed day – although I would say that I was still more than 40% happy, maybe I wasn’t quite 100%.

So you still have to wait to read this.  I hope that, by tomorrow, all will be, more or less, back to normal.

Update 11/12

So, now it’s back up and running and almost done.

Of course, it didn’t quite go as planned.  I got home and uploaded the files.

Except, some were missing and I had no idea until I uploaded them.

So then I had to bugger about this morning – uploading new WordPress files, uploading the ones from work that I had deleted and then resetting the config again.

I did think it was going to be a real pain but, in fact, once I’d done that, all was OK.  Now to fix the picture at the top and we’re done.

Thank goodness.  And, just in time for Christmas too.

I’ll be along to view your blogs and catch up as soon as I can.

Ciao