How to import a large MySQL database via SSH
Importing a large database through phpMyAdmin can fail mid-way due to connection timeouts or file size limits, leaving your database in an incomplete state. Running the import over SSH sends the file directly to MySQL from the server, bypassing those…
How to use SVG images in WordPress
WordPress does not allow SVG file uploads by default, treating them as a security risk because SVGs can contain embedded scripts. The Safe SVG plugin sanitises SVG files on upload, removing potentially harmful code so you can use them safely through the Media…
How to use SSH key pairs on macOS with cPanel
Password-based SSH logins are vulnerable to brute-force attacks. Key pair authentication replaces your password with two cryptographic files: a private key that stays on your Mac and a public key that you upload to your cPanel account. Only someone holding…
How to disable WP-Cron and set up a cPanel cron job
WordPress does not have a real task scheduler. Instead, it fires its scheduled tasks on every page request by running wp-cron.php whenever a visitor loads a page. On a site with significant traffic this means the same scheduled task may run hundreds of times…
How to fix cURL error 60 in WordPress
The cURL error 60: SSL certificate problem: certificate has expired error appears in WordPress when outgoing HTTP requests fail SSL verification. This breaks plugin and core updates, third-party API calls and any feature that uses WordPress’s HTTP API…
How to use SSH and SFTP key authentication on Windows
Password-based SSH and SFTP logins are vulnerable to brute-force attacks. Key authentication replaces the password with a cryptographic key pair – a private key that stays on your machine and a public key installed on your server. Only someone holding…
How to change MX records in cPanel
MX (Mail Exchange) records tell the internet which mail servers handle email for your domain. If you are switching to a third-party email provider or setting up custom mail routing, you will need to update these records in cPanel’s Zone Editor. This…
How to set a user agent for your web application
Web servers and APIs often block or rate-limit requests that arrive without a user-agent string. This happens because missing user agents are a common trait of poorly configured scripts and automated abuse. Setting a descriptive user-agent string in your…
How to schedule automatic server reboots with cron
Servers can accumulate memory leaks, stale processes and temporary file build-up over time. Scheduling a periodic reboot clears these issues automatically, without requiring manual intervention at unsociable hours. You will edit the root crontab to add a…
How to install ImageMagick and imagick on cPanel
ImageMagick is a system-level image processing library, and the imagick PHP extension gives your PHP applications access to it. Many WordPress plugins and PHP scripts depend on imagick to resize, compress or convert images on the server. You will install…
