Yesterday when I got on the computer I discovered that my database had issues and I went half of the day without any blog posts but my blog was still functional, sort of. I called my web host and they fixed the database but could only give me their backup from before December 23rd. I thought, ok that’s fine. I’ll only have a month of posts to restore, no big deal.
Unfortunately it wasn’t that easy because as I was restoring the 2nd post everything went wrong. The backup that they installed was still corrupt and everything disappeared. Not just the posts but my entire blog became useless. I couldn’t do anything at all.
Today I got back on the phone with them and thought it was all fixed when I hung up but it was far from fixed. I didn’t call them back but instead I re-opened my support ticket and sent them an email telling them it’s still not working. I got tired of waiting so I just decided that they weren’t going to be able to help me so I’ll just start over.
I created a new database and started from scratch. I got most of my ad’s back up so I get paid for them and while I was at it I figured, while I’m starting over I might as well change the permalinks. It’s the way the website address (URL) looks. Instead of being xanapus.com/blog/?p=(numbers) it’s going to have the date and the name of the post in the url. That makes it easier so if I have that issue again with my database then I can easily add the posts without having to contact the companies I do posts for with a new url because they will automatically be the same as before.
The downside is that I had over 1700 posts. I had more than twice that amount of comments and they are all gone now. The only way I can get any comments back is if new people comment. I was fortunate to have 616 of my blog posts copied over to YouSayToo and I had about 609 posts over on Blogger so all I have to do is copy and paste those posts.
The good thing about being able to copy my posts back manually is that I can edit which ones I copy over. Like all those Roku posts, I can finally just delete all the useless posts and make 1 new post review of the product.
The bad thing is that my arms and wrists aren’t going to be too happy with me. I’m already in pain in my left arm and both my hands from the carpel tunnel syndrome. This is going to take a lot of time to do but I will get as many posts back up as I possibly can.
I have spent the last 4 years making this blog what it was, I am not about to throw in the towel just because my database is corrupt and I wasn’t smart enough to do backups. Although, I will be doing monthly backups from now on lol.
My widget bar on the right doesn’t have everything in the same order as it was and I’m probably missing a few things but those are things that I thought might have been there. I’ve also changed the paragraph style so they are fully aligned like a newspaper or book. I think it makes it easier to read. That has always bothered me but 1700+ posts made it difficult to want to change every post. Now I can since I have to manually add them.
Well, tomorrow is another day and hopefully I can get as many posts added as I can before my arms fall off. I copied 18 posts tonight but that was in a very short amount of time. Tomorrow I will have the whole day to get as many copied before I get too tired to go on.
So until tomorrow…