In January I started noticing some problems with my website hosted by MediaTemple. I was getting constant ‘Database errors’ and nothing I did seemed to work. I was hosting my personal blog and a handful of other sites that I like to call my “hobbies” and the fact that all of my sites were up 10 days out of the month was not making me a happy guy. I started using MediaTemple from a recommendation of a friend and they were an easy service to use and up until these issues, I had no issues at all.It got to the point that I was ready to leave and just start using a new host but I wanted to give MediaTemple some time to see if we could get my sites to a place where they were up most if not all of the time. Good thing their support and Twitter contacts were so helpful because if not, I would have made the switch and this post would not be going down the same path.
After a lot of back and forth on what was going on with the sites from analysing the overhead of the server to looking at specific MySql databases, it turns out I had just out grown the grid-server I was using and had to upgrade. I would be moving from the Grid-Service (gs) to a dedicated virtual (dv). Since I was staying with the same host, I figured it would be easy for them to pick up my stuff and just plop it down on my new dedicated service and we would be happy campers. I was very mistaken. The server migration has to be done by me, again, not a huge deal, I can be technical if need be but I didn’t realize that I would have to learn details about command line scripts to backup and restore MySql databases and import them into the new home. As I said before, good thing their support people are so nice, I had them walk me through this on this blog and it took a few tries but we got it working.
Moving some of the other sites I have will be a bit easier. Nothing I was hosting is as large as my blog so I can’t imagine such a painful process. The next site I wanted to move all on my own was HyperLocal Edge. For the most part its a dormant site. I haven’t updated it in a while but the content is still very relevant. Since the databases were small enough, I could run the operations through PhpMyAdmin for export and import them into the new server. I did, they all moved over right but when I pointed the domain to the new location…nada. Yes, I learned how to reconfigure the wpconfig.php to make sure the blog had a conversation with the database. But for some reason, that didn’t work so the site looks like a brand new site with nothing but a “Hello World” post. I’m waiting to hear from MediaTemple support what could have gone wrong.