Hey DaTechGuy Why the #*Y((@$@ haven’t you moved the blog yet?

Posted: August 31, 2019 by datechguy in Uncategorized

Glad you asked.

Yesterday I got a big surprise in the mail, it was a letter from the new company with a check for what I paid already for the move.

I was bluntly told that our database is so corrupted that there is simply no way to get it imported.  They tried multiple different methods and everything failed.

I suspect this corruption is one of the reasons why this is one of the slowest blogs in the blogosphere.

I decided to put this to the test and attempted to export the blog to the backup blog, every attempt failed.  Even when I attempted to import just a single month’s of posts everything blew up in a fashion that would have made Crazy Harry proud.

This gives me two options.

The 1st option was to move everything to wordpress on the theory that if anyone is an exert on WordPress, it would be wordpress.

I have rejected this option for a couple of reasons.

#1  Given the state of the database, even if they managed to import it odds are I would have a blog just as slow if not slower at the new site.  There is of course the possibility that they could repair the database but the cost of doing so would almost certainly be prohibitive.

This leaves option 2 which I have decided on.

The plan is to go with the hosting service I was originally doing to work with, and do a clean install.

this will mean a clean database and get the blogs speed back up to snuff.  The problem of course is what to do with data from Nov 2011 to date?  (everything up to Oct 2011 is on the old backup site already.

The answer is simple but tedious.

  1.  Take an old domain that I still own but aren’t using like datechguyondaradio.com and point it to the current blog.
  2.   Go into each blog post individually and using copy and paste from the HTML editor move said post to the current site, doubling checking to make sure the name of the post is correct because the name on the post is not necessarily the name in memory
  3.  Publish the post giving the date of publication as the original publishing date.

This means that eventually every thing will get moved over but the old blog posts will repopulate slowly, basically at the speed that I and maybe one other person can do this.

Most likely it will take several months but eventually everything will get to where it needs to be and most importantly the database problems will not be imported with it.  So the blog should load at a reasonable speed.

The process:

The 1st step will be to make sure that we can access the current site with the different host name, once that is done and I can confirm that I can access each old post via the editor rather than having to go to the wayback machine and copy and paste through there, then the new install can be made.  Once we are sure it is up then the DNS for datechguyblog.com can be changed and all new traffic will be going to the new spot while I can still access the old domain via the different host name.

What will be lost.

Every comment on every old post will be toast.  it’s going to be tedious and costly enough to move every single post by hand, to reproduce every single comment I can’t justify the cost and time.

The Drawbacks:

This means that every single link to an old post will become broken until said posts are moved.  This is going to wreak havoc with my stats for months but as each old post gets moved the havoc will be decreased.

Since we are talking 10,000+ posts my guess is it will take about 500 hours to get everything over, but the reality is that most old posts forgotten so I might just worry about moving over the last couple of months of posts and maybe the top 100 or thousands posts because they are still drawing traffic right away and then a few a day after that until it’s all done.

Either way I’m shooting for the end of next week for the clean install.  Once I confirm the ability to access the current sight after the DNS transfer then the moves will begin.

When things are more solid I’ll let you know.

Comments are closed.