There are two types of backups called
1. Logical backups
2. Physical backups
1. Logical backups
Logical backups consist of the SQL statements necessary to restore the data, such as CREATE DATABASE, CREATE TABLE andINSERT.
2. Physical backups
Physical backups are performed by copying the individual data files or directories.
Logical vs Physical backups
The main differences are as follows:
logical backups are more flexible, as the...