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.
Tag Archives: 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.
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.
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.