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 table_name set table_value = replace(table_value, 'http://olddomain.com','http://newdomain.com');
-- replace the above table_name, table_value pairs with the following pairs
wp_posts, post_content 
wp_posts, guid 
wp_options, option_value