If you’ve been working with PHP/MySQL based websites for any amount of time, you’ve probably heard about the MySQL command line tools for importing and exporting your database. The syntax is quite simple, for exports you run which exports the database to a file on the local machine. For imports you run which imports the… Continue reading Monitor MySQL command line imports and exports on Ubuntu using Pipe Viewer
One of the many little annoyances that I encounter while working on client sites, is when the client has a valid SSL certificate installed on their server, but the HTTPS redirection happens in code instead of at the server level. This means that even if I export the database with the site urls replaced to… Continue reading Setting up Trusted SSL Certificates for Local Development, Using mkcert on Ubuntu 18.04 with Apache.
It’s amazing how stories mutate. What started as a simple ‘this is my setup’ post, then turned into a ‘what a day in my life looks like’. This morning I woke up and realised it might be more interesting, and less braggy, to look at how, and why, my workstation has evolved in the last… Continue reading The evolution of a work space
One of the things I love about using Ubuntu as my primary operating system is that I can have quickly set up a ‘bare metal’ LAMP development environment. While I unusually run my client websites inside on of my custom Vagrant boxes, for working on personal projects or plugin/theme customisation everything’s much faster when it’s… Continue reading On Ubuntu 18.04, Installing MySQL Does Not Set the Root Password.
(aka the longest blog title I’ve probably ever written). Recently I reinstalled upgraded my laptop to Ubuntu 17.10 (Artful Aardvark) Ubuntu 18.04 Bionic Beaver. I’ve been wanting to upgrade since it was released in October to try out the updated Gnome interface since Ubuntu officially dropped the Unity interface for the latest release. Usually I stick with the… Continue reading Setting up the PHP Code Sniffer with WordPress Coding Standards Integration for PHPStorm on Ubuntu 18.04
About 8 years ago I built my first “proper” gaming computer, which for various reasons I nicknamed Psyrig. It wasn’t the first gaming computer that I owned, but it was the first time I carefully selected all the components, including the case, and put it together myself from the ground up. It was built to… Continue reading Upgrading the Psyrig
A modern, easy to configure, WordPress ready Vagrant box, perfect for local development. As a developer, one of the most important pieces of technology I use daily is my chosen virtual server stack. Depending on your operating system of choice, there are a few solid options out there, but since discovering Vagrant I've always preferred… Continue reading Introducing Boss Box – a WordPress ready development environment
Very recently I had the misfortune of being forced to uninstall Ubuntu from my laptop and go back to Windows. I won’t get into the reasons behind this, but the one thing I miss in the Windows environment is my LAMP (Linux/Apache/MySQL/PHP) stack and bash command line. Most web site hosts around the world use… Continue reading Setting up a local development environment with Scotch Box
This is a simple problem, with a simple solution. Which I will forget. Hence the post. The following command will list all running applications on a Linux system. The first two columns are the user running the application, and the applications program id or “pid”. Example output However, it would be ideal to search for… Continue reading Stopping unresponsive programs in Ubuntu
I’ve always setup a new CakePHP project by extracting the current stable build into a project directory and editing the core.php and database.php files manually. I usually then change to the /cake/console directory of the project and run php cake.php bake (having already installed the php-cli) to bake my code. I know there are other… Continue reading Easy CakePHP in Ubuntu