After changing hosts and DNS, installing the latest WP and then importing the database as .sql file via phpMyAdmin I have the homepage looking like it's pretty much all there, minus some CSS, but none of the page links work. I get a "404 page not found error" message.
From within the Admin panel I can see the pages and all the content, so I know it's in the database.
I searched for support forums and found some info regarding do a search and replace in the database but am unsure of "what" to search for and what to replace. I've had a quick look in the database and there was only reference to the old host I found was replaced with the new one, but that wasn't the answer.
I can make new pages, so it's something to do with the old paths but I don't understand how they work in WP or where to find them to see the broken links.
Any help would be greatly appreciated.