Tag Archives: SQL

How To Setup A LAMP Web Server With CentOS 7 Linux

How To Setup LAMP Stack Web Server In CentOS 7 Linux

With the correct packages we can quickly setup a simple CentOS 7 server to run a full LAMP stack.

This will turn our Linux system into a web server capable of serving out dynamic content from a database back end.

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 »