May 13 2009
WordPress Migration Complete….
I finally am back in the the blogging business. Moving the actual domain from my local machine to Bluehost was pretty simple, most of the problems I encountered were self induced!! It was a little more tricky to move my WordPress site from one domain (home.beilers.com) to another (beilers.com), but not really very hard. Things to be aware of:
- Kind of funny, the support staff knew exactly how to answer my question, just like a script! After you export your data from your old database and import into the new database, you need to change two (2) rows in the wp_options table, ids #1 and #39 need to be updated to the new domain URL. Nice magic numbers!
- All of my images were missing in the old posts after the migration, good thing I don’t use a lot of them! Unfortunately after I imported the data, I realized that the full (old) URL was specified in all the <img src=”"> tag attributes . I had to go through each post and change it to the new URL and path. Kind of a drag; I probably could have written a database query to do the update, but it just seemed easier to update them by hand! If I would have been more aware, I could have done a global search and replace in the exported text file; that would have been too easy!
- There was another small import/export problem. Anywhere I used “quotes” around words, the quote (“) character was displayed in some encoded format, about 5 or 6 characters in length. I don’t remember the exact sequence, but it was pretty visible on the page, especially if you had them in a title. I might have been able to chose an alternative export format to better handle this situation, but by this time, it was too late and I really did not want to start over!
- Don’t copy over you plug-ins, it is better to just reinstall them. I simply copied over all my plug-ins and content; which mostly seemed to work. However when I hit the clean cache button on my wp-super-cache plug-in, it toasted my site (no longer accessible!). I was on the phone with the support team for about 30 minutes. They gave me a little scolding, but are generlly very nice people! I can’t say enough about how helpful they are…
- If you do move your site over, your image upload directory will probably be wrong too. Just go into your WordPress admin panel and update the upload directory to the appropriate location on the server, under your new WordPress installation. I only discovered this after ScribeFire refused to upload new images.
- There was one other weird thing, my WordPress account for wp-stats (as well as my Linked.com blog linkage) seemed to take a couple of days to synchronize with the new domain name, the old home.beilers.com reference was there for several days after the switch. It finally switched over to beilers.com this week. All I can say, is ignorance is bliss!
I’m very happy with Bluehost and my decision to migrate over to their servers. I’m set for at least 3 years now, I hopefully won’t have to go through this exercise for quite some time!


I can’t believe that I just outsourced myself! After my recent Ubuntu upgrade experience, I finally pulled the plug and signed up with
My Ubuntu 64-bit 9.04 upgrade did not go very smoothly, it left my machine un-bootable. The upgrade downloaded all of the packages, but seemed unable to install anything. The detail window was full of the same message, something about a dpkg failure. I was really bumming, as the upgrade on my 32-bit laptop worked flawlessly. I hoped that I could recover my blog, but was not exactly sure how it would workout. I tried using chroot after booting from the CD, but the install messed up the file system so badly, nothing would run.
It was pretty easy to recover MySQL and WordPress. I never took the time to figure out how to backup MySQL, so I was a little worried about losing my blog data; I guess that will now be my number one priority. The restore was as simple as copying all of the files from /var/lib/mysql and /var/www from my old drive to the new drive. I just had to change the file owners and groups, restart MySQL, and my blog was back, up and running. Not too bad!
I was joking with my friends that President Obama had visited my blog twice last month and actually left some comments. I was so excited, but I could not understand why he was pushing Viagra…. those liberals are just too funny! My blog gets its fair share of spam, fortunately the Akismet plug-in does a really good job at flagging the spam comments; I just have to go into the dashboard every so often and clean them out.
I found a