fatBuzz
1/12/2018 - 4:55 PM

Update domain in database

Copy/paste the following into the SQL tab in phpMyadmin.

update-domain.sql
content_copyfile_download
UPDATE wp_options SET option_value = replace(option_value, 'http://localhost/old-domain', 'http://new-domain.com');
 
UPDATE wp_posts SET guid = replace(guid, 'http://localhost/old-domain', 'http://new-domain.com');
 
UPDATE wp_posts SET post_content = replace(post_content, 'http://localhost/old-domain', 'http://new-domain.com');
 
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://localhost/old-domain', 'http://new-domain.com');