[wp-hackers] [GSoC 2011] Moving Wordpress

[Daniel Bachhuber]

I usually do a MySQL find (old URL) and replace (new URL) on wp_posts, wp_postmeta, and wp_options:

UPDATE wp_posts SET post_content = replace(post_content, 'http://olddomain.com/', 'http://newdomain.com/');
UPDATE wp_posts SET guid = replace(guid, 'http://olddomain.com/', 'http://newdomain.com/');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://olddomain.com/', 'http://newdomain.com/');
UPDATE wp_options SET option_value = replace(option_value, 'http://olddomain.com/', 'http://newdomain.com/');

On 20 Mar 2011, at 11:42 AM, Oliver Schlöbe wrote:

> Or you just use the Export feature WordPress provides.
> 
> Doesn't include plugins and themes, though, but saves you from changing the guid n stuff.
> 
> Regards,
> Oliver Schlöbe
> 
> http://wpseek.com/
> http://wpworldmap.net/
> 
> -- Code so clean you could eat off it.
> 
> 
> On 20.03.2011 16:20, Piyush Mishra wrote:
>> Hi,
>> Moving a WP from one install to another server for a new domain means
>> changing the guid in [wp_]posts, updating site_url n home.
>> Taking mysql dump, zipping wp-contents and importing all of that on the new
>> server right?
>> 
>> Is there any issue I left out above?
>> 
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers

--
http://db.ly/info