mysql upcase_MySQL8.0EnterpriseBackup（testcase）

###################################################

MySQL8.0 Enterprise Backup

###################################################

----------------------------------

Backing up an Entire MySQL Instace

----------------------------------

https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/meb-using.html

---------1.Backing up an Entire MySQL Instance

open MySQL Enterprise Backup Command Prompt

mysqlbackup --user=root --password --host=localhost

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp backup-to-image

C:\Program Files\MySQL\MySQL Enterprise Backup 8.0>

C:\Program Files\MySQL\MySQL Enterprise Backup

8.0>mysqlbackup --user=root --pas

sword --host=localhost

--backup-image=G:\mysqlbackup\backups\kylix.mbi --backup-

dir=G:\mysqlbackup\backup-tmp backup-to-image

MySQL Enterprise Backup version 8.0.11

Windows-10.0.14393-AMD64 [2018-04-08 07:

25:48]

Copyright (c) 2003, 2018, Oracle and/or its affiliates. All

Rights Reserved.

180425 14:38:05 MAIN INFO: A thread created with Id '3164'

180425 14:38:05 MAIN INFO: Starting with following command line ...

mysqlbackup --user=root --password

--host=localhost

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

backup-to-image

180425 14:38:05 MAIN INFO:

Enter password: ************

180425 14:38:10 MAIN INFO: No SSL options specified.

180425 14:38:11 MAIN INFO: MySQL server version is '8.0.11-commercial'

180425 14:38:11 MAIN INFO: MySQL server compile os version is 'Win64'

180425 14:38:11 MAIN INFO: SSL/TLS version used for connection is TLSv1.2

180425 14:38:11 MAIN INFO: Got some server configuration information from run

ning server.

IMPORTANT: Please check that mysqlbackup run completes

successfully.

At the end

of a successful 'backup-to-image' run mysqlbackup

prints

"mysqlbackup completed OK!".

180425 14:38:11 MAIN INFO: KEF target path:'G:/mysqlbackup/backup-tmp/meta/ke

yring_kef'

180425 14:38:11 MAIN INFO: TDE Keyring service initialized.

180425 14:38:11 MAIN INFO: MEB logfile created at G:\mysqlbackup\backup-tmp\m

eta\MEB_2018-04-25.14-38-11_image_backup.log

--------------------------------------------------------------------

Server

Repository Options:

--------------------------------------------------------------------

datadir = C:\ProgramData\MySQL\MySQL

Server 8.0\Data\

innodb_data_home_dir =

innodb_data_file_path = ibdata1:12M:autoextend

innodb_log_group_home_dir = C:\ProgramData\MySQL\MySQL

Server 8.0\Data\

innodb_log_files_in_group = 2

innodb_log_file_size = 50331648

innodb_undo_directory = C:\ProgramData\MySQL\MySQL Server

8.0\Data\

innodb_undo_tablespaces = 2

innodb_buffer_pool_filename =

ib_buffer_pool

innodb_page_size = 16384

innodb_checksum_algorithm = crc32

--------------------------------------------------------------------

Backup

Config Options:

--------------------------------------------------------------------

datadir =

G:\mysqlbackup\backup-tmp\datadir

innodb_data_home_dir =

G:\mysqlbackup\backup-tmp\datadir

innodb_data_file_path = ibdata1:12M:autoextend

innodb_log_group_home_dir =

G:\mysqlbackup\backup-tmp\datadir

innodb_log_files_in_group = 2

innodb_log_file_size = 50331648

innodb_undo_directory = G:\mysqlbackup\backup-tmp\datadir

innodb_undo_tablespaces = 2

innodb_buffer_pool_filename =

ib_buffer_pool

innodb_page_size = 16384

innodb_checksum_algorithm = crc32

Backup Image Path = G:\mysqlbackup\backups\kylix.mbi

180425 14:38:11 MAIN INFO: Unique generated backup id for this is

