You need to review Moving_WordPress.
Thread Starter
daza84
(@daza84)
Thanks Esmi, i did read through that, but it doesn’t explain in detail how to move the database. I assume i just export & import using myphpadmin, then run through that Online WordPress Serialized PHP Search and Replace??
You need to run the search & replace on a copy of the exported db backup before you import it into the new site.
Thread Starter
daza84
(@daza84)
ah, ok, thanks, will give that a go!
Thread Starter
daza84
(@daza84)
ok, tried that & get an error, there are no databases setup on the new host, do i need to create a database first & import into that?
SQL query:
—
— Table structure for table wp_commentmeta
—
DROP TABLE IF EXISTS wp_commentmeta;
MySQL said: Documentation
#1046 – No database selected