WordPress is a state-of-the-art publishing platform with a focus on aesthetics, web standards, and usability. WordPress is both free and priceless at the same time.
So , Many people use WordPress in the world , such as blog , cms , company website , and more.
But many people will be change their domain because many different reason, just like me . I test the the wordpress as a blog in local host , and post many articles and images in blog , then I want to publish the blog in production host . So , to change the domain name of wordpress , you should follow the steps below.
0) prepare the new host information and new domain name address and the database host.
1) log in blog and go to Site Admin page, and in the Settings , change the WordPress Address(URL) and the Blog Address(URL) in the form and save it (when you done this, if you want to log in you should change the data in the database , it store in the table named wp_options).
2) log in phpmyadmin and select the current database, in the SQL form , you should copy the query string and paste it into the form and update the database.
a: For links and attachments in the conten. the query string is :
UPDATE `wp_posts` SET `post_content` = replace(post_content, 'http://www.your-old-domain.com', 'http://www.your-new-domain.com');
b: For the posts permalinks stored in the database. (By the way , you may skip this step):
UPDATE `wp_posts` SET `guid` = replace(guid, 'http://www.your-old-domain.com','http://www.your-new-domain.com');
c: If you created the custom filed in the post , you should copy this also:
UPDATE `wp_postmeta` SET `meta_value` = replace(meta_value, 'http://www.your-old-domain.com','http://www.your-new-domain.com');
3) export the current database and download to the local directory.
4) upload all files and import the exported database, if the database information is different , make sure check it correctly in wp-config.php in the blog root directory.
5) open browser and visit the new blog address , and there is it.
I want to thank the blogger very much not only for this post but also for his all previous efforts. I found http://www.ybfq.com to be greatly interesting. I will be coming back to http://www.ybfq.com for more information.
从blogsearch搜到了这篇文章，真的很不错，希望能看到更多的新内容，已经订阅了rssfeed，祝博主好运：）
The great thing about WordPress is that each of their themes is simple yet efficient. None of the themes go overboard, but all will leave a lasting impression on those who see it. Of course, it is how you run the blog and what content you place on it that matters most. But at the same time, you want a visual that is appealing and not distracting.
I really like when people are expressing their opinion and thought. So I like the way you are writing
I would appreciate more visual materials, to make your blog more attractive, but your writing style really compensates it. But there is always place for improvement