This category includes most popular database technologies used almost everywhere to store the data.
In this article, we will see how to solve "pg_restore: error: input file appears to be a text format dump. Please use psql". As you might be aware that pg_dump and pg_restore are the most widely used utilities to backup and restore PostgreSQL databases. So it is not very uncommon to face an error like ... Read more
Do you want to know the steps to Backup and Restore MariaDB Database on RHEL/CentOS 7/8 ? If yes, then you have come to the right place. If you are using MariaDB Database in your Organization then it is very important for you to understand how to take backup and restore mariadb data. There are ... Read more
Are you looking for the Steps to Reset MariaDB root password on RHEL/CentOS 7/8 ? Have you forgotten the MariaDB root password ? If you are looking for the answer to these questions then you came to the right place. There is always a possibility that one can forget the root password which will further ... Read more
In this article, I will take you through 6 Simple and Easy Steps to Install MariaDB Server on Linux(RHEL/CentOS 7/8). MariaDB is an open source MySQL based relational database management system. It is probably the most popular database currently in use on Linux Based Platforms due to its various features over other databases. It offers ... Read more
In this article, I will take you through the steps to Set MariaDB root password in Linux using mysql_secure_installation tool. If you are familiar with MySQL DB in Linux then you must be aware that MariaDB has now replaced MySQL DB in Latest RHEL/CentOS Based Systems. After installing MariaDB in your server you might wonder ... Read more
In this Tutorial, I will take you through the steps to create a database in Oracle DB 12c. Oracle 12c has many new features over older versions of database like full database Caching, in-memory aggregation, attribute clustering, json support etc. You can refer Oracle 12c features to know about all such features. Every database has ... Read more
In this article, I will take you through the steps to install Oracle Database 12c. Oracle database is the most widely used database across the world due to its multiple features capability. Some of its features are:- a)Cluster Creation: Provides Real Application Cluster(RAC) Performance. b)Performance and Scalability: Provides LOB(Large Object) Performance. c)Database Security: Uses standard ... Read more
In this article, I will take you through the steps to reset MySQL root password on RedHat/CentOS 7. The MySQL root password allows the root user to have full access to the MySQL database. Reset MySQL root password Use the following steps to reset MySQL root password by using the command line interface. Step 1: ... Read more
In this article, I will take you through the concepts of SQL Injection attacks in MySQL. SQL is the acronym for Structured Query Language. It is used to retrieve and manipulate data in the database. What is SQL Injection ? SQL injection is a code injection technique, used to attack data-driven applications, in which malicious ... Read more
In this tutorial, I will take you through the steps to install and configure Redis Server on CentOS 7. It is an in-memory data structure project implementing a distributed, in-memory key-value database with optional durability. Redis supports different kinds of abstract data structures, such as strings, lists, maps, sets, sorted sets, HyperLogLogs, bitmaps, streams, and ... Read more