15246382916965253

180425 14:38:11 MAIN INFO: Creating 14 buffers each of size 16777216.

180425 14:38:11 MAIN INFO: Full Image Backup operation starts with following

threads

1

read-threads 6

process-threads 1

write-threads

180425 14:38:11 MAIN INFO: Found checkpoint at lsn 19223671.

180425 14:38:11 MAIN INFO: Starting log scan from lsn = 19223552 at offset =19217408 and

checkpoint = 19223671 in file C:/ProgramData/MySQL/MySQL Server

8.0/Data/ib_logfile0.

180425 14:38:11 RDR1 INFO: A thread created with Id '4848'

180425 14:38:11 PCR1 INFO: A thread created with Id '4008'

180425 14:38:11 PCR2 INFO: A thread created with Id '1112'

180425 14:38:11 PCR4 INFO: A thread created with Id '3716'

180425 14:38:11 RLW1 INFO: A thread created with Id '4852'

180425 14:38:11 RLR1 INFO: A thread created with Id '692'

180425 14:38:11 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/backup-my.cnf.

180425 14:38:11 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/meta/backup_create.xml.

180425 14:38:11 RDR1 INFO: Starting to copy all innodb files...

180425 14:38:11 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/ibdata1.

180425 14:38:11 WTR1 INFO: A thread created with Id '4972'

180425 14:38:11 PCR3 INFO: A thread created with Id '4460'

180425 14:38:11 PCR6 INFO: A thread created with Id '3456'

180425 14:38:11 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/undo_001.

180425 14:38:11 PCR5 INFO: A thread created with Id '2568'

180425 14:38:11 RLP1 INFO: A thread created with Id '3780'

180425 14:38:11 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/undo_002.

180425 14:38:11 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/sys/sys_config.ibd.

180425 14:38:11 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/mysql.ibd.

180425 14:38:13 RDR1 INFO: Completing the copy of innodb files.

180425 14:38:13 RDR1 INFO: Requesting a dump of the InnoDB buffer pool

180425 14:38:13 RDR1 INFO: Waiting for the dump of the InnoDB buffer pool to

complete

180425 14:38:13 RDR1 INFO: The dump of the InnoDB buffer pool completed

180425 14:38:13 RDR1 INFO: Starting to copy Binlog files...

180425 14:38:13 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/binlog.000001.

180425 14:38:13 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/binlog.000002.

180425 14:38:13 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/binlog.000003.

180425 14:38:13 RDR1 INFO: Preparing to lock tables: Connected to mysqld server.

180425 14:38:13 RDR1 INFO: Starting to lock all the tables...

180425 14:38:13 RDR1 INFO: Flushing the default MyISAM key cache.

180425 14:38:13 RDR1 INFO: All tables are locked and flushed to disk

180425 14:38:13 RDR1 INFO: Using checkpoint 19223671

180425 14:38:13 RDR1 INFO: Copying C:/ProgramData/MySQL/MySQL Server

8.0/Data/binlog.000004.

180425 14:38:13 RDR1 INFO: Completed the copy of binlog files...

180425 14:38:13 RDR1 INFO: Opening backup source directory 'C:/ProgramData/MySQL/MySQL

Server 8.0/Data'

180425 14:38:13 RDR1 INFO: Starting to backup all non-innodb files in

subdirectories of 'C:/ProgramData/MySQL/MySQL

Server 8.0/Data'

180425 14:38:13 WTR1 INFO: Adding database directory: datadir/mysql

180425 14:38:14 WTR1 INFO: Adding database directory: datadir/performance_schema

180425 14:38:15 RDR1 INFO: Completing the copy of all non-innodb files.

180425 14:38:15 WTR1 INFO: Adding database directory: datadir/sys

180425 14:38:15 RDR1 INFO: Requesting completion of redo log copy. Rapid: 0

180425 14:38:15 RLR1 INFO: Signaled '1' to complete log copy. Rapid = 0

