Linux Basics – awk 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 […]
Linux Basics – sed 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 […]
Troubleshooting website issues 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 […]
Howto – A short MySQL tutorial with examples – 03 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 […]
Howto – A short MySQL tutorial with examples – 02 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 […]
Howto – A short MySQL tutorial with examples – 01 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 […]
Planning Your SQL Database Structure 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 […]
Installing Apache/MySQL/PHP On Linux (LAMP Stack) 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 […]
Some easy diagnostic tools for everyone Struggling to connect to your email or website? Cannot see if your server is up or not? Here are a few tips and diagnostic tools to help you get a […]
