I setup a new WP website a fresh install so I can move over my old site from another hosting provider. I did a SQL export from the old site. Then an import to the sql db on the new site. I had done this on other sites fine but for some reason on this one it just appended the tables with a different prefix and as a result my site can't see any of my data and there's two sets of tables each with different prefixes.
Can you please instruct me as how to fix this and perhaps understand how it happened so I dont' do it again?
I'm told there was a line of code in the original db dump specifying the creation of a new set of tables or prefix on import?
Please help. If you need access let me know I'll provide control panel and site admin access via private message. THANK YOU!