How to Backup and Restore a PostgreSQL Database in Linux
In a production environment, no matter how large or small your PostgreSQL database may be, regular backup is an essential aspect of database management. In
Databases
Databases like MySQL, Oracle, PostgreSQL, MongoDB and CouchDB
20 Most Commonly Asked MySQL Interview Questions
In today’s world where data becomes increasingly crucial for businesses and organizations, the ability to manage and analyze data efficiently is more important than ever.
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,
20 mysqladmin Commands for MYSQL/MariaDB Database Administration
mysqladmin is a command-line database administration utility that comes with MySQL/MariaDB server, which is used by Database Administrators to perform some basic MySQL tasks such
Adminer – A Full-Featured MySQL Database Management Tool
Formerly phpMinAdmin, Adminer is a front-end database management tool written in PHP. Unlike phpMyAdmin, it only comprises a single PHP file that can be downloaded
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
How to Setup MySQL Replication in RHEL, Rocky and AlmaLinux
Data replication is the process of copying your data across multiple servers to improve data availability and enhance the reliability and performance of an application.
How to Install MySQL 8.0 on RHEL/CentOS 8/7 and Fedora 35
MySQL is an open-source free relational database management system (RDBMS) released under GNU (General Public License). It is used to run multiple databases on any
How to Install SQLite and SQLite Browser in Ubuntu
SQLite is a lightweight, small and self-contained RDBMS in a C library. Popular databases like MySql, PostgreSQL, etc. works in the client-server model and they
How to Install CouchDB on Debian 10
CouchDB is a high-performance opensource NoSQL solution where data is stored in JSON-based document format as key/value pairs, lists, or maps. It provides a RESTFUL
How to Install Apache CouchDB in Ubuntu 20.04
Implemented in Erlang, Apache CouchDB, simply referred to as CouchDB, is an open-source NoSQL database that focuses on data storage in JSON format. CouchDB is
How To Create a New User and Grant Permissions in MySQL
MySQL is a popular and widely used database management system that stores and organizes data and allows users to retrieve it. It comes with a