Announcement

Announcement Module
Collapse
No announcement yet.

PB restore DB

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

  • PB restore DB

    Hello

    I have two servers with 4 master master data bases which repersente 190 GB
    I want to make a backup and restorre on another server in the cluster.
    I also tested without compression just with same problem
    I have a problem here is the backup command line I pass:
    innobackupex --compress --stream=tar .--user=root --password=xxxxxxx| gzip - | ssh root@XX.XX.XX.XX "cat - > /home/backup.tar.gz"
    then I'm a:
    tar -xizf backup.tar.gz
    And restarts the server here is the conf
    mysqld_safe --defaults-file=/etc/my.4000.cnf

    every time I plant with the server errors
    121116 10:54:49 InnoDB: Error: page 81974 log sequence number 894745883536
    InnoDB: is in the future! Current system log sequence number 799636796619.
    InnoDB: Your database may be corrupt or you may have copied the InnoDB
    InnoDB: tablespace but not the InnoDB log files. See
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recove ry.html
    InnoDB: for more information.
    121116 10:54:49 InnoDB: Error: page 81921 log sequence number 874237391143
    InnoDB: is in the future! Current system log sequence number 799636796619.
    InnoDB: Your database may be corrupt or you may have copied the InnoDB
    InnoDB: tablespace but not the InnoDB log files. See
    InnoDB: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recove ry.html
    InnoDB: for more information.
    Can you tell me if there is a solution

    thank you very much

  • #2
    Hi,

    Generally, for taking backup via xtrabackup, there are three stages.

    1. Taking backup
    2. Preparing backup
    3. Restoring backup.

    After these 3 stages, you can start the server. Can you provide me command lines for these 3 steps with output which you are using? I might be wrong but I have a doubt that you are not preparing the backup and directly restoring it.

    Comment

    Working...
    X