Announcement

Announcement Module
Collapse
No announcement yet.

Restore a backup on a remote server

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Restore a backup on a remote server

    Hi,

    I am new Percona user,
    I've managed to create a backup + prepare with innobackupex.
    My question is if the restore can be done on a different server.
    Just to clarify, I've made a successful backup + prepare on server X, now I want to restore it but on server Y (from server X), is it possible?
    I've tried to run the following command:
    innobackupex --copy-back /tmp/perconaBackup/2012-03-27_11-49-26/ --user=myuser--password=*** --remote-host=xx.x.x.xxx

    But I received the following error message:

    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona Inc 2009-2012. All Rights Reserved.

    This software is published under
    the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

    IMPORTANT: Please check that the copy-back run completes successfully.
    At the end of a successful copy-back run innobackupex
    prints "completed OK!".

    Original data directory is not empty! at /usr/bin/innobacku
    pex line 538.


    Please advise, any help will be highly appreciated.

    Thanks.

  • #2
    This means what it says. "Original data directory is not empty!", this means the directory thast is your real data directory for the mysql server is not empty. You can only copy-back if the datadir is empty. So... clean it out by deleting or moving all files, and then do the copy back.

    You can indeed restore on a different server. However, they need to be the same architecture for the most part, and the same version would be helpful as well. The backup is essentially a filesystem copy, so, that's why.

    Comment

    Working...
    X