Prophetic Musings

Thoughts from a small-town, old-fashioned guy living in the suburbs.

Funny story

(This is kind of geeky. Consider this fair warning.)

So, I get an email from my hosting provider (ReliableSite.net, which has been wonderful) saying that they are moving to a new server location and that I have to check a bunch of the settings and addresses on my sites to make sure they still function correctly with the new settings. So, I start doing that and everything looks fine, right up to the point where I need to change the IP address of where the database that runs this software is located.

For a bit of background, I moved to RS.net from another hosting provider back in August of last year. The old provider was, well, not providing very well. My sites would go down without reason, and their support would take forever to reply to support tickets. When I moved my sites to RS.net, I moved all the files that are actually stored on the server first, then pointed them back to the database on my old provider, just to make sure that everything was functioning correctly on the new host. My new database wasn't ready yet, so I figured I would leave it pointing to the old one until it was ready in order to reduce downtime.

So, we're back to the present day. I went to change the IP address of the database and realized I had never changed it from the old host. I was still using the database from my old host, who I might mention I haven't been paying since I closed my account with them. I've had odd database things come up now and then, but never really looked into them like I probably should have. Now I know why they were happening.

The biggest problem was that I was actually writing posts against my old database, and I had to find something to sync the new one back up. I couldn't really go to my old provider and say "hey, I'm not actually a customer anymore, but could you send me a backup of my database that I've been using?"

Anyway, it's all fixed now. Everything should be running on the right server. Hate it when stuff like that happens.

Published Thursday, January 03, 2008 2:41 PM by clay
Filed under: ,

Comments

No Comments