captured sparks

When I moved to Wordpress, I manually imported all my existing blog posts from the custom database into Wordpress. This meant that when it came to moving to production, I had to import all posts into the production database. The steps I took to do this were:

1. Install Wordpress as normal on your production server.
2. From your development database, export all tables except the users and options tables.
3. On your production database, drop all tables except users and options.
4. Import your development sql file into your production database.

One caveat: If your blog has multiple authors, this method is unlikely to work. On my development machine, the posts were imported as admin and therefore matched the user setup on the production machine.