SQL commands after moving WordPress database backup to new site

I backup a development site to a SQL file and using phpAdmin, I can restore it to another developement site or production site. Once that is done, this can fix the links and such.

Did discover that this will not fix any links that are set in the text of Widgets. All widget text is stored in a single field under wp_options where option_name = “widget_text”

UPDATE wp_posts
SET guid = REPLACE(guid,'http://sourcedomain.com/','http://destdomain.com/');

UPDATE wp_posts
SET post_content = REPLACE(post_content,'http://sourcedomain.com/','http://destdomain.com/');

UPDATE wp_options SET option_value = 'http://destdomain.com'
where option_name='siteurl';

UPDATE wp_options SET option_value = 'http://destdomain.com'
where option_name='home';