Tag Archives: Database

How To Upgrade MariaDB Version 10.1 to 10.3

Upgrade mariadb 10.1 to 10.3

This short guide will show you how to upgrade MariaDB 10.1 to 10.3 in CentOS 7 Linux. We’ll start by modifying the repository file and perform a ‘yum update’. This may fail to automatically update the MariaDB-server package, so I’ll show you how to manually use the mysql_upgrade script to complete the process.

Read more »

How To Upgrade MariaDB 10.0. to 10.1 in CentOS 7

How to upgrade MariaDB 10.0 to 10.1

This short guide will show you how to upgrade MariaDB 10.0 to 10.1 in CentOS 7 Linux. We’ll start by modifying the repository file and perform a ‘yum update’. This may fail to automatically update the MariaDB-server package, so we’ll show you how to manually use the mysql_upgrade script to complete the process.

Read more »

How To Perform Simple SQL Queries Against a Database

Database

This quick guide will show you how to perform very simple SQL queries against a MariaDB/MySQL database as per the RHCE exam objective and is not designed to be an in depth SQL tutorial.

Here we will cover using basic SQL queries such as show, create, select, insert, update, delete, describe, and drop which will allow us to define a basic database schema.

Read more »

Backup and Restore a MariaDB/MySQL Database

Database Backup

It is critical to regularly take a backup of important data that is stored within a database so that the data can be restored in the event of any problem. Examples of such problems include database server failure, data tampering, corruption and any other number of file system specific problems that are looking to do your database harm.

Here we will cover how to backup and restore an SQL database from MariaDB/MySQL. Read more »

How To Install and Configure MariaDB

Maria DB Logo

MariaDB is a drop in replacement for MySQL and is an open source fork of MySQL created by the original MySQL developers. As of Red Hat Enterprise Linux (RHEL7) and CentOS 7 MariaDB is now the default SQL database, rather than MySQL which was the default in previous releases of the operating system.

Here we’re going to cover how to install and configure MariaDB.

Read more »