1 Reply Latest reply on Mar 6, 2020 4:27 PM by Dave Stokes-MySQL Community Team-Oracle

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

    3712418

      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!