180425 14:38:15 RLR1 INFO: Signaled '1' to complete log copy. Rapid = 0

180425 14:38:15 RLR1 INFO: Signaled '1' to complete log copy. Rapid = 0

180425 14:38:15 RLR1 INFO: Redo log reader waited = 0.00 ms for logs to generate.

180425 14:38:15 RLW1 INFO: A copied database page was modified at 19223671.

(This is the highest lsn

found on page)

Scanned log up to lsn

19223671.

180425 14:38:16 RDR1 INFO: All tables unlocked

180425 14:38:16 RDR1 INFO: All MySQL tables were locked for 2.183 seconds.

180425 14:38:16 RDR1 INFO: Reading all global variables from the server.

180425 14:38:16 RDR1 INFO: Completed reading of all global variables from the

server.

180425 14:38:16 RDR1 INFO: Writing config file for server '8.0.11-commercial'

.

180425 14:38:16 RDR1 INFO: Creating server config files server-my.cnf and server-all.cnf

in G:\mysqlbackup\backup-tmp

180425 14:38:16 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/meta/backup_variables.txt.

180425 14:38:16 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/datadir/ibbackup_logfile.

180425 14:38:16 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/server-all.cnf.

180425 14:38:16 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/server-my.cnf.

180425 14:38:16 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/meta/backup_content.xml.

180425 14:38:16 RDR1 INFO: Copying meta file

G:/mysqlbackup/backup-tmp/meta/image_files.xml.

180425 14:38:16 MAIN INFO: Full Image Backup operation completed successfully.

180425 14:38:16 MAIN INFO: Backup image created successfully.

180425 14:38:16 MAIN INFO: Image Path = G:\mysqlbackup\backups\kylix.mbi

180425 14:38:16 MAIN INFO: MySQL binlog position: filename binlog.000004, position

155

-------------------------------------------------------------

Parameters Summary

-------------------------------------------------------------

Start

LSN :

19223552

End LSN :

19223671

-------------------------------------------------------------

mysqlbackup completed OK!

C:\Program Files\MySQL\MySQL Enterprise Backup 8.0>

---------2.Verifying a Backup for Entire MySQL Instance

mysqlbackup --backup-image=G:\mysqlbackup\backups\kylix.mbi

validate

C:\Program Files\MySQL\MySQL Enterprise Backup 8.0>

C:\Program Files\MySQL\MySQL Enterprise Backup

8.0>mysqlbackup --backup-image=G:

\mysqlbackup\backups\kylix.mbi validate

MySQL Enterprise Backup version 8.0.11

Windows-10.0.14393-AMD64 [2018-04-08 07:

25:48]

Copyright (c) 2003, 2018, Oracle and/or its affiliates. All

Rights Reserved.

180425 14:52:30 MAIN INFO: A thread created with Id '3024'

180425 14:52:30 MAIN INFO: Starting with following command line ...

mysqlbackup

--backup-image=G:\mysqlbackup\backups\kylix.mbi validate

180425 14:52:30 MAIN INFO:

IMPORTANT: Please check that mysqlbackup run completes

successfully.

At the end

of a successful 'validate' run mysqlbackup

prints

"mysqlbackup completed OK!".

180425 14:52:30 MAIN INFO: Backup Image MEB version string: 8.0.11

[2018-04-08 07:25:48]

180425 14:52:30 MAIN INFO: MySQL server version is '8.0.11'

180425 14:52:30 MAIN INFO: TDE Keyring service initialized.

180425 14:52:30 MAIN INFO: Creating 14 buffers each of size 16777216.

180425 14:52:30 MAIN INFO: Validate operation starts with following threads

1

read-threads 6

process-threads

180425 14:52:30 MAIN INFO: Validating image ... G:\mysqlbackup\backups\kylix.mbi

180425 14:52:30 RDR1 INFO: A thread created with Id '4344'

