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…