How to Batch Zip Backup + Install WordPress Plugins with WP-CLI

During WordPress performance troubleshooting or malware investigation, you will often want to disable all of the plugins at some stage of your process. You may also want to back up all of the WordPress plugins as separate zip files for safekeeping just in case you lose track during the troubleshooting process. Re-installing all of the … Learn more…

How to Export Large WordPress Databases and Speed Up the Process

Anybody who has had to export large WordPress databases will tell you it can often be an arduous task. If the database server crashes while exporting, you have to start over. If phpMyAdmin times out because the PHP handler has a low time out, you have to start over. If you are using the command … Learn more…

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…

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…