Wordpress Transfer Changes to Database

When transferring a Wordpress installation you need to change all the references to the old domain and replace it with the new.  Here's the MySQL 'find and replace' I used for mine.

update wp_options set option_value = replace(option_value,'wisemonkeymedia.co.uk','wmky.co.uk');




update wp_postmeta set meta_value = replace(meta_value,'wisemonkeymedia.co.uk','wmky.co.uk');





update wp_posts set post_content = replace(post_content,'wisemonkeymedia.co.uk','wmky.co.uk');




update wp_posts set guid = replace(guid,'wisemonkeymedia.co.uk','wmky.co.uk'