Changed web hosts & wanted to move this WordPress blog.
on old server
Exported SQL tables from the old installation.
Make sure you of course have any custom php files & templates.
on new server
Created new WordPress installation on new server.
save wp_options table. Delete all other SQL tables on the new installation EXCEPT this wp_options table. It has the server specific settings.
Remove wp_options table info from OLD sql file and run that SQL file in new Database. This populates the new blog with all of the old blog’s information.
Upload any templates and custom files.
Voila – New WordPress installation!
This should work on identical or similar wp versions.
Hmm.. I guess this level is necessary if you might be switching versions in the transition, but I think you should be able to just take a mysqldump of the old DB and populate the database on the new server with that same data, and then just edit wp-config.php with the database name and login info and it should work.
Least I’ve done this moving between websites and databases, admittedly on the same server, without any problems, but then again I have root access so maybe there are some things i’m taking for granted.
Nice info though, I appreciate what you are doing with this site. I find myself using wordpress for just about everything I do these days so it’s nice to know I can bug you with questions about this too :)
-Matt
Thanks for your comment!
Yes. This article is perhaps based on an odd situation.
New WordPress installation; new database; new server.
So I wanted to retain all of my posts, but still use the new configuration and installation. Keep all of the new php & just move my theme & data over.