Logical Backup
Logical backup is a copy of objects used in an application (e.g. database tables), that is made by accessing them through the application’s interfaces. Unlike physical backup which is basically file-level backup made by simple copying of the program’s files, logical backup has higher accuracy, because it allows accessing data that is kept in memory and is not yet saved on the disk.
An example of logical backup is the MySQL Backup plug-in of Handy Backup which connects to the database like a common MySQL client application and uses MySQL’s original connectors to export the data. To learn more about the plug-in, please refer to MySQL Backup.
Recommended Solution
$249 per license
Handy Backup Small Business
With the Small Business edition of our software you can protect data of your servers on both physical and logical levels. Try free for 30 days!
See also:
Learn more:
- Shared-Nothing Architecture
"Shared-nothing architecture (SNA) is a pattern used in distributing computing in which a system is based on multiple self-sufficient nodes that have their…" - MariaDB Database Engine - a Successor of MySQL
"MariaDB database engine, created by former MySQL creator Monty Widenius. Called for Monty’s daughter name, Maria ("My" in "MySQL" is for My, Monty’s son),…" - MySQLDump: What is Mysqldump used for? Alternative Solution
"The mysqldump utility is a free software allowing "logical" backup of any MySQL database by saving it to a text sequence of SQL queries. Originally developed…"