Goodies

Here, you will find a list of useful snippets/tools you might easily forget. Editor's note: This is not the place to put passwords!

Wordpress find and replace all instances of old url

update wp_posts set post_content = replace(post_content, 'http://olddomain.com','http://newdomain.com');
update wp_posts set guid = replace(guid, 'http://olddomain.com','http://newdomain.com');
update wp_options set option_value = replace(option_value, 'http://olddomain.com','http://newdomain.com');