This is a blog mostly about WordPress tips and tricks, I've also got some server related stuff, and work-related tips for businesses. Start by picking a category or feel free to reach out for help.
Zip a directory but exclude certain folders, but why?
I wanted to backup my WordPress site but exclude the backups folder, so this command came in handy. For the database backup I exported it as a sql file using WP-CLI. wp export db The zip file then can be transferred using SCP. scp /home/mysite/backups/backup.zip [email protected]:/tmp/ scp /home/mysite/database.sql [email protected]/tmp/ Relocate the zip file and database.…
Query Monitor detects slow plugins, themes and functions
For WordPress there are many plugins and themes. Unfortunately, their focus is often not on performance. This plugin helps you to identify the slow components of your website. Most performance breaks in WordPress can be identified very well and quickly in the front end, but sometimes it is necessary to look under the hood to see what…
QR Code creation
First up this is for MacOS at the moment, if there is any interest in a Windows option leave a comment. I also won’t go into installing Homebrew too much but you will need this, start by opening a terminal window and enter: Use this to then install qrencode. To get started with creating QR…
SSH into your website via a mobile phone
SSH can be tricky on a mobile device, but it’s also very powerful since you can achieve a lot using just a short command rather than booting up your machine to do much the same. It can quickly save you from downtime if your alerted to your site being down due to apache crashing and…
Add MySQL Index to WordPress Tables
A great example where an index may be a good option is the wp-options table, it can become bloated due to settings placed there by themes and plugins. This is because many plugins and theme builders store large amounts of transient or session data in the options table. If you’d like to speed up the WP-Admin…
Compressing with Squash File System
I still always learn something new, SquashFS had it passed me by and I hadn’t taken notice of how useful it can be to compress directories for transfer. The task was compress a load of big directories with tons of small files in them so I can transport them via SSH. I always tend to zip…
SSH into a website using MacOS
SSH can be a great way to work with your WordPress website It’s pretty basic to use it as a replacement for insecure FTP, all you need is a username, password and IP address or valid hostname. On a mac it’s easy to get started. Open terminal by pressing CMD ⌘ + spacebar to open Spotlight…