SysAdmin

This article offers two slick methods to rename a column in a MySQL table. Use ALTER TABLE command combined with the RENAME COLUMN clause for a swift resolution. The CHANGE clause offers more options and allows you to micromanage the renaming process.

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.

This tutorial provides 20 most commonly used rsync commands for all data synchronization scenarios. Master the rsync command and discover the advantages of using it over the rcp command.

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.

Save time and effort by managing different database systems with a single tool. Find out how to set up SQL Workbench to connect to a PostgreSQL database with four (4) easy steps. Use SQL Workbench to migrate data between your databases without the need to use several concurring interfaces.

There are several methods to remove old or unused kernels. It’s also considered good system hygiene practice to prune out old files and dependencies. This guides shows you how to do delete old Linux kernels in a couple of simple steps.

Tmux is a powerful productivity tool that enhances the functionality of the Linux terminal. In this tutorial, learn how to install and use 20+ essential tmux commands to multi-task and streamline your work in the terminal.