180425 14:52:30 PCR1 INFO: A thread created with Id '3596'

180425 14:52:30 PCR1 INFO: Validate: [Dir]: meta

180425 14:52:30 PCR4 INFO: A thread created with Id '3748'

180425 14:52:30 PCR6 INFO: A thread created with Id '1624'

180425 14:52:30 PCR3 INFO: A thread created with Id '1408'

180425 14:52:30 PCR2 INFO: A thread created with Id '2624'

180425 14:52:30 PCR5 INFO: A thread created with Id '3900'

180425 14:52:30 PCR5 INFO: Validate: [Dir]: datadir/mysql

180425 14:52:30 PCR4 INFO: Validate: [Dir]: datadir/performance_schema

180425 14:52:30 PCR1 INFO: Validate: [Dir]: datadir/sys

180425 14:52:30 MAIN INFO: Total files as specified in image: 137

180425 14:52:30 MAIN INFO: datadir/ibdata1 validated.

180425 14:52:30 MAIN INFO: datadir/undo_001 validated.

180425 14:52:30 MAIN INFO: datadir/undo_002 validated.

180425 14:52:30 MAIN INFO: datadir/sys/sys_config.ibd validated.

180425 14:52:30 MAIN INFO: datadir/mysql.ibd validated.

180425 14:52:30 MAIN INFO: Validate operation completed successfully.

180425 14:52:30 MAIN INFO: Backup Image validation successful.

180425 14:52:30 MAIN INFO: Source Image Path = G:\mysqlbackup\backups\kylix.mbi

mysqlbackup completed OK!

C:\Program Files\MySQL\MySQL Enterprise Backup 8.0>

---------3.Restoring a Database

mysqlbackup --datadir=C:\ProgramData\MySQL\MySQL Server

8.0\Data --backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

copy-back-and-apply-log

......

180425 16:34:50 MAIN ERROR: Found extraneous commands at the

end.

Use --help option for usage description.

mysqlbackup failed with errors!

mysqlbackup --datadir="C:\ProgramData\MySQL\MySQL Server

8.0\Data" --backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

copy-back-and-apply-log

mysqlbackup failed with errors!

mysqlbackup --defaults-file="C:\ProgramData\MySQL\MySQL Server

8.0\my.ini" --datadir="C:\ProgramData\MySQL\MySQL Server 8.0\Data"

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

copy-back-and-apply-log

mysqlbackup failed with errors!

mysqlbackup

--defaults-file=G:\mysqlbackup\backup-tmp\server-my.cnf

--datadir="C:\ProgramData\MySQL\MySQL Server 8.0\Data"

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

copy-back-and-apply-log

C:\Program Files\MySQL\MySQL Enterprise Backup

8.0\bin>mysqlbackup

--defaults-file=G:\mysqlbackup\backup-tmp\server-my.cnf

--datadir="C:\ProgramData\MySQL\MySQL

Server 8.0\Data"

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G

:\mysqlbackup\backup-tmp copy-back-and-apply-log

MySQL Enterprise Backup version 8.0.11

Windows-10.0.14393-AMD64 [2018-04-08 07:

25:48]

Copyright (c) 2003, 2018, Oracle and/or its affiliates. All

Rights Reserved.

180425 16:24:55 MAIN INFO: A thread created with Id '644'

180425 16:24:55 MAIN INFO: Starting with following command line ...

mysqlbackup

--defaults-file=G:\mysqlbackup\backup-tmp\server-my.cnf

--datadir=C:\ProgramData\MySQL\MySQL Server

8.0\Data

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

copy-back-and-apply-log

180425 16:24:55 MAIN INFO:

180425 16:24:55 MAIN ERROR: The backup directory does already

exist and is not e

mpty. Remove or clear it and retry.

mysqlbackup failed with errors!

Delete all files and directories in G:\mysqlbackup\backup-tmp

