Guides
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…
I get to do a lot of fun projects with my awesome clients on Codeable. This post was inspired by a client that wanted to delete a lot of WordPress posts with an empty title and content. I have no idea how they got there and neither did the site owner – it could have … Learn more…
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…
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…
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…