Hi everyone,
We lost one schema in our database a few days ago. We have backups generated and stored daily using the following:
$ innobackupex --defaults-extra-file=/root/.my.cnf --no-timestamp --stream=tar ./ | gzip - > backupfile.tar.gz
The above is generated on the following system:
We have our backup file and we’re trying to recover it on a different system first, because we don’t want to stop the production database server right away and we don’t want to mess up our existing data if the recovery goes wrong. So I’m trying the following:
$ tar -zxvf backupfile.tar.gz
$ innobackupex --defaults-file=./backup-my.cnf --apply-log .
On the following system:
Sadly, I’m always getting this error:
Log file ./ib_logfile1 is of different size 50331648 bytes than other log files 8388608 bytes!
Is there anything I can do to resolve this problem?