Include Tables - Backup only required tables for better granularity and usability.Binlog and Relay log backup - Simplifies cloning source to replica servers for HA replication.Exclude Tables - Exclude unnecessary tables from your Backups, saving backup time and space.Backup Validation - Provides assurance checks to confirm backup integrity and quality by confirming that internal pages are valid and file checksums match.
Mysql enterprise backup restore examples full#
Streaming "Zero storage" Single Step Backup and Restore - Run a full or partial backup from one server and a restore to another in one streamed step without staged storage.NEW! Supports MySQL TDE - Enables secure archival quality backup and restore of TDE encrypted database files and keys.AES 256 encryption - Built in 256-bit Advanced Encryption Standard (AES) encryption to secure all the sensitive backup data.Advanced LZ4 Compression - Support highly efficient, low impact and ultra fast LZ4 compression, as well as LZMA and zlib.For an overview of partial backup and restore, as well as usage examples on the following options, see Section 4.3.5, Making a Partial Backup and Section 5.1.4, Table-Level Recovery (TLR). Direct Cloud Storage Backup via S3 and Swift APIs - Backup and Restore directly to/from Oracle Storage Cloud, S3 and other Cloud Storage using AWS S3 API To select specific data to be backed up or restored, use the partial backup and restore options described in this section.Online "Hot" Selective Restore - bring back only selected tables into a running database.Point-in-Time Recovery (PITR) - Recover to a specific transaction.Fast Recovery - Get servers back online and create replicated servers.Advanced Optimistic Backup - Uses heuristics to optimize and reduce backups and shorten recovery time by assessing usage patterns.Full Instance Backup - Backs up data, as well as configuration and other information to easily create a complete "replica".Partial Backup - Target particular tables or tablespaces.Incremental Backup - Backup only data that has changed since the last backup.High Performance - Save time with faster backup and recovery."Hot" Online Backups - Backups take place entirely online, without interrupting MySQL transactions.Download White Paper: MySQL Enterprise Backup - Fast, Consistent, Online Backups »