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!