Not the answer you need?
Register and ask your own question!

xtrabackup fails because logfile size

gmldbagmldba EntrantLegacy User Role Beginner
I created a Management server (man1) and I am trying to backup a server (MySQL1) executing xtrabackup from man1. But I keep getting the following error:
180816 18:53:58 version_check Connected to MySQL server
180816 18:53:58 version_check Executing a version check against the server...
180816 18:53:58 version_check Done.
180816 18:53:58 Connecting to MySQL server host: zipdata704a.orl.voxeo.net, user: super, password: set, port: 0, socket: /var/lib/mysql/mysql.sock
Using server version 5.6.39-log
xtrabackup version 2.3.6 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 32768
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = /var/lib/mysql
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = /var/lib/mysql
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5368709120
InnoDB: Error: log file /var/lib/mysql/ib_logfile0 is of different size 50331648 bytes
InnoDB: than specified in the .cnf file 5368709120 bytes!

What can I do?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.