What is logical backup?

What is logical backup and physical backup?

physical backup is to copy for backing up all the physical files that belongs to database. (like data files,control files,log files, executables etc). In logical backup, you don't take the copies of any physical things,you only extract the data from the data files into dump files.

What is logical backup in MySQL?

Logical backup methods have these characteristics: The backup is done by querying the MySQL server to obtain database structure and content information. Backup is slower than physical methods because the server must access database information and convert it to logical format.

What's the difference between physical and logical backups?

In summary a logical database backup is a copy of the logical information of a database extracted and stored in a binary format. A physical database backup is a copy of the complete database contents , structure, tables and all relevant transactions you need to restore your database.

What is a physical backup?

Physical backups are copies of physical database files. For example, a physical backup might copy database content from a local disk drive to another secure location. A physical backup can be hot or cold: Hot backup—Users can modify the database during a hot backup.

What are the 3 types of backups?

The most common backup types are a full backup, incremental backup and differential backup. Other backup types include synthetic full backups and mirroring.