MySQL Articles

Database Upgrade Problems! MySQL 5 → 8 with WordPress My webhost upgraded their database server from MySQL 5 to 8. The upgrade itself went smoothly, but I did find some after-effects on my WordPress sites
First Stab at WordPress/MySQL Tuning (Obsolete) My job sent me to a class on scaling, optimizing and troubleshooting MySQL this week.
Moving WordPress: Finding and Updating Old Paths How to find every last reference to the old path in the entire site and config because WordPress stores absolute paths all over the place and some configurations will break if you don't update it.
WordPress 5.7 Upgrade Breaks Posts with Emoji in the Title? Posts with emoji in the title mysteriously stopped displaying anywhere on the blog except the edit form, possibly due to mismatched character sets.