Category Code Blog

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, 'http://www.olddomain.com', 'http://www.newdomain.com')
WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.olddomain.com','http://www.newdomain.com');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.olddomain.com', 'http://www.newdomain.com');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.olddomain.com','http://www.newdomain.com');

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

Roundcube Address Book Missing

Roundcube Logo I recently had to reinstall roundcube and a number of program features broke. I found a #roundcube channel on IRC freenode and posted a question to the people there.Read More