!!!!!!!!!!!!!!!!!!!!!!!

mysqlbackup --datadir="C:\ProgramData\MySQL\MySQL Server

8.0\Data" --backup-image="G:\mysqlbackup\backups\kylix.mbi"

--backup-dir="G:\mysqlbackup\backup-tmp"

copy-back-and-apply-log

C:\Program Files\MySQL\MySQL Enterprise Backup

8.0\bin>mysqlbackup --datadir="C:

\ProgramData\MySQL\MySQL Server 8.0\Data"

--backup-image="G:\mysqlbackup\backups

\kylix.mbi" --backup-dir="G:\mysqlbackup\backup-tmp"

copy-back-and-apply-log

MySQL Enterprise Backup version 8.0.11

Windows-10.0.14393-AMD64 [2018-04-08 07:25:48]

Copyright (c) 2003, 2018, Oracle and/or its affiliates. All

Rights Reserved.

180425 16:58:15 MAIN INFO: A thread created with Id '3436'

180425 16:58:15 MAIN INFO: Starting with following command line ...

mysqlbackup

--datadir=C:\ProgramData\MySQL\MySQL Server 8.0\Data

--backup-image=G:\mysqlbackup\backups\kylix.mbi

--backup-dir=G:\mysqlbackup\backup-tmp

copy-back-and-apply-log

180425 16:58:15 MAIN INFO:

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!".

180425 16:58:15 MAIN INFO: Backup Image MEB version string: 8.0.11

[2018-04-08 07:25:48]

180425 16:58:15 MAIN INFO: MySQL server version is '8.0.11'

180425 16:58:15 MAIN WARNING: If you restore to a server of a

different version,

the innodb_data_file_path 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.

180425 16:58:15 MAIN WARNING: If you restore to a server of a

different version,

the innodb_log_files_in_group parameter

might have a different default. In that

case you need to add

'innodb_log_files_in_group=2' to the target server configu

ration.

180425 16:58:15 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_log_file_size=50331648' to the target server

configuration.

180425 16:58:15 MAIN INFO: KEF source path:'G:/mysqlbackup/backup-tmp/meta'

180425 16:58:15 MAIN INFO: KEF target path:'C:/ProgramData/MySQL/MySQL Server

8.0/Data'

180425 16:58:15 MAIN INFO: TDE Keyring service initialized.

180425 16:58:15 MAIN INFO: MEB logfile created at G:\mysqlbackup\backup-tmp\m

eta\MEB_2018-04-25.16-58-15_copy_back_img_to_datadir.log

--------------------------------------------------------------------

Server

Repository Options:

--------------------------------------------------------------------

datadir = C:\ProgramData\MySQL\MySQL

Server 8.0\Data

innodb_data_home_dir = C:\ProgramData\MySQL\MySQL

Server 8.0\Data

innodb_data_file_path = ibdata1:12M:autoextend

innodb_log_group_home_dir = C:\ProgramData\MySQL\MySQL

Server 8.0\Data

innodb_log_files_in_group = 2

innodb_log_file_size = 50331648

innodb_undo_directory = C:\ProgramData\MySQL\MySQL Server

8.0\Data

innodb_undo_tablespaces = 2

innodb_buffer_pool_filename =

ib_buffer_pool

innodb_page_size = Null

innodb_checksum_algorithm = crc32

--------------------------------------------------------------------

Backup

Config Options:

--------------------------------------------------------------------

datadir =

G:\mysqlbackup\backup-tmp\datadir

innodb_data_home_dir =

G:\mysqlbackup\backup-tmp\datadir

innodb_data_file_path = ibdata1:12M:autoextend

innodb_log_group_home_dir =

G:\mysqlbackup\backup-tmp\datadir

innodb_log_files_in_group = 2

innodb_log_file_size = 50331648

innodb_undo_directory = G:\mysqlbackup\backup-tmp\datadir

innodb_undo_tablespaces = 2

