Skip navigation links

Contact Sales

USA/Canada - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-338-8100
USA/Canada - Subscription Renewals: +1-866-221-0634

Latin America: +1 512 535 7751
Brazil: +55 11 5189-1097
South Africa: +27 113194408
UK: +44 207 553 8447
Ireland: +353 1 8031050
Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Benelux: +31 30 662 7960
Italy: +39 02 249 59 120
Israel: +353 1 8031123
Spain & Portugal: +34 916312182
Sweden: +46 84773853
Other EMEA countries: +353 1 8031050
Asia Pacific: Toll Free

Contact Us Online »

MySQL Enterprise Edition Trial - Try Now
MySQL Newsletter - Subscribe Today!

MySQL Enterprise Backup

MySQL Enterprise Edition

Only available in select Commercial Editions

MySQL Enterprise Backup is the ideal solution for backing up MySQL databases.

Backup

MySQL Enterprise Backup performs online "Hot", non-blocking backups of your MySQL databases. Full backups can be performed on all InnoDB data, while MySQL is online, without interrupting queries or updates. In addition, incremental backups are supported where only data that has changed from a previous backup is backed up. Also partial backups are supported when only certain tables or tablespaces need to be backed up.

Download Whitepaper "MySQL Enterprise Backup - Fast, Consistent, Online Backups" »

Restore

MySQL Enterprise Backup restores your data from a full backup. Consistent Point-in-Time Recovery (PITR) enables DBAs to perform a restore to a specific point in time. Using MySQL backups and binlog, DBAs can also perform fine-grained roll forward recovery to a specific transaction.  A partial restore allows recovery of targeted tables or tablespaces. Plus, DBAs can restore backups to a separate location, or create clones for fast replication setup or administration.

Compression

MySQL Enterprise Backup supports creating compressed backup files, typically reducing backup size from 70% to over 90% when compared to the size of actual database files, reducing storage and other costs.

Features Benefits
Backup
Full backup A full backup is performed on all InnoDB data
Incremental backup Only data that changed since a previous backup (full or incremental)
Partial Backup A backup of particular tables or tablespaces.
Online backup of InnoDB tables The backup takes place entirely online, without preventing queries or updates
Hot and cold backup support Backups can be performed with MySQL online or offline
Recovery
Full Restore A full restore can be performed from a full backup of all InnoDB data
Consistent Point-in-Time Recovery (PITR) Perform a recovery and roll forward to a point in time
Roll forward recovery Backups can be rolled to specific transaction for finer grained recovery
Partial Restore Restore of particular tables or tablespaces
Restore to a Separate Location Restore to separate location, create clones for fast replication setup or administration
Advanced Features
Compressed backups Backup of InnoDB files can be compressed saving up to 90% of the storage
Non blocking Backup of InnoDB tables takes place entirely online, without blocking queries or updates
Backup specific tablespaces or sets of tables Improves performance, reduces backup time and lowers IO requirements
Corruption Detection Checks page checksums when copying InnoDB data and log files
Task Synchronization Allows point-in-time task synchronization of other tasks with backup
Only backs up actual data Does not copy unused blocks. Fewer reads and writes on backup and recovery, backup file use less space
Easy installation Simple to install and deploy across the enterprise
High performance Backup time is comparable to file copy, applying logs for recovery is even faster
Unlimited database size Scalable, works well for small to very large databases
Runs outside MySQL process space Eliminates risk and increases performance by running as a separate process outside the MySQL process space. MySQL Enterprise Backup does not install any additional databases, DLLs, scripts, stored procedures or tables on the MySQL instances
Scriptable Interface Command Line Interface enables you easily integrate within various scheduling systems
Storage Engines
Backup for Multiple Storage Engines and Formats InnoDB, MyISAM, Merge, Partition, Archive
Backup for MyISAM tables While the MyISAM tables are being copied, users can read MyISAM tables, but cannot modify them