It’s not a noise, it’s a command! The awk command is one of those strange commands, much like the extinct bird with the same name. You either love it or you […]
How to use Linux sed ‘s’ function As Linux commands go, this one has a very confusing name. That is, until someone tells you that like many Linux commands, it […]
Basic troubleshooting methodology At HOSTAFRICA, we believe that troubleshooting must be structured to be useful. I find the best method is the “Macro to Micro” approach. This means that you […]
Changing a DNS record for a domain may seem like a non-issue to some people, but the implications are often not realized. At HOSTAFRICA, we realize that these can have […]
In our previous MySQL tutorial, we did some basic SELECT queries, a CONCAT for output and a JOIN to lookup data on a different table that was linked or related to […]
In our previous MySQL tutorial, we created a small database with four tables. In this article, we will learn to manipulate the data we entered using JOIN to derive data […]
Following on my previous article on databases and database planning, I have decided to add a quick practical tour of a MySQL database. MySQL and MariaDB are equivalent for the […]
This article is not from a professional SQL Database Administrator’s perspective. It is from someone who has been using MySQL, PostgreSQL and MariaDB for the last 18 years. I have found […]
LAMP Server To develop PHP web apps, you need to set up Apache, MySQL and PHP, in a LAMP Stack (Linux/Apache/MySQL/PHP) environment. You can either install the individual components i.e […]