Category: WordPress

How to migrate from WordPress.com using SCP via SSH

I recently took on a project involving the migration of a WordPress website from WordPress.com, which is a hosting service for WordPress.org. The client had a desire to move their WordPress site away from WordPress.com. This presented a bit of a challenge because WordPress.com doesn’t allow direct file transfers to another server using SSH commands… Continue reading How to migrate from WordPress.com using SCP via SSH

The correct way to set WordPress File Permissions using SSH

Understanding and correctly configuring file permissions in WordPress is crucial for maintaining the security and integrity of your website. This simple guide will walk you through the main steps to adjust WordPress file permissions using SSH (Secure Shell). By following these steps, you can secure your WordPress installation effectively. Step 1: SSH into Your Server… Continue reading The correct way to set WordPress File Permissions using SSH

Published
Categorized as WordPress

How to restore/regenerate missing attachment metadata in WordPress

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

Published
Categorized as 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

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