Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 2

Displaying posts with tag: copy-back-and-apply-log (reset)

Faster and Space efficient Restore with MySQL Enterprise Backup
Employee +1 Vote Up -0Vote Down

A typical backup cycle with MySQL Enterprise Backup had always involved 3 steps:

1. backup (to directory)

2. apply-log (prepare the backup)

3. copy-back (restore)

In case of directory, the 'apply-log' is done on the backup directory which does not involve any additional space.

But in case of image, the image has to be extracted, before doing 'apply-log'. This involves additional space for extraction of image and the steps involved are:

1. backup-to-image

2. Extract

3. apply-log

4. copy-back

How about, combining the 3 steps – extract, apply-log …

  [Read more...]
How to restore directly on a remote machine from the backup stream
Employee +0 Vote Up -0Vote Down

MySQL Enterprise Backup has been improved to support single step restore from the latest release 3.9.0. It enables you to restore the backup image to remote machine in single step. However, first you would have to create the backup image in local disk, copy the backup image to remote machine, and then restore in remote machine by running copy-back-and-apply-log command. …

  [Read more...]
Showing entries 1 to 2

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.