Not the answer you need?
Register and ask your own question!

Probleme Backup restore

ytheaudinytheaudin EntrantCurrent User Role Beginner
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 [EMAIL="root@XX.XX.XX.XX"][email protected][/EMAIL] "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
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.