Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MEB 8.0.19 restore fails with " ERROR: backup_variables.txt file is missing"

3712418Mar 6 2020 — edited Mar 6 2020

Hello,

Sorry i am new to mysql so this may be an obvious fix. I am trying out Mysqlbackup 8.0.19 and when trying to restore an incremental backup it fails with the following.

MAIN   ERROR: backup_variables.txt file is missing in --datadir=/client/mydata/mysqld3308, --incremental copy-back-and-apply-log could not be performed. The validation for lsn mismatch between datadir and incremental backup could not be performed.

Here is the command i am using

/client/mysql/binaries/meb-8.0.19/bin/mysqlbackup

        --datadir=/client/mydata/mysqld3308

        --backup-image=./2020-03-06_09-45-47/incrbackup_mysqld3308.mbi

        --backup-dir=/client/mysql/temp --messages-logdir=/client/mysql/temp

        --host=127.0.0.1 --port=3308 --incremental copy-back-and-apply-log

From my understanding this is created under the backupdirectory/meta and is then compared against the datadir one? I dont seem to have one in the datadir, so are there any ramifications from simply copying an existing file to datadir?

Any help would be greatly appreciated!

Comments

Post Details

Added on Mar 6 2020
1 comment
352 views