How to Purge Binary Logs in MySQL:
Do you know what is Binary Log in MySQL? Binary logs are transactional logs in MySQL. Whatever changes are made to the database, that is stored in the Binary Logs.…
How to download Oracle 19c client:
Oracle client is software that helps to communicate between Oracle database and client applications such as SQL*plus, SQL developer, Putty, or mobaxterm. To download Oracle 19c client, first open the…
How to Enable/Disable Binlogs in MySQL :
Binlogs in MySQL are like transactional logs which are also called binary logs. So whatever changes are made to the database, like any insert, delete, etc that information is stored…
How to check Audit logs in MySQL :
Do you know why audit logs are required in MySQL and if you are looking for the same, then this article is for you. Today in this article, we will…
How to create Oracle database manually:
In this article, I will show you the detailed steps on how to create Oracle database manually. I think you all know how to create Oracle database through DBCA GUI…
How to Restore Mysql Database and Tables :
In our previous article, we have already seen how to take a backup of MySQL databases and tables. So today we will learn about how to restore MySQL database and…
How to create and drop oracle database using DBCA silent method:
You can create and drop oracle database using DBCA silent method. In this article, I will show you the detailed steps for the same: create and drop Oracle database using…
How to take MySQL database and table backup: mysqldump
Do you know how to take the MySQL database and table Backup? Today we will learn about this. Generally, in MySQL, Backup can be taken in three ways: i) mysqldump…
How to create Oracle database using GUI – Graphical User Interface Method:
we can create an Oracle Database using the below two methods: Using the DBCA Method Using Manual/Command line Method DBCA stands for Database Configuration Assistant - It is a utility…
How to Install Oracle 19c software on VirtualBox: Easy step-by-step Guide
If you have already installed Oracle VirtualBox and the Linux operating system, you can proceed with the Install Oracle 19c software part. If you do not have a virtual Box…