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 FREE DOWNLOAD FULL#
Online full backup of MySQL server 5.7 using the MySQL Enterprise Backup 2.
0 kommentar(er)
