Clean Jetpack Database Bloat after Uninstalling from WordPress

WordPress plugins typically leave leftover bloat in the database after you remove them. JetPack from Automattic is no different. If you find that JetPack has way more features than you need and want to uninstall it completely, this guide will help you do that by removing the JetPack database values from the wp_options and wp_postmeta … Learn more…

How to Batch Import Multiple WordPress MySQL Table Dumps

I was migrating a huge, high traffic WordPress site for a client on Codeable to Kinsta. Unfortunately they didn’t have FTP access or details so I had to get creative. Luckily, they were using VaultPress so I could generate a backup zip to download from there. Much to my surprise, I learned that the database … Learn more…

Using WP-CLI doctor Command to Fix Large wp_options autoload Data

Two of my favorite WP-CLI commands are awesome profile and doctor (see my profile tutorial) which help WordPress site administrators keep site secure, clean and fast! The WordPress database has a table called wp_options which is used to store core, theme and plugin settings. Some of these settings are very essential to each component and must … Learn more…

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…