moving a wordpress weblog

Thu, Jun 30, 2005

This example is for moving http://www.weblogs.uhi.ac.uk/lis to http://weblogs.uhi.ac.uk/vle

First thing is move the directory on the server, from [WEBLOGS_HOME]/lis to [WEBLOGS_HOME]/vle

Then update the weblog’s database.

update wp_lis_posts set guid=REPLACE(guid, “lis”, “vle”); update wp_lis_options set option_value=REPLACE(option_value, “lis”, “vle”) where option_name=‘siteurl’; update wp_lis_options set option_value=REPLACE(option_value, “lis”, “vle”) where option_name=‘fileupload_realpath’; update wp_lis_options set option_value=REPLACE(option_value, “lis”, “vle”) where option_name=‘fileupload_url’; update wp_lis_options set option_value=REPLACE(option_value, “lis”, “vle”) where option_name=‘home’;

comments powered by Disqus