Using WP-CLI to Batch Update Serialized wp_options Settings

More WordPress plugins and themes are storing their settings as serialized options in the wp_options table. Sometimes we need to batch update these serialized settings for one reason or another and before it was only possible to update these programmatically with WP-CLI if the setting in the database was a simple non-serialized version. Luckily WP-CLI … Learn more…

Download WordPress Backup Fast from (S)FTP via Linux Command Line

From time to time on Codeable I need to clone a site to a VPS with root access in order to diagnose WordPress/WooCommerce performance issues. My internet connection is fast but it’s not as fast as most VPS providers’ network pipes!When SSH isn’t available so you can use rsync to copy over large files, SFTP … Learn more…

Find out which WordPress Database Options Belong to Plugins

This post will show you how to identify which WordPress plugin options in the wp_options table belong to a specific plugin. Normally developers will search in the wp_options table manually with phpMyAdmin or Adminer (WordPress plugin version) but this can often be very tedious as you have to paginate though sometimes hundreds of pages! When … Learn more…

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…