innodb_buffer_pool_filename =

ib_buffer_pool

innodb_page_size = 16384

innodb_checksum_algorithm = crc32

180425 16:58:15 MAIN INFO: Creating 14 buffers each of size 16777216.

180425 16:58:15 MAIN INFO: Copy-back-and-apply-log operation starts with foll

owing threads

1

read-threads 6

process-threads 1

write-threads

180425 16:58:15 RDR1 INFO: A thread created with Id '4960'

180425 16:58:15 PCR1 INFO: A thread created with Id '1128'

180425 16:58:15 PCR5 INFO: A thread created with Id '4588'

180425 16:58:15 PCR2 INFO: A thread created with Id '2024'

180425 16:58:15 PCR1 INFO: Copying database directory: meta

180425 16:58:15 PCR3 INFO: A thread created with Id '4792'

180425 16:58:15 PCR4 INFO: A thread created with Id '3048'

180425 16:58:15 PCR6 INFO: A thread created with Id '3784'

180425 16:58:15 RDR1 INFO: Copying ibdata1.

180425 16:58:15 WTR1 INFO: A thread created with Id '1256'

180425 16:58:15 RDR1 INFO: Copying undo_001.

180425 16:58:15 RDR1 INFO: Copying undo_002.

180425 16:58:15 RDR1 INFO: Copying sys/sys_config.ibd.

180425 16:58:15 RDR1 INFO: Copying mysql.ibd.

180425 16:58:15 RDR1 INFO: Path to expand C:/ProgramData/MySQL/MySQL Server 8

.0/Data

180425 16:58:15 RDR1 INFO: Path expanded to C:/ProgramData/MySQL/MySQL Server

8.0/Data

180425 16:58:15 RDR1 INFO: Copying binlog.000001.

180425 16:58:15 RDR1 INFO: Copying binlog.000002.

180425 16:58:15 RDR1 INFO: Copying binlog.000003.

180425 16:58:15 RDR1 INFO: Path to expand C:/ProgramData/MySQL/MySQL Server 8

.0/Data

180425 16:58:15 RDR1 INFO: Path expanded to C:/ProgramData/MySQL/MySQL Server

8.0/Data

180425 16:58:15 RDR1 INFO: Copying binlog.000004.

180425 16:58:15 PCR5 INFO: Copying database directory: mysql

180425 16:58:15 PCR2 INFO: Copying database directory: performance_schema

180425 16:58:16 PCR3 INFO: Copying database directory: sys

180425 16:58:16 MAIN INFO: Total files as specified in image: 137

180425 16:58:16 MAIN INFO: MySQL server version is '8.0.11-commercial'

180425 16:58:16 MAIN INFO: Restoring ...8.0.11-commercial version

180425 16:58:16 MAIN INFO: MySQL server version is '8.0.11-commercial'

180425 16:58:16 MAIN INFO: MySQL server compile os version is 'Win64'

180425 16:58:16 MAIN INFO: Writing config file for server '8.0.11-commercial'

.

180425 16:58:16 MAIN INFO: Creating server config files server-my.cnf and server-all.cnf

in C:\ProgramData\MySQL\MySQL Server 8.0\Data

180425 16:58:16 MAIN INFO: Variable 'datadir'='C:/ProgramData/MySQL/MySQL Server

8.0/Data/'->'C:\ProgramData\MySQL\MySQL Server 8.0\Data' option

'datadir' type 0

180425 16:58:16 MAIN INFO: Variable 'datadir'='C:/ProgramData/MySQL/MySQL Server

8.0/Data/'->'C:\ProgramData\MySQL\MySQL Server 8.0\Data' option

'datadir' type 0

180425 16:58:16 MAIN INFO: Variable

'innodb_buffer_pool_filename'='ib_buffer_pool'->'ib_buffer_pool'

option 'innodb_buffer_pool_filename' type 8

180425 16:58:16 MAIN INFO: Variable

