Sunday, 23 June 2013

Wordpress Transfer Changes to Database

When transferring a Wordpress installation you need to change all the references to the old domain and replace it with the new.  Here's the MySQL 'find and replace' I used for mine.

update wp_options set option_value = replace(option_value,'','');

update wp_postmeta set meta_value = replace(meta_value,'','');

update wp_posts set post_content = replace(post_content,'','');

update wp_posts set guid = replace(guid,'',''

No comments: