Move a WordPress blog from one host to another, so the permalinks work

gistfile1.sql

SET @uri_from = 'www.devurl.local';
SET @uri_to = 'www.liveurl.net';
 
UPDATE wp_options SET `option_value` = REPLACE(`option_value`, @uri_from, @uri_to) 
  WHERE `option_value` LIKE CONCAT( "%", @uri_from, "%" );
 
UPDATE wp_posts SET `guid` = REPLACE(`guid`, @uri_from, @uri_to);
 
UPDATE wp_posts SET `post_content` = REPLACE(`post_content`, @uri_from, @uri_to);
 
UPDATE wp_postmeta SET `meta_value` = REPLACE(`meta_value`, @uri_from, @uri_to);