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 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.
A short while ago I posted about testing if a variable exists in a list and I spoke about the MySQL “IN” keyword. I realised this week that not everyone knows about the MySQL “IN” keyword, so I’ve decided to explain this very handy SQL keyword. Lets say you have a user table with the… Continue reading MySQL: filtering results from a list of id's