Jul 222012
Change Site & Home URL
UPDATEwp_options
SET
option_value =
replace
(option_value,
'http://www.oldsiteurl.com'
,
'http://www.newsiteurl.com'
)
WHERE
option_name =
'home'
OR
option_name =
'siteurl'
;
Reset Password
UPDATEwp_users
SET
user_pass = MD5(
'new_password'
)
WHERE
user_login =
'your-username'
;
Change URL in Content
UPDATE
wp_posts
SET
post_content =
REPLACE
(post_content,
'http://www.oldsiteurl.com'
,
'http://www.newsiteurl.com'
);
Change GUID
UPDATE
wp_posts
SET
guid =
REPLACE
(guid,
'http://www.oldsiteurl.com'
,
'http://www.newsiteurl.com'
);
Update Post Meta
UPDATE
wp_postmeta
SET
meta_value =
REPLACE
(meta_value,
'http://www.oldsiteurl.com'
,
'http://www.newsiteurl.com'
);
Delete Revisions
DELETE
a,b,c
FROM
wp_posts a
LEFT
JOIN
wp_term_relationships b
ON
(a.ID = b.object_id)
LEFT
JOIN
wp_postmeta c
ON
(a.ID = c.post_id)
WHERE
a.post_type =
'revision'
Delete ‘Spam’ Comments
DELETE
FROM
wp_comments
WHERE
comment_approved =
'spam'
;
Sorry, the comment form is closed at this time.