[wp-hackers] [GSoC 2011] Moving Wordpress
d at danielbachhuber.com
Sun Mar 20 15:46:53 UTC 2011
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.
> Oliver Schlöbe
> -- Code so clean you could eat off it.
> On 20.03.2011 16:20, Piyush Mishra wrote:
>> 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
More information about the wp-hackers