One way to achieve this is to move the data directory aside to a unique directory name:
Mysql enterprise backup free download full#
When MariaDB Enterprise Backup restores from a backup, it copies or moves the backup files into the MariaDB Enterprise Server data directory, as defined by the datadir system variable.įor MariaDB Enterprise Backup to safely restore data from full and incremental backups, the data directory must be empty. Running the -prepare command on data that is to be used for a partial restore (when restoring only one or more selected tables) requires that you also use the -export option to create the necessary.
Running the -prepare command on an incremental backup synchronizes the tablespaces and also applies the updated data into the previous full backup, making it a complete backup ready for use in recovery. Running the -prepare command on a full backup synchronizes the tablespaces, ensuring that they are point-in-time consistent and ready for use in recovery. To restore from a backup, you first need to prepare the backup for point-in-time consistency using the -prepare command: Incremental backups produced using MariaDB Enterprise Backup contain only the changes since the last backup and cannot be used standalone to perform a restore.
Full backups produced using MariaDB Enterprise Server are not initially point-in-time consistent, and an attempt to restore from a raw full backup will cause InnoDB to crash to protect the data.