Innodb_buffer_pool_filename = ib_buffer_poolĭatadir = /backup-mysql/09-05-2019/datadir Innodb_log_group_home_dir = /var/lib/mysql Innodb_data_file_path = ibdata1:12M:autoextend In that case you need to add 'innodb_log_file_size=50331648' to the target server configuration.ġ90510 01:14:56 MAIN INFO: MEB logfile created at /backup-mysql/09-05-2019/meta/MEB_.01-14-56_copy_back.log In that case you need to add 'innodb_log_files_in_group=2' to the target server configuration.ġ90510 01:14:56 MAIN WARNING: If you restore to a server of a different version, the innodb_log_file_size parameter might have a different default.
In that case you need to add 'innodb_data_file_path=ibdata1:12M:autoextend' to the target server configuration.ġ90510 01:14:56 MAIN WARNING: If you restore to a server of a different version, the innodb_log_files_in_group parameter might have a different default. IMPORTANT: Please check that mysqlbackup run completes successfully.Īt the end of a successful 'copy-back' run mysqlbackupġ90510 01:14:56 MAIN INFO: MySQL server version is '5.7.26-log'ġ90510 01:14:56 MAIN INFO: Restoring …5.7.26-log versionġ90510 01:14:56 MAIN WARNING: If you restore to a server of a different version, the innodb_data_file_path parameter might have a different default. backup-dir=/backup-mysql/09-05-2019 -datadir=/var/lib/mysql copy-back # /opt/mysql/meb-4.1/bin/ mysqlbackup - backup-dir=/backup-mysql/09-05-2019 - datadir=/var/lib/mysql copy-back To restore The backup, we are going to use the option copy-back. Our MySQL Enterprise Backup is located under / backup-mysql/09-05-2019. Step 1: I have cleaned the data directory: # rm -rf /var/lib/mysql/*
We have the same MySQL Server version as the Version of the Backup server.Ī.
MYSQL ENTERPRISE BACKUP PERFORMANCE FULL
Online full backup of MySQL server 5.7 using the MySQL Enterprise Backup 2.
0 kommentar(er)
