In this article, we will see How to find the database size in MySQL using select statements and MySQL workbench tool.
Find the Database size in MySQL: Continue reading How to find the database size in MySQL
Tag: MySQL
How to install and configure Dbeaver in Ubunut for MySQL and PostgreSQL
In this artivle, we will see how to install and configure Dbeaver in Ubunut for MySQL and PostgreSQL step by step.
Dbeaver is cross-platform database tool for developers, database administrators, analysts, and everyone working with data. It supports all popular SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
Continue reading How to install and configure Dbeaver in Ubunut for MySQL and PostgreSQL
How to download and install confiure Zabbix on Ubuntu
In this article, we will see how to download and install Zabbix on Ubuntu step by step.
What is Zabbix?
Zabbix is open-source monitoring software for networks and applications. It offers real-time monitoring of thousands of metrics collected from servers, virtual machines, network devices, and web applications. Continue reading How to download and install confiure Zabbix on Ubuntu
How to download and install XAMPP on Kali Linux 2022
In this article, we will see how to download and install XAMPP on Kali Linux 2022 step by step.
What os XAMPP?
XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use.
Download XAMPP on Windows 11
Continue reading How to download and install XAMPP on Kali Linux 2022
How to download and install XAMPP on Windows 11
In this article, we will see How to download and install XAMPP on Windows 11 step by step.
What os XAMPP?
XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use.
Download XAMPP on Windows 11
Continue reading How to download and install XAMPP on Windows 11
How to download and install XAMPP on Ubuntu 22.04
In this article, we will see how to download and install XAMPP on Ubuntu 22.04 step by step. The process same for all Ubuntu versions.
What os XAMPP?
XAMPP is a completely free, easy to install Apache distribution containing MariaDB, PHP, and Perl. The XAMPP open source package has been set up to be incredibly easy to install and to use.
Download XAMPP for Ubuntu 22.04
Continue reading How to download and install XAMPP on Ubuntu 22.04
docker: Error response from daemon: Conflict. The container name is already in use by container
In this article, we will see the solution for below error.
docker: Error response from daemon: Conflict. The container name "/mysql101" is already in use by container "3258898f66a7a5fe45e5f00f870a97bcf82e700d60a3621a5a085710e8fa6e28". You have to remove (or rename) that container to be able to reuse that name. See 'docker run --help'.
It looks like a container with the name already exists in the system. We can check the output of the below command to confirm if it indeed exists:
Continue reading docker: Error response from daemon: Conflict. The container name is already in use by container
‘telnet’ is not recognized as an internal or external command operable program or batch file.
In this article, we will see the solution for the below telnet error.
'telnet' is not recognized as an internal or external command, operable program or batch file.
What is telnet
Telnet is an application protocol used on the Internet or local area network to provide a bidirectional interactive text-oriented communication facility using a virtual terminal connection.
Reason: Telnet is disabled by default.
Solution: We have to enable telnet by using below steps.
Continue reading ‘telnet’ is not recognized as an internal or external command operable program or batch file.
What is the difference between Stored Procedure and Trigger in SQL
In this article, we will see the difference between Stored Procedure and Trigger in SQL. Following are the main differences between Stored Procedure and Trigger:
| Stored Procedure | Trigger |
|---|---|
| Store Procedures are invoked explicitly | Triggers are invoked implicitly |
| Stored procedure is a user defined piece of code which may return a value (making it a function) that is invoked by calling it explicitly. | A trigger is a stored procedure that runs automatically when various events happen (eg update, insert, delete). |
What is the difference between synchronous and asynchronous Replication
Following are the difference between synchronous and asynchronous Replication.
1. Asynchronous Replication: There is delay between Master and Slave(Secondary). In this data can be replicated after the transaction has been committed on the master. Which means the slave is never ahead of the master. So, in the case of writing it is usually a little behind the master. This delay also called lag.
2. Synchronous Replication: Continue reading What is the difference between synchronous and asynchronous Replication