Recently, one of my clients encountered a significant issue when they lost their entire wp_postmeta table, and unfortunately, there was no backup available. Our only viable option was to recreate the table and manually add the post meta. However, this posed a new problem. The website has thousands of media files, which became unusable as… Continue reading How to restore/regenerate missing attachment metadata in WordPress
How to completely uninstall/remove New Relic PHP agent from Ubuntu
Working with numerous clients to resolve performance issues in their WordPress sites, New Relic has been a steadfast ally, aiding me in monitoring performance and gathering vital insights to enhance site speed and functionality. While New Relic proves invaluable during the debugging phase, there comes a a time when a thorough cleanup is needed, especially… Continue reading How to completely uninstall/remove New Relic PHP agent from Ubuntu
Migrate email accounts from cPanel to Another cPanel
When transferring cPanel accounts, there is the “Transfer tool” that comes with the tools provided as part of WHM. However, if you have already built a website on a new cPanel account, and only want to copy or migrate email accounts over from the old cPanel account, the previously mentioned tool will not help. There… Continue reading Migrate email accounts from cPanel to Another cPanel
How to find closest locations using coordinates with SQL
Many existing apps nowadays are offering the ability to display nearest records, these records can be user profiles, actual places or anything that can be linked to a location. This is certainly a useful feature and there is a high chance you’d need to make such an implementation, either for a client, or for your… Continue reading How to find closest locations using coordinates with SQL
How to highlight active links for one-page navigation with JavaScript
One of my clients wanted to highlight the currently active menu items from the navbar as the user scrolls through their one page website sections. I implemented the requested feature and I thought I would share how it was achieved. Here is a simple demonstration of the mentioned effect. Notes Let’s get started. First of… Continue reading How to highlight active links for one-page navigation with JavaScript
Rename WooCommerce in admin dashboard menu
When setting up a WooCommerce store, you might find yourself looking for a way to rename the WooCommerce label in WordPress admin dashboard to something else. There are different cases in which you’d need to make such a change, for me it was because I needed to hide WooCommerce reference from a custom user role… Continue reading Rename WooCommerce in admin dashboard menu
Automate cron job creation using a Bash script
There is a pretty straight forward way to implement cron jobs using Bash shell. However, it’s a manual process and it looks like this: Run `crontab -e` to open the current user crontab file using the default editor ( you need to select a default editor “nano, vim..” if it’s the first time ) Add… Continue reading Automate cron job creation using a Bash script
WordPress Git deployments for Kinsta via SSH
I’ve interacted with a number of different WordPress hosts over the last few years, but Kinsta has been the best by far in terms of support, performance, and security. Since I’ve been recommending Kinsta for every new client, I’ve decided I needed an easy & fast process to develop new features on my local server… Continue reading WordPress Git deployments for Kinsta via SSH