How to Use One Wordpress Database to Populate Another

1. Log into the WordPress admin panel on the site where the database is that you want to use. In general, the WordPress admin panel is located at www.yoursitename.com/wp-admin where 'yoursitename.com' is the actual name of your website.
2. Click 'Tools' in the left hand sidebar and then click 'Export.' WordPress will create an xml file which contains all the data from your installation including posts, pages, custom post types, custom fields and custom taxonomies. The file will download to your computer.

3. Log into the WordPress admin panel on the site you want to populate with the data.
4. Click 'Tools' and then click 'Import.'
5. Click 'WordPress' and then locate the xml file on your computer. Once uploaded, the file will populate your new WordPress site.