Adminer – A Full-Featured MySQL Database Management Tool
Formerly phpMyAdmin, Adminer is a front-end database management tool written in PHP. Unlike phpMyAdmin, it only comprises a single PHP file that can be downloaded on the target server on …
MySQL Backup and Restore Commands for Database Administration
This article shows you several practical examples on how to perform various backup operations of MySQL/MariaDB databases using the mysqldump command and also we will see how to restore them …
8 Best MySQL/MariaDB GUI Tools for Linux Administrators
MySQL is one of the most widely-used open-source relational database management systems (RDBMS), that has been around for a long time. It is an advanced, fast, reliable, scalable, and easy-to-use …
PHP MySQL ORDER BY Clause
This guide describes how to select data from a MySQL database table and sort the data by a specific column in ascending or descending order with ORDER BY clause using …
PHP MySQL DELETE, TRUNCATE, DROP Table
In this guide, we will discuss how to perform DELETE, TRUNCATE, And DROP operations on a MySQL database table using PHP in XAMPP in Linux. Before getting into the topic, …
PHP MySQL Logical Operators
This tutorial explains how to select data from a database using WHERE clause and SELECT query with MySQL logical operators such as BETWEEN, IN, AND, OR etc., in PHP. We …
PHP MySQL LIKE Operator
In this guide, we will discuss how to select data from a table using MySQL LIKE operator and WHERE clause along with the SELECT command in a particular database using …
PHP MySQL WHERE Clause
In this guide, we will discuss how to select the records from a MySQL database based on specific conditions with the WHERE clause and the SELECT command using PHP in …
PHP MySQL Select Data
This tutorial walks you through the steps to select data in a table from a MySQL database using PHP in XAMPP stack. Prerequisites Make sure you have set up the …
How to Install dbWatch to Monitor MySQL Performance in Linux
dbWatch is a powerful, multi-platform, fully-featured, and enterprise-grade SQL database monitoring and management tool that gives you full control over your database instances and system resources. It is highly scalable, …