mysql> UPDATE wp_options SET option_value = replace(option_value, ‘http://hongblog.jinstalk.com‘, ‘http://blog.hongstalk.com‘) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> UPDATE wp_posts SET guid = replace(guid, ‘http://hongblog.jinstalk.com’,’http://blog.hongstalk.com‘);
Query OK, 0 rows affected (0.02 sec)
Rows matched: 964 Changed: 0 Warnings: 0
mysql> UPDATE wp_posts SET post_content = replace(post_content, ‘http://hongblog.jinstalk.com‘, ‘http://blog.hongstalk.com‘);
Query OK, 0 rows affected (0.05 sec)
Rows matched: 964 Changed: 0 Warnings: 0
mysql> UPDATE wp_postmeta SET meta_value = replace(meta_value,’http://hongblog.jinstalk.com’,’http://blog.hongstalk.com’);
Query OK, 0 rows affected (0.01 sec)
Rows matched: 686 Changed: 0 Warnings: 0
