Converting WordPress Database Tables from MyISAM to InnoDB with WP-CLI

In this post I will show you how to easily convert your WordPress database tables from the MyISAM engine to the InnoDB engine with WP-CLI. In case you are wondering why you would want to do this database conversion, this StackOverflow post highlights the improvements of InnoDB over MySIAM (taking advantage of multiple cores is … Learn more…

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 Transfer + Clean WPEngine Backup Zip for Local Installation

If you have ever tried to do some tests on a local installation with a WordPress site hosted on WPEngine you may have found that it doesn’t always work right out of the box. Sometimes you just need to use XDebug with PHPStorm in a local troubleshooting environment to efficiently debug a site so a local … 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 bash Scripting to Find WP-CLI Plugin Conflicts or Errors

WP-CLI is invaluable to me so when it doesn’t work on a WooCommerce or WordPress site it’s a top priority to get it fixed and working properly! I was getting this weird error for a site where WP-CLI wouldn’t show me any information, simple commands like wp option get weren’t returning any output and simply … Learn more…