I recently moved TechSpin to a new host, it was not a pain-free transition. This post contains a running list of things I encountered when moving my WordPress Site. I expect to continually update this post as I finish the transition, and hopefully figure out how to repeat this move in the future with less pain.
1 – index.html vs index.php
WordPress uses index.php, Apache httpd loads index.html first.
When you log into your new hosting site your host provider might have graciously already provided a public_html or www directory, and in that directory a set of default web pages, likely including an index.html. This is all well and good, your host provider is trying to help you out by providing something for people to see when they browse to your newly created site.
When you install WordPress, which for my provider defaults to installing in the public_html directory, the WordPress install creates a file index.php, which WordPress uses to load your WordPress site.
WordPress was installed, but it would never load. When I browsed to my site all I saw was the index.html parking screen, instead of my newly created WordPress site. Apache httpd was loading index.html in preference to index.php, both of which were in the public_html directory.
My solution: delete index.html from my public_html directly, leaving index.php. There was nothing particularly interesting in index.html anyhow. After deleting index.html Apache httpd happily loaded index.php and my WordPress site.
2 – Recovering / Resetting lost WordPress admin password. Found this solution at http://codex.wordpress.org/Login_Trouble
Edit Users Table Access your site's phpMyAdmin and edit the database carefully. Open the WordPress database. Click on the users table in the left menu (default is wp_users, or yourprefix_users if you defined a different table prefix.) Click BROWSE. Click on the EDIT button next to the admin user. Delete whatever is in the password field. Enter your desired password. From the Function drop-down list, choose MD5. Save the info in the database. Log in to WordPress using "admin" and the password you used. In the case of newer versions of WordPress, the password is double hashed, but as long as you md5 the password, it will complete the hash (it upgrades your password for you).
3 – Backing up your WordPress site
Now that my site is back up and running I will be investigating the best way to back up, cleanly and completely, my WordPress site. The path I walked to backup TechSpin from the original provider to this new provider was neither clean nor complete. When I find a better answer I’ll post it here.
4 – Moving user comments
This was not really a problem with moving the site but something I’ve been needing to do for a while. Visitors do not always leave their comments in the comment section of the post they are clearly commenting about. I needed a way to move comment from the post they were entered to the post they belonged to. Oddly enough WordPress does not seem to have this functionality built in. Fortunately there are plugins to help with the task. I ended up installing Tako Movable Comments and they worked great. I used this Tako Moveable Comments tutorial to walk me through the process.