MEB Database backup restore Error:
ERROR: The innodb_log_file_size value 4294967296 is invalid. The backup has been taken with 1073741824.
=========================================================================
C:\Program Files\MySQL\mysql-backup-8.0.20\bin>mysqlbackup.exe --defaults-file=E:\workspace\data\my.ini --backup-image=E:\dumps\BACKUP\FULL_20211009_123244.img --backup-dir=C:\Temp\TMPDUMP --encrypt-password="DATABASENAME_Encrypti0n@3" copy-back-and-apply-log
MySQL Enterprise Backup Ver 8.0.20-commercial for Win64 on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Starting with following command line ...
mysqlbackup.exe --defaults-file=E:\workspace\data\my.ini
--backup-image=E:\dumps\BACKUP\FULL_20211009_123244.img
--backup-dir=C:\Temp\TMPDUMP --encrypt-password=xxxxxxxxxxxxxxxxx
copy-back-and-apply-log
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'copy-back-and-apply-log' run mysqlbackup
prints "mysqlbackup completed OK!".
210914 14:43:14 MAIN INFO: Starting to log actions.
210914 14:43:14 MAIN INFO: Backup directory exists: 'C:\Temp\TMPDUMP'
210914 14:43:14 MAIN INFO: Backup Image MEB version string: 8.0.20 [2020-03-31 10:47:11]
210914 14:43:14 MAIN INFO: MySQL server version is '8.0.20'
210914 14:43:14 MAIN ERROR: The innodb_log_file_size value 4294967296 is invalid. The backup has been taken with 1073741824.
210914 14:43:14 MAIN ERROR: Server repository configuration problem found.
mysqlbackup exit code: 7, Invalid Argument
mysqlbackup failed with errors!
=========================================================================
Solution:
modify the innodb_log_file_size parameter value from my.ini configuration file to 4294967296. Thats it.
Then try to run the MEB database restore script,it will get success.
No comments:
Post a Comment