SysAdmin

The article provides many images that guide you through each individual step of a MySQL installation on Windows. The elaborate setup is made easy with clear instructions and concise descriptions of each particular option.

This guide is for users who are running a Debian 9 server with Apache, MySQL, and PHP. The phpMyAdmin software tool is used for managing MySQL databases through a graphical interface. It can be configured to manage a local database, or a remote database (over the network). It replaces the awkward default command-line interface which can be used for database management.

This guide lists all the steps necessary to install Ubuntu MATE on your Raspberry Pi. This includes downloading an image, formatting your SD card, and using Etcher.

Snapshot and backups are similar yet different in terms of how they are used and how they store data. In this article we will explain what snapshots and backups are, how they work and what is the difference between the two.

There are three basic types of backups: full, incremental and differential. Each option has its pros and cons. Configuring your backup plan with one or the other will depend on your needs, priorities and resources. Learn more about different types of backups here.

Configure CentOS network settings using the command line or the Network Manager TUI. This guide shows you how to change network specifications and set up a static IP or configure the network interface for DHCP.

Once you install MariaDB, one of the first things you need to do is to create a new MariaDB user. This article explains how to create a MariaDB user, and then how to grant privileges to the newly created user.

Learn how to export a PostgreSQL table to a .csv file. This feature is especially helpful when transferring the table to a different system or importing it to another database application. The guide shows you how to use either the COPY or the /copy command to export PostgreSQL databases and columns as .csv files.

Update your Raspberry Pi to keep it secure. In this guide you can also learn how to upgrade from an old to the latest version of Raspbian system.

Git, the popular version control system, has a plethora of commands for managing your project history. This article lists out all the important commands every developer will need at some point. For future reference, it includes a downloadable PDF Git commands cheat sheet.