MySQL Wordpress Migration Script

MySQL_Wordpress_Migration_Script.sql

UPDATE wp_options
SET option_value = REPLACE(option_value, 'http://EnderecoAntigo.com', 'http://EnderecoNovo.com')
WHERE option_name = 'home'
OR option_name = 'siteurl';

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

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

UPDATE wp_postmeta
SET meta_value = REPLACE (meta_value, 'http://EnderecoAntigo.com', 'http://EnderecoNovo.com');

UPDATE wp_posts
SET guid = REPLACE (guid,'http://EnderecoAntigo.com', 'http://EnderecoNovo.com')
WHERE post_type = 'attachment';