Change en.makeit.cn to en.lostinbeijing.com

December 16, 2010 Author:  

I have began to use the LostinBeijing.com for several month. Today, pill I don’t want to write Java code . I’ll change the domain of my English site only. So , order I have done it. En, Only the logo of the site I don’t handle still. Ha, I think that i use the logo of Chinese site.

En, i think that i should remember these sql code. they are very useful.


1. UPDATE wp_options SET option_value = replace(option_value,'old domain','new domain') WHERE option_name = 'home' OR option_name = 'siteurl';

2. UPDATE wp_posts SET post_content = replace(post_content,'old domain','new domain');

3. UPDATE wp_posts SET guid = replace(guid,'old domain','new domain');