Monthly Archives November 2019

WordPress Domain Update and SSL SQL

To update your domain name, execute the following SQL commands in phpMyAdmin.

UPDATE wp_options SET option_value = replace(option_value, '', '')
WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, '','');

UPDATE wp_posts SET post_content = replace(post_content, '', '');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'','');

Similarly, to transition your site to SSL, modify as follows. A site I’m working on also has the plugin for the yoast_seo_links table so I’m including updating that from development to production.

UPDATE wp_options SE...
Read More