Steps to take Mysql Enterprise backup:
================================================
Commands used:
mysqlbackup --user=mysqlbackup -pxxxxxxxxxxx --port=3306 --protocol=tcp
--with-timestamp --backup-dir=D:\backuplogs --read-threads=6
--process-threads=12 --write-threads=6 --limit-memory=9999
--number-of-buffers=2000MB --no-locking --skip-relaylog --skip-binlog
--encrypt-password=xxxxxxxxxxxxxxxxx
--backup-image=D:\backuplogs\FULL_20211009_123244.img
--messages-logdir=D:\backuplogs backup-to-image
===============================================
Microsoft Windows [Version 10.0.17763.1999]
(c) 2018 Microsoft Corporation. All rights reserved.
C:\Users\kumar.velayutham>cd C:\Program Files\MySQL\mysql-backup-8.0.20\bin
C:\Program Files\MySQL\mysql-backup-8.0.20\bin>mysqlbackup --user=mysqlbackup -pmysqlbackup --port=3306 --protocol=tcp --with-timestamp --backup-dir="D:\backuplogs" --read-threads=6 --process-threads=12 --write-threads=6 --limit-memory=9999 --number-of-buffers=2000MB --no-locking --skip-relaylog --encrypt-password=PASSWORD# --backup-image="D:\backuplogs\FULL_%date:~10,4%%date:~4,2%%date:~7,2%_%time:~0,2%%time:~3,2%%time:~6,2%.img" --messages-logdir=D:\backuplogs backup-to-image
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 --user=mysqlbackup -pxxxxxxxxxxx --port=3306 --protocol=tcp
--with-timestamp --backup-dir=D:\backuplogs --read-threads=6
--process-threads=12 --write-threads=6 --limit-memory=9999
--number-of-buffers=2000MB --no-locking --skip-relaylog
--encrypt-password=xxxxxxxxxxxxxxxxx
--backup-image=D:\backuplogs\FULL_20211009_123244.img
--messages-logdir=D:\backuplogs backup-to-image
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'backup-to-image' run mysqlbackup
prints "mysqlbackup completed OK!".
210910 12:32:45 MAIN INFO: Starting to log actions.
210910 12:32:45 MAIN INFO: MEB logfile created at D:\backuplogs\MEB_2021-09-10.12-32-45_image_backup.log
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: MySQL server version is '8.0.20-commercial'
210910 12:32:45 MAIN INFO: MySQL server compile os version is 'Win64'
210910 12:32:45 MAIN INFO: SSL/TLS version used for connection is TLSv1.3
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: Got some server configuration information from running server.
210910 12:32:45 MAIN INFO: Establishing connection to server for locking.
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: Backup directory created: 'D:/backuplogs/2021-09-10_12-32-45'
210910 12:32:45 MAIN INFO: MySQL server version_comment is 'MySQL Enterprise Server - Commercial'
210910 12:32:45 MAIN INFO: Mysqlbackup component not installed.
210910 12:32:45 MAIN INFO: Server is not a community server.
210910 12:32:45 MAIN INFO: Current active keyring 'keyring_encrypted_file'
210910 12:32:45 MAIN INFO: KEF source path:'D:/workspace/keyring/keyring'
210910 12:32:45 MAIN INFO: KEF target path:'D:/backuplogs/2021-09-10_12-32-45/meta/keyring_kef'
210910 12:32:45 MAIN INFO: TDE Keyring service initialized.
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = D:\workspace\data\
innodb_data_home_dir =
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = D:\workspace\data\
innodb_log_files_in_group = 2
innodb_log_file_size = 1073741824
innodb_undo_directory = D:\workspace\data\
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = D:\backuplogs\2021-09-10_12-32-45\datadir
innodb_data_home_dir = D:\backuplogs\2021-09-10_12-32-45\datadir
innodb_data_file_path = ibdata1:12M:autoextend
innodb_log_group_home_dir = D:\backuplogs\2021-09-10_12-32-45\datadir
innodb_log_files_in_group = 2
innodb_log_file_size = 1073741824
innodb_undo_directory = D:\backuplogs\2021-09-10_12-32-45\datadir
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
Backup Image Path = D:\backuplogs\FULL_20211009_123244.img
210910 12:32:45 MAIN INFO: Unique generated backup id for this is 16312483653165319
210910 12:32:45 MAIN INFO: Copying the server config file 'D:/workspace/data/auto.cnf'
210910 12:32:45 MAIN INFO: Copying the server config file 'D:/workspace/data/mysqld-auto.cnf'
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:45 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 MAIN INFO: Creating 112 buffers each of size 16777216.
210910 12:32:46 MAIN INFO: Failed to start redo log archiving...
210910 12:32:46 MAIN INFO: Found checkpoint at lsn 402744200010.
210910 12:32:46 MAIN INFO: Starting log scan from lsn = 402744199680 at offset = 91777536 and checkpoint = 402744200010 in file D:/workspace/data/ib_logfile1.
210910 12:32:46 MAIN INFO: This backup has encrypted tables or encrypted binary log files, encrypt password is set.
210910 12:32:46 MAIN INFO: Full Image Backup operation starts with following threads
6 read-threads 12 process-threads 6 write-threads
210910 12:32:46 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:32:46 RDR2 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/backup-my.cnf.
210910 12:32:46 RDR1 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/meta/backup_create.xml.
210910 12:32:46 RDR4 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/datadir/backup-auto.cnf.
210910 12:32:46 RLP1 INFO: Starting to parse redo log at lsn = 402744199843, whereas checkpoint_lsn = 402744200010.
210910 12:32:46 RDR5 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/datadir/backup-mysqld-auto.cnf.
210910 12:32:46 RDR3 INFO: Starting to copy all innodb files...
210910 12:32:46 RDR3 INFO: Copying D:/workspace/data/ibdata1.
210910 12:32:46 RDR6 Progress in MB: 200 400 600 800 1000
210910 12:32:48 RDR4 INFO: Starting to copy all undo files...
210910 12:32:48 RDR4 INFO: Copying D:/workspace/data/undo_002.
210910 12:32:48 RDR5 INFO: Copying D:/workspace/data/undo_001.
210910 12:33:02 RDR4 INFO: Copying D:/workspace/data/sys/sys_config.ibd.
:
:
:
210910 12:40:16 RDR5 INFO: Copying D:/workspace/data/mysql.ibd.
210910 12:40:16 RDR3 INFO: Completing the copy of innodb files.
210910 12:40:16 RDR3 INFO: Requesting a dump of the InnoDB buffer pool
210910 12:40:16 RDR3 INFO: Waiting for the dump of the InnoDB buffer pool to complete
210910 12:40:17 RDR3 INFO: The dump of the InnoDB buffer pool completed
210910 12:40:17 RDR6 INFO: Binary Log Index: 'D:/workspace/data/DATABASENAMEDBUAT3-bin.index'
210910 12:40:17 RDR6 INFO: Starting to copy Binlog files.
210910 12:40:17 RDR6 INFO: Copying D:/workspace/data/DATABASENAMEDBUAT3-bin.000070.
210910 12:40:18 RDR5 Progress in MB: 39800 40000 40200 40400 40600
210910 12:40:25 RDR6 INFO: Copying D:/workspace/data/DATABASENAMEDBUAT3-bin.000071.
210910 12:40:26 RDR2 Progress in MB: 40800 41000 41200 41400 41600 41800
210910 12:40:33 RDR6 INFO: Starting to lock instance for backup...
210910 12:40:33 RDR6 INFO: The server instance is locked for backup.
210910 12:40:33 RDR6 INFO: Requesting flush of redo log reading after LSN 402744479001.
210910 12:40:33 RDR6 INFO: Requesting flush of redo log processing after LSN 402744479001.
210910 12:40:33 RDR6 INFO: Completed flush of redo log reading after LSN 402744479001.
210910 12:40:33 RDR6 INFO: Completed flush of redo log processing after LSN 402744479001.
210910 12:40:37 RDR6 INFO: Opening backup source directory 'D:/workspace/data'
210910 12:40:37 RDR6 INFO: Starting to copy non-innodb files in subdirs of 'D:/workspace/data'
210910 12:40:37 RDR6 INFO: Completing the copy of all non-innodb files.
210910 12:40:45 WTR2 INFO: Adding database directory: datadir/#clone
210910 12:40:45 WTR2 INFO: Adding database directory: datadir/DATABASENAME
210910 12:40:45 WTR6 INFO: Adding database directory: datadir/mysql
210910 12:40:45 WTR6 INFO: Adding database directory: datadir/mysql_innodb_cluster_metadata
210910 12:40:45 WTR2 INFO: Adding database directory: datadir/performance_schema
210910 12:40:45 WTR2 INFO: Adding database directory: datadir/sys
210910 12:40:46 RDR6 INFO: Requesting consistency information...
210910 12:40:46 RDR6 INFO: Locked the consistency point for 1094 microseconds.
210910 12:40:46 RDR6 INFO: Consistency point server_uuid '4249a073-c8c1-11ea-92ab-005056843959'.
210910 12:40:46 RDR6 INFO: Consistency point gtid_executed '56be8ffc-c8b3-11ea-93d3-00505684f7cd:1-17752057:18362763,
d1552329-9fff-11e9-aa0b-00505694881c:1-77'.
210910 12:40:46 RDR6 INFO: Consistency point binary_log_file 'DATABASENAMEDBUAT3-bin.000072'.
210910 12:40:46 RDR6 INFO: Consistency point binary_log_position 692934398.
210910 12:40:46 RDR6 INFO: Consistency point replication channel 'group_replication_applier':
210910 12:40:46 RDR6 INFO: Consistency point relay_log_file 'DATABASENAMEDBUAT3-relay-log-bin-group_replication_applier.000020':
210910 12:40:46 RDR6 INFO: Consistency point relay_log_position 353.
210910 12:40:46 RDR6 INFO: Consistency point replication channel 'group_replication_recovery':
210910 12:40:46 RDR6 INFO: Consistency point relay_log_file 'DATABASENAMEDBUAT3-relay-log-bin-group_replication_recovery.000002':
210910 12:40:46 RDR6 INFO: Consistency point relay_log_position 152.
210910 12:40:46 RDR6 INFO: Consistency point InnoDB lsn 402744486896.
210910 12:40:46 RDR6 INFO: Consistency point InnoDB lsn_checkpoint 402744486194.
210910 12:40:46 RDR6 INFO: Requesting completion of redo log copy after LSN 402744486896.
210910 12:40:46 RLR1 INFO: Redo log reader waited 30145 times for a total of 150725.00 ms for logs to generate.
210910 12:40:46 RLW1 INFO: A copied database page was modified at 402744450628. (This is the highest lsn found on a page)
210910 12:40:46 RLW1 INFO: Scanned log up to lsn 402744486896.
210910 12:40:46 RLW1 INFO: Was able to parse the log up to lsn 402744486896.
210910 12:40:46 RDR1 INFO: Copying D:/workspace/data/DATABASENAMEDBUAT3-bin.000072.
210910 12:40:47 RDR6 Progress in MB: 42000 42200 42400
210910 12:40:50 RDR6 INFO: Completed the copy of binlog files...
210910 12:40:50 RDR6 INFO: The server instance is unlocked after 16.738 seconds.
210910 12:40:50 RDR6 INFO: Found encrypted tablespaces or encrypted binary logs, migrating the keys.
210910 12:40:50 RDR6 INFO: Active keyring "keyring_encrypted_file" detected.
210910 12:40:50 RDR6 INFO: KEF Keyring generated at 'D:/backuplogs/2021-09-10_12-32-45/meta/keyring_kef'.
210910 12:40:50 RDR6 INFO: Reading all global variables from the server.
210910 12:40:50 RDR6 INFO: Completed reading of all 625 global variables from the server.
210910 12:40:50 RDR6 INFO: Writing server defaults files 'server-my.cnf' and 'server-all.cnf' for server '8.0.20-commercial' in 'D:\backuplogs\2021-09-10_12-32-45'.
210910 12:40:53 RDR6 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/meta/backup_variables.txt.
210910 12:40:53 RDR2 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/datadir/ibbackup_logfile.
210910 12:40:53 RDR4 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/server-all.cnf.
210910 12:40:53 RDR3 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/server-my.cnf.
210910 12:40:53 RDR5 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/meta/backup_gtid_executed.sql.
210910 12:40:53 RDR1 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/meta/keyring_kef.
210910 12:40:53 RDR6 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/meta/backup_content.xml.
210910 12:40:53 RDR4 INFO: Copying meta file D:/backuplogs/2021-09-10_12-32-45/meta/image_files.xml.
210910 12:40:54 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:40:54 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:40:54 MAIN INFO: SSL: attempting to use an SSL connection.
210910 12:40:54 MAIN INFO: Group replication setup detected.
210910 12:40:54 MAIN INFO: Current node is a primary node
210910 12:40:55 MAIN INFO: Full Image Backup operation completed successfully.
210910 12:40:55 MAIN INFO: Backup image created successfully.
210910 12:40:55 MAIN INFO: Image Path = D:\backuplogs\FULL_20211009_123244.img
210910 12:40:55 MAIN INFO: MySQL binlog position: filename DATABASENAMEDBUAT3-bin.000072, position -1
210910 12:40:55 MAIN INFO: GTID_EXECUTED is 56be8ffc-c8b3-11ea-93d3-00505684f7cd:1-17752057:18362763,d1552329-9fff-11e9-aa0b-00505694881c:1-77
-------------------------------------------------------------
Parameters Summary
-------------------------------------------------------------
Start LSN : 402744199680
End LSN : 402744486896
-------------------------------------------------------------
mysqlbackup completed OK!
C:\Program Files\MySQL\mysql-backup-8.0.20\bin>
Note: If mysqlbackup completed OK means--Backup got success.
No comments:
Post a Comment