Guide to import posts on wordpress into new host

I have completely finished all the initial setup on my new homepage, after configuring domain name, uploading the wordpress software, installing some plugins, put one wordpress theme to use instead of the default kubrick, and many other steps … but i think just in case you want to have your own hosting service like me (actually this is shared between me and my uncle’s) :P … anyway, i’m going to give you some tips on how to copy your old blogs post / article into your new hosting service without using RSS because its not quite perfect (and this is the way i'm doing it) but i'm not going into detail here because it’ll be reallllly long … and just a note, my hosting service doesn't provide CPanel or Fantastico that can simplify your CMS Software Installation

Required Software :

• Apache Web Server : a Web Server Software so you can run Wordpress on your computer
• MySQL : SQL Database which is required by Wordpress
• Phpmyadmin : to simplify MySQL database management
• Wordpress MU : Required because the most perfect way to import your blogs posts by using Wordpress MU (at the time i wrote this)
• Wordpress SU : This is the one you’re going to use on your web hosting service, if it doesn't give you Fantastico (but i prefer to upload it directly instead of using Fantastico)

The first step is, install Apache and MySQL on your Computer and configure it correctly so your web server can be accessed at http://localhost by typing at the browser address bar. And as for the next step if you’re using Windows, open the HOSTS file in Windows/System32/Drivers/etc directory and add these line (if you’re using linux there’s no need to use this) :

127.0.0.1 localhost.localdomain

because Wordpress MU required to be run at localhost.localdomain instead of just localhost. And after doing the above steps, extract the Phpmyadmin into the root of your web server directory (in your computer) .. and configure it as necessary like configuring the mysql database path and so on. If you already finish that step, open your web browser and try opening http://localhost.localdomain/phpmyadmin (depends on your phpmyadmin directory) and see if you can open it and access the mysql database in your browser.

And now, create a database to use on Wordpress MU installation, and extract the Wordpress MU Archive into the directory of your webserver, and configure it again to use that database. And once again open your browsers and point the url into your Wordpress MU directory and see if it can load properly, then follow the steps given untill finished

And now (how many time did i say “And Now” ? ) … lol … open your web browsers into your Wordpress.com account and choose Manage -> Export -> and save it in your harddisk. Then Open up the wordpress MU url again in your browser and choose to Import the Wordpress xml file and wait untill your post has been succesfully imported into the Wordpress MU installation, and now open the phpmyadmin url in your browser and open up the _categories table and delete link_count, posts_private and links_private field, then choose to Export from the Wordpress MU SQL Database only at the below table using any format you choose :

*_categories , *_comments , *_posts , and *_post2cat

after doing the above step, if you were using an uncompressed format, copy – paste all the sql query into your favorite text editor … and rename all the *_table so the results will be :

wp_categories , wp_comments , wp_posts and wp_post2cat

and now upload the wordpress single user installation into your web hosting service, and install the wordpress single users and login into your admin dashboard and delete all the welcome messages, comment, posts, etc (just to be safe) … after that open Phpmyadmin (most web hosting service already gives you this, including me that’s not using Fantastico or CPanel) and choose to run the previous sql query by importing it … and wait …

That’s it you’re finished ;) … all your wordpress.com posts are imported into standard wordpress installation … hopefully you understand what i'm trying to say (sorry if my english is bad) … and just a note … this is a manual step without using RSS / external plugin to import your posts and require you to know about SQL, Web Server and such stuff, so if you don’t understand about this stuff i suggest you try asking someone who can help you importing your wordpress posts into your new host.