Sunday, February 5, 2023

MYSQL::MEB Database backup restore Error #The innodb_log_file_size value 4294967296 is invalid. The backup has been taken with 1073741824.

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

MYSQL::Setting Validate_Password componet for MySQL Database to ensure password policy settings

Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...