'innodb_buffer_pool_filename'='ib_buffer_pool'->'ib_buffer_pool'

option 'innodb_buffer_pool_filename' type 8

180425 16:58:16 MAIN INFO: Variable 'innodb_checksum_algorithm'='crc32'->'crc32'

option 'innodb_checksum_algorithm' type 10

180425 16:58:16 MAIN INFO: Variable 'innodb_checksum_algorithm'='crc32'->'crc32'

option 'innodb_checksum_algorithm' type 10

180425 16:58:16 MAIN INFO: Variable

'innodb_data_file_path'='ibdata1:12M:autoextend'->'ibdata1:12M:autoextend'

option 'innodb_data_file_path' type 2

180425 16:58:16 MAIN INFO: Variable

'innodb_data_file_path'='ibdata1:12M:autoextend'->'ibdata1:12M:autoextend'

option 'innodb_data_file_path' type 2

180425 16:58:16 MAIN INFO: Variable

'innodb_data_home_dir'=''->'C:\ProgramData\MySQL\MySQL Server

8.0\Data' option 'innodb_data_home_dir' type 1

180425 16:58:16 MAIN INFO: Variable 'innodb_log_file_size'='50331648'->'50331648'

option 'innodb_log_file_size' type 5

180425 16:58:16 MAIN INFO: Variable 'innodb_log_file_size'='50331648'->'50331648'

option 'innodb_log_file_size' type 5

180425 16:58:16 MAIN INFO: Variable 'innodb_log_files_in_group'='2'->'2' option

'innodb_log_files_in_group' type 4

180425 16:58:16 MAIN INFO: Variable 'innodb_log_files_in_group'='2'->'2' option

'innodb_log_files_in_group' type 4

180425 16:58:16 MAIN INFO: Variable

'innodb_log_group_home_dir'='./'->'C:\ProgramData\MySQL\MySQL

Server 8.0\Data' option 'innodb_log_group_home_dir' type 3

180425 16:58:16 MAIN INFO: Variable

'innodb_log_group_home_dir'='./'->'C:\ProgramData\MySQL\MySQL

Server 8.0\Data' option 'innodb_log_group_home_dir' type 3

180425 16:58:16 MAIN INFO: Variable 'innodb_page_size'='16384'->'16384' option

'innodb_page_size' type 9

180425 16:58:16 MAIN INFO: Variable 'innodb_page_size'='16384'->'16384' option

'innodb_page_size' type 9

180425 16:58:16 MAIN INFO: Variable

'innodb_undo_directory'='./'->'C:\ProgramData\MySQL\MySQL Server

8.0\Data' option 'innodb_undo_directory' type 6

180425 16:58:16 MAIN INFO: Variable

'innodb_undo_directory'='./'->'C:\ProgramData\MySQL\MySQL Server

8.0\Data' option 'innodb_undo_directory' type 6

180425 16:58:16 MAIN INFO: Variable 'innodb_undo_tablespaces'='2'->'2'

option'innodb_undo_tablespaces' type 7

180425 16:58:16 MAIN INFO: Variable 'innodb_undo_tablespaces'='2'->'2'

option'innodb_undo_tablespaces' type 7

180425 16:58:16 MAIN INFO: Copy-back operation completed successfully.

180425 16:58:16 MAIN INFO: Source Image Path = G:\mysqlbackup\backups\kylix.mbi

180425 16:58:16 MAIN INFO: MySQL server version is '8.0.11-commercial'

180425 16:58:16 MAIN INFO: Restoring ...8.0.11-commercial version

180425 16:58:16 MAIN INFO: Creating 14 buffers each of size 65536.

180425 16:58:16 MAIN INFO: Apply-log operation starts with following threads

1

read-threads 1

process-threads 6

apply-threads

180425 16:58:16 MAIN INFO: Using up to 100 MB of memory.

