Hello, I was wondering if anyone knows of a script or plug in that can help me accomplish the following. Configure a preexisting wordpress database and config file to work on another host. Example: I have a site mysite.com with 30 thousand posts and I want to move it to myfriendssite.com. I've looked at the database and it seems if you export it from mysite.com and import it to a database powering myfriendssite.com it should, with with the exception of media files and the server configurations such as paths etc transfer over pretty easy. Am I correct? Has anyone had to do this and what were your methods?
You'll also have to change your blog and WP URL (MySQL table wp_options). I would just export the whole database and replace all occurences of your old domain with the desired value. Then it should be ready (don't forget to change your MySQL settins in wp-config.php).