Step 1: Install WordPress
Install WordPress at your new domain name with new database settings.
Step 2: Copy your existing database
I found it easier to compare the standard wordpress tables (there’s only 12) and for a simple wordpress site, only 5 were different.
- terms (ie categories)
- term relationships
- taxonomy
- postmeta (feature images etc)
- post (main one)
Step 3: wp-content/upload
Copy the contents of wp-content/uploads over to your new theme location.
Step 4: Customize your theme
You’ll need to go in and customize your widgets and menus.
If you want all your posts to appear on the home page, go to Settings > Reading and increase the post show count to something like 100.