WordPress

更改域名

UPDATE wp_posts SET post_content = REPLACE(post_content, 'href="http://jzsh.org/blog', 'href="http://blog.jzsh.org') WHERE post_content LIKE '%href="http://jzsh.org/blog%';
UPDATE wp_posts SET post_content = REPLACE(post_content, 'src="http://jzsh.org/blog', 'src="http://blog.jzsh.org') WHERE post_content LIKE '%src="http://jzsh.org/blog%';
UPDATE wp_posts SET guid = REPLACE(guid, 'http://jzsh.org/blog', 'http://blog.jzsh.org') WHERE guid LIKE 'http://jzsh.org/blog%';
UPDATE wp_comments SET comment_author_url = REPLACE(comment_author_url, 'http://jzsh.org/blog', 'http://blog.jzsh.org') WHERE comment_author_url LIKE 'http://jzsh.org/blog%';
UPDATE wp_options SET option_value = REPLACE(option_value, 'http://jzsh.org/blog', 'http://blog.jzsh.org') WHERE option_value LIKE '%http://jzsh.org/blog%';

安全性

• 更换blog声明(shell909090)
• WordPress 被入侵有感 - 依云's Blog