Fixing wp_options Table Missing Unique Column and Primary Key

I have had the opportunity and pleasure of doing a lot of WordPress and WooCommerce database cleanups on Codeable to speed up sites. This was one of my favorite projects to complete for a large multisite on Kinsta (Review) that gets around 1 million page views per week. If you see this error in phpMyAdmin ‘Current … Learn more…

Convert WordPress Single Site to Multisite Subsite with WP-CLI and bash

Converting a WordPress single site to a Multisite subsite can really test your patience levels, especially if you are unfamiliar with the multisite structure. Previously I have shown how to convert a Multisite subsite to a single site. This guide walks you through step by step to convert a WordPress single site to a multisite … Learn more…

Advanced WordPress Database HTTPS Search + Replace with WP-CLI

When migrating your WordPress site to https you can have leftover http references causing mixed content warnings and missing green secure locks in browsers! Despite using a migration tool or some plugin to do a simple search and replace, they don’t catch all the http references which can cause mixed content errors errors and insecure … Learn more…

Remove Google Analytics utm_source Query String in .htaccess

Using Google Analytics to gain traffic insights for your WordPress or WooCommerce site can track visitors and conversion rates. If you use tracking for email blasts when you publish new posts or product deals, you may find visitors get a slower experience. Google Analytics adds a query string that looks something like ?utm_source=mailchimp which bypasses any caching you … Learn more…

Use Monit to Monitor + Restart MySQL Service Automatically

Monit can be used to monitor your services on your VPS or dedicated server. You can use Monit to make sure MySQL (MariaDB, Percona etc) is always running in case it crashes because of bots brute forcing or it runs out of resources. Monit will check the MySQL process by looking at the unix socket it is … Learn more…