Data Access Notes » wordpress migration the painless way

wordpress migration the painless way

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.

This entry was posted on Monday, May 22nd, 2006 at 2:42 pm and is filed under WebTechnology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Comments »

RSS feed for comments on this post. TrackBack URI

Comment by Matthew Baya — 11-Oct-2006 #

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
Comment by info — 12-Oct-2006 #

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.