Learn MySQL / MariaDB for Beginners – Part 1
In this article we will show how to create a database (also known as a schema), tables (with data types), and explain how to perform Data Manipulation Language (DML) operations with data on a...
Category: MySQL
MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool
MySQL is one of the most popular database in the world. This database can be installed on the Microsoft Windows platform besides of Linux platform. Why this database is so popular? It may caused...
4 Useful Commandline Tools to Monitor MySQL Performance in Linux
There are plenty of tools to monitor MySQL performance and troubleshoot a server, but they don’t always perfect match for a MySQL developer or administrator’s for their common needs, or may not work in...
Adminer – A Advanced Web Based Databases Administration Tool for Linux
We always interact with the databases to perform tasks in various way. We may connect directly and execute the tasks using SQL CLI mode or non-DBA user prefer to use GUI tools called phpMyAdmin...
10 MySQL Database Interview Questions for Beginners and Intermediates
In our last article, we’ve covered 15 Basic MySQL Questions, again we are here with another set interview questions for intermediate users. As we said earlier these questions can be asked in Job Interviews....
15 Basic MySQL Interview Questions for Database Administrators
Prior to This Article, three articles has already been published in ‘Linux Interview‘ Section and all of them were highly appreciated by our notable readers, however we were receiving feedback to make this interactive...
Install Apache, MySQL 8 or MariaDB 10 and PHP 7 on CentOS 7
This how-to guide explains how to install the latest version of the Apache, MySQL 8 or MariaDB 10 and PHP 7 along with the required PHP modules on RHEL / CentOS 7/6 and Fedora...
MySQL Basic Database Administration Commands – Part I
Database is a structured set of data stored electronically. The concept of database was known to our ancestors even when there were no computers, however creating and maintaining such database was very tedious job....
phpMyBackupPro – A Web Based MySQL Backup Tool for Linux
phpMyBackupPro is an open source very easy to use web based MySQL backup application, written in PHP language released under the GNU GPL. It allows you to create schedule backups, restore and manage them,...
Install Innotop to Monitor MySQL Server Performance
Innotop is an excellent command line program, similar to ‘top command‘ to monitor local and remote MySQL servers running under InnoDB engine. Innotop comes with many features and different types of modes/options, which helps...
