I recently move my personal blog about my kids from a cpanel-type webhosting interface to Dreamhost’s own webhosting management dashboard, or something. Recently, meaning today.
Anyway, Matt-and-Sean.com is a stale blog that is supposed to be a photo journal of my boys but because of the webhosting’s storage constraint, I need to move it to my Dreamhost account which has unlimited bandwidth and storage.
I’ll be posting here how to move your WordPress blog from a cpanel webhosting to Dreamhost. But the main purpose of this blog post is a single tip on the mysql prefix thingy…
Basically, before you do anything, download/backup your original files from the cpanel webhosting company that you are in… in my case, I opened up matt-and-sean.com/cpanel went to the Backup section and downloaded the database.. That’s the file with an “sql” extension.
Also you can download and backup wp-content directory.. since it contains all your themes, plugins and all those previously uploaded pictures… if you don’t do it, the images from your previous posts wont show up… now that’s sad.
Here are the quick and dirty steps, and I wont put the details here.. If you stumble upon a problem, and you need the info, you can contact me for other details… Dont.
1. From matt-and-sean.com’ domain registrant (it’s from marvin’s web.. another story.. i dont want to tell you the hassle i’ve been through for it to be ‘released’), change the DNS setting to the one that Dreamhost is using, that is ns1.dreamhost.com, ns2…..
2. Setup matt-and-sean.com in Dreamhost.. You’ll just basically clicking “manage domains” –> “Add New Domain/Subdomain” and filling up the essential in rank
3. Once that’s done, wait a link of minutes to an hour in anticipation of the whole internet knows the new matt-and-sean.com.
4. From Dreamhost’s instrument panel, here’s this “One-Click Bed in” features which makes the 5-small authoritative WordPress installation guide to 2 minutes or less! I tell you, some public (I wont say public from PLRPro.com) even sell the thought to their members.
5. Previous to you can bed in WordPress, you will be essential to make a user name for the database of even a database. Then with that, you’ll have a new and shinny wordpress blog with a “hello planet” post in it.
6. Next, get your ancient blog up. Go to Database and click on the phpadmin..and import your first sql file.
7. Here’s the tip.. with importing, you may subdue wonder where’s all your post? Why is it only the “Hello Planet” post showing? Here’s the deal.