180425 16:58:16 MAIN INFO: ibbackup_logfile's creation parameters:

start lsn 19223552, end lsn

19223671,

start checkpoint

19223671.

180425 16:58:16 MAIN INFO: InnoDB: Loading the space id : 0, space name :

C:/ProgramData/MySQL/MySQL Server 8.0/Data/ibdata1.

180425 16:58:16 MAIN INFO: InnoDB: Loading the undo space id : 4294967279, space name :

C:/ProgramData/MySQL/MySQL Server 8.0/Data/undo_001.

180425 16:58:16 MAIN INFO: InnoDB: Loading the undo space id : 4294967278, space name :

C:/ProgramData/MySQL/MySQL Server 8.0/Data/undo_002.

180425 16:58:16 MAIN INFO: InnoDB: Loading the space id : 1, space name :

C:/ProgramData/MySQL/MySQL Server

8.0/Data/sys/sys_config.ibd.

180425 16:58:16 MAIN INFO: InnoDB: Loading the space id : 4294967294, space name :

C:/ProgramData/MySQL/MySQL Server 8.0/Data/mysql.ibd.

180425 16:58:16 ALW1 INFO: A thread created with Id '5072'

180425 16:58:16 ALW2 INFO: A thread created with Id '388'

180425 16:58:16 ALW4 INFO: A thread created with Id '2720'

180425 16:58:16 ALW6 INFO: A thread created with Id '1060'

180425 16:58:16 PCR1 INFO: A thread created with Id '3348'

180425 16:58:16 RDR1 INFO: A thread created with Id '3700'

180425 16:58:16 ALW3 INFO: A thread created with Id '3456'

180425 16:58:16 ALW5 INFO: A thread created with Id '3676'

180425 16:58:16 PCR1 INFO: InnoDB: Starting to parse redo log at lsn = 19223671, whereas

checkpoint_lsn = 19223671.

180425 16:58:16 PCR1 INFO: InnoDB: Doing recovery: scanned up to log sequencenumber

19223671.

180425 16:58:17 PCR1 INFO: InnoDB: Starting to apply a batch of log records to the

database....InnoDB: Progress in percent:

180425 16:58:17 PCR1 INFO: Updating last checkpoint to 19223671 in redo log/

180425 16:58:18 PCR1 INFO: Setting log file size to 50331648

180425 16:58:20 PCR1 INFO: Setting log file size to 50331648

180425 16:58:22 PCR1 INFO: Log file header:

format = 3

pad1 = 0

start lsn = 19223552

checkpoint lsn =

19223671

checksum = 2314234554

creator = MEB 8.0.11

180425 16:58:22 PCR1 INFO: We were able to parse ibbackup_logfile up to

lsn 19223671.

180425 16:58:22 PCR1 INFO: Last MySQL binlog file position 0 155, file name

binlog.000004

180425 16:58:22 PCR1 INFO: The first data file is 'C:/ProgramData/MySQL/MySQLServer

8.0/Data/ibdata1'

and the

new created log files are at 'C:\ProgramData\MySQL\MySQL Server

8.0\Data'

180425 16:58:22 MAIN INFO: No Keyring file to process.

180425 16:58:22 MAIN INFO: Apply-log operation completed successfully.

180425 16:58:22 MAIN INFO: Full Backup has been restored successfully.

mysqlbackup completed OK! with 3 warnings

C:\Program Files\MySQL\MySQL Enterprise Backup

8.0\bin>

----------------------------------

Backup Scenarios and Examples

----------------------------------

https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/mysqlbackup.tasks.html

4.3.1 Making a Single-File Backup

4.3.2 Making a Full Backup

4.3.3 Making a Differential or Incremental Backup

4.3.4 Making a Compressed Backup

4.3.5 Making a Partial Backup

4.3.6 Making an Optimistic Backup

4.3.7 Making a Back Up of In-Memory Database Data

4.3.8 Making Scheduled Backups