介绍MYSQLBACKUP备份的使用
一、源端插入数据进行备份
1、源端首次插入数据
ysql> use test;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| itpux |
| itpuxbak21 |
| itpuxbak22 |
| itpuxbak31 |
| itpuxbak32 |
| test11 |
+----------------+
mysql> create table full1 as select * from itpuxbak31;
Query OK, 4 rows affected (0.08 sec)
Records: 4 Duplicates: 0 Warnings: 0
查看binlog
[root@mysql1test 3306]# cd binlog
[root@mysql1test binlog]# ls
ntdt-binlog.000001 ntdt-binlog.000003 ntdt-binlog.000005 ntdt-binlog.000007 ntdt-binlog.000009 ntdt-binlog.000011 ntdt-binlog.000013
ntdt-binlog.000002 ntdt-binlog.000004 ntdt-binlog.000006 ntdt-binlog.000008 ntdt-binlog.000010 ntdt-binlog.000012 ntdt-binlog.index
[root@mysql1test binlog]# pwd
/mysqldata/log/3306/binlog
[root@mysql1test binlog]# pwd
执行全备脚本
[root@mysql1test scripts]# cat fullbackup.sh
#!/bin/bash
export BAKDATE=`date +%Y%m%d`
mysqlbackup --defaults-file=/mysql/data/3306/my.cnf --user=backup --password=backup --backup-dir=/mysql/backup/backup-db/ --with-timestamp backup-and-apply-log 2>/mysql/backup/backup-db/${BAKDATE}.log
[root@mysql1test scripts]#
产生结果：
[root@mysql1test scripts]# ./fullbackup.sh
[root@mysql1test scripts]# date
2024年 11月 13日 星期三 10:29:24 CST
结果：
[root@mysql1test backup-db]# ls
2024-11-13_10-29-07 20241113.log
[root@mysql1test backup-db]# pwd
/mysql/backup/backup-db
[root@mysql1test backup-db]#
2、源端第二次插入数据、进行第一次增量备份
root@mysql1test backup-db]# date -s '2024-11-14'
2024年 11月 14日 星期四 00:00:00 CST
[root@mysql1test backup-db]# date
2024年 11月 14日 星期四 00:00:02 CST
第二次插入数据
mysql> create table inc1 as select * from itpuxbak31;
Query OK, 4 rows affected (0.08 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)
mysql>
[root@mysql1test scripts]# cd /mysqldata/log/3306/binlog
[root@mysql1test binlog]# ls
ntdt-binlog.000001 ntdt-binlog.000004 ntdt-binlog.000007 ntdt-binlog.000010 ntdt-binlog.000013
ntdt-binlog.000002 ntdt-binlog.000005 ntdt-binlog.000008 ntdt-binlog.000011 ntdt-binlog.000014
ntdt-binlog.000003 ntdt-binlog.000006 ntdt-binlog.000009 ntdt-binlog.000012 ntdt-binlog.index
[root@mysql1test binlog]#
增量备份
[root@mysql1test scripts]# ./incremental.sh
[root@mysql1test scripts]# cat ./incremental.sh
#!/bin/bash
export BAKDATE=`date +%Y%m%d`
mysqlbackup --defaults-file=/mysql/data/3306/my.cnf --user=backup --password=backup backup --incremental --incremental-base=history:last_backup --incremental-backup-dir=/mysql/backup/backup-db/${BAKDATE} 2>/mysql/backup/backup-db/${BAKDATE}.log
[root@mysql1test scripts]#
查看备份
[root@mysql1test backup-db]# ls
2024-11-13_10-29-07 20241113.log 20241114 20241114.log
[root@mysql1test backup-db]#
3、源端第三次插入数据、并且第二次增量备份
第二次增量备份前插入数据
mysql> create table inc2 as select * from itpuxbak31;
Query OK, 4 rows affected (0.09 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)
mysql>
查看binlog
[root@mysql1test binlog]# ls
ntdt-binlog.000001 ntdt-binlog.000004 ntdt-binlog.000007 ntdt-binlog.000010 ntdt-binlog.000013 ntdt-binlog.index
ntdt-binlog.000002 ntdt-binlog.000005 ntdt-binlog.000008 ntdt-binlog.000011 ntdt-binlog.000014
ntdt-binlog.000003 ntdt-binlog.000006 ntdt-binlog.000009 ntdt-binlog.000012 ntdt-binlog.000015
[root@mysql1test binlog]#
前面还是14日、后面修改15日，再次插入数据
[root@mysql1test backup-db]# date -s '2024-11-15'
2024年 11月 15日 星期五 00:00:00 CST
[root@mysql1test backup-db]#
再次插入数据
mysql> create table inc22 as select * from itpuxbak31;
Query OK, 4 rows affected (0.13 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
第二次增量备份
[root@mysql1test scripts]# date
2024年 11月 15日 星期四 00:05:42 CST
[root@mysql1test scripts]# ./incremental.sh
[root@mysql1test scripts]#
[root@mysql1test scripts]# cat incremental.sh
#!/bin/bash
export BAKDATE=`date +%Y%m%d`
mysqlbackup --defaults-file=/mysql/data/3306/my.cnf --user=backup --password=backup backup --incremental --incremental-base=history:last_backup --incremental-backup-dir=/mysql/backup/backup-db/${BAKDATE} 2>/mysql/backup/backup-db/${BAKDATE}.log
[root@mysql1test scripts]#
[root@mysql1test backup-db]# ls
2024-11-13_10-29-07 20241113.log 20241114 20241114.log 20241115 20241115.log
[root@mysql1test backup-db]# ls
2024-11-13_10-29-07 20241113.log 20241114 20241114.log 20241115 20241115.log
[root@mysql1test backup-db]#
4、备份完成后插入数据
mysql> create table inc23 as select * from itpuxbak31;
Query OK, 4 rows affected (0.01 sec)
Records: 4 Duplicates: 0 Warnings: 0
mysql> flush logs;
Query OK, 0 rows affected (0.01 sec)
二、目标端进行恢复
1、创建目录
[root@tdsql01 ~]# mkdir -p /mysqldata/3306/data
[root@tdsql01 ~]# mkdir -p /mysqldata/log/3306/binlog
[root@tdsql01 3306]# mkdir -p /mysql/backup/backup-db
[root@tdsql01 3306]# chown -R mysql:mysql /mysql/backup/backup-db
[root@tdsql01 3306]#
授权
chown -R mysql:mysql /mysqldata
2、传输数据到异端
[root@mysql1test backup-db]# scp -r * 192.168.1.84:/mysql/backup/backup-db/
root@192.168.1.84's password:
目标端查看数据
[root@tdsql01 backup-db]# ls
2024-11-13_10-29-07 20241113.log 20241114 20241114.log 20241115 20241115.log
[root@tdsql01 backup-db]# ls -ll
总用量 56
drwxr-x---. 4 root root 97 11月 10 10:37 2024-11-13_10-29-07
-rw-r--r--. 1 root root 22138 11月 10 10:37 20241113.log
drwxr-x---. 4 root root 97 11月 10 10:37 20241114
-rw-r--r--. 1 root root 15127 11月 10 10:37 20241114.log
drwxr-x---. 4 root root 97 11月 10 10:37 20241115
-rw-r--r--. 1 root root 15281 11月 10 10:37 20241115.log
[root@tdsql01 backup-db]# chown -R mysql:mysql /mysql/backup/backup-db/
[root@tdsql01 backup-db]#
[root@tdsql01 backup-db]# du -sm *
665 2024-11-13_10-29-07
1 20241113.log
3 20241114
1 20241114.log
4 20241115
1 20241115.log
[root@tdsql01 backup-db]#
3、第一次增量文件的恢复
mysqlbackup --backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07 --incremental-backup-dir=/mysql/backup/backup-db/20241114/ apply-incremental-backup
日志如下：
[root@tdsql01 backup-db]# mysqlbackup --backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07 --incremental-backup-dir=/mysql/backup/backup-db/20241114/ apply-incremental-backup
MySQL Enterprise Backup Ver 8.4.2-commercial for Linux on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2024, Oracle and/or its affiliates.
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
--backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07
--incremental-backup-dir=/mysql/backup/backup-db/20241114/
apply-incremental-backup
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'apply-incremental-backup' run mysqlbackup
prints "mysqlbackup completed OK!".
241110 00:01:24 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/20241114/meta/backup_variables.txt'
241110 00:01:24 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:01:24 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:01:24 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:01:24 MAIN INFO: backup variable meb_version=8.4.2
241110 00:01:24 MAIN INFO: backup variable start_lsn=23425841
241110 00:01:24 MAIN INFO: backup variable last_checkpoint=23446304
241110 00:01:24 MAIN INFO: backup variable end_lsn=23448277
241110 00:01:24 MAIN INFO: backup variable apply_log_done=0
241110 00:01:24 MAIN INFO: backup variable is_incremental=1
241110 00:01:24 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:01:24 MAIN INFO: backup variable is_partial=0
241110 00:01:24 MAIN INFO: backup variable is_compressed=0
241110 00:01:24 MAIN INFO: backup variable is_skip_binlog=0
241110 00:01:24 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:01:24 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:01:24 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:01:24 MAIN INFO: backup variable binlog_position=ntdt-binlog.000014:158
241110 00:01:24 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:01:24 MAIN INFO: backup variable relaylog_channels=
241110 00:01:24 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:01:24 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:01:24 MAIN INFO: backup variable has_tde_tables=0
241110 00:01:24 MAIN INFO: backup variable start_time_utc=1731513702284002
241110 00:01:24 MAIN INFO: backup variable end_time_utc=1731513704397053
241110 00:01:24 MAIN INFO: backup variable consistency_time_utc=1731513704287363
241110 00:01:24 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:01:24 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:01:24 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:01:24 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:01:24 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:01:24 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:01:24 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:01:24 MAIN INFO: backup variable innodb_undo_files_count=2
241110 00:01:24 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/20241114/meta/backup_variables.txt'
241110 00:01:24 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:01:24 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:01:24 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:01:24 MAIN INFO: backup variable meb_version=8.4.2
241110 00:01:24 MAIN INFO: backup variable start_lsn=23425841
241110 00:01:24 MAIN INFO: backup variable last_checkpoint=23446304
241110 00:01:24 MAIN INFO: backup variable end_lsn=23448277
241110 00:01:24 MAIN INFO: backup variable apply_log_done=0
241110 00:01:24 MAIN INFO: backup variable is_incremental=1
241110 00:01:24 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:01:24 MAIN INFO: backup variable is_partial=0
241110 00:01:24 MAIN INFO: backup variable is_compressed=0
241110 00:01:24 MAIN INFO: backup variable is_skip_binlog=0
241110 00:01:24 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:01:24 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:01:24 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:01:24 MAIN INFO: backup variable binlog_position=ntdt-binlog.000014:158
241110 00:01:24 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:01:24 MAIN INFO: backup variable relaylog_channels=
241110 00:01:24 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:01:24 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:01:24 MAIN INFO: backup variable has_tde_tables=0
241110 00:01:24 MAIN INFO: backup variable start_time_utc=1731513702284002
241110 00:01:24 MAIN INFO: backup variable end_time_utc=1731513704397053
241110 00:01:24 MAIN INFO: backup variable consistency_time_utc=1731513704287363
241110 00:01:24 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:01:24 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:01:24 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:01:24 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:01:24 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:01:24 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:01:24 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:01:24 MAIN INFO: backup variable innodb_undo_files_count=2
241110 00:01:24 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/2024-11-13_10-29-07/meta/backup_variables.txt'
241110 00:01:24 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:01:24 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:01:24 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:01:24 MAIN INFO: backup variable meb_version=8.4.2
241110 00:01:24 MAIN INFO: backup variable start_lsn=23423488
241110 00:01:24 MAIN INFO: backup variable last_checkpoint=23423690
241110 00:01:24 MAIN INFO: backup variable end_lsn=23425840
241110 00:01:24 MAIN INFO: backup variable apply_log_done=1
241110 00:01:24 MAIN INFO: backup variable is_incremental=0
241110 00:01:24 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:01:24 MAIN INFO: backup variable is_partial=0
241110 00:01:24 MAIN INFO: backup variable is_compressed=0
241110 00:01:24 MAIN INFO: backup variable is_skip_binlog=0
241110 00:01:24 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:01:24 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:01:24 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:01:24 MAIN INFO: backup variable binlog_position=ntdt-binlog.000013:158
241110 00:01:24 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:01:24 MAIN INFO: backup variable relaylog_channels=
241110 00:01:24 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:01:24 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:01:24 MAIN INFO: backup variable has_tde_tables=0
241110 00:01:24 MAIN INFO: backup variable start_time_utc=1731464947655292
241110 00:01:24 MAIN INFO: backup variable end_time_utc=1731464951939801
241110 00:01:24 MAIN INFO: backup variable consistency_time_utc=1731464951904176
241110 00:01:24 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:01:24 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:01:24 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:01:24 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:01:24 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:01:24 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:01:24 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:01:24 MAIN INFO: backup variable innodb_undo_files_count=2
241110 00:01:24 MAIN INFO: MEB logfile created at /mysql/backup/backup-db/2024-11-13_10-29-07/meta/MEB_2024-11-10.00-01-24_apply-incremental-backup.log
241110 00:01:24 MAIN INFO: The backup directory has no keyring.
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_data_home_dir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_data_file_path = ibdata1:200M;ibdata2:200M;ibdata3:200M:autoextend:max:5G
innodb_log_group_home_dir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_undo_directory = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
241110 00:01:24 MAIN INFO: Creating 14 buffers each of size 17301504.
241110 00:01:24 MAIN INFO: Apply-Incremental-Pages operation starts with following threads
1 read-threads 1 write-threads
241110 00:01:24 MAIN INFO: Starting to copy all innodb files...
241110 00:01:24 MAIN INFO: Starting deletion of obsolete ibd files in backup-dir...
241110 00:01:24 MAIN INFO: Deleting dropped ibd files.
241110 00:01:24 MAIN INFO: Deletion of obsolete ibd files in backup-dir is completed.
241110 00:01:24 MAIN INFO: Deleting non-innodb files in backup-dir...
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/ibdata1` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1`.
241110 00:01:24 RDR1 INFO: Starting to copy all undo files...
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/undo_002` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002`.
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/undo_001` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001`.
241110 00:01:24 RDR1 INFO: Applying incremental pages to innodb data files...
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/mysql.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql.ibd`.
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/mysql/backup_history.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_history.ibd`.
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/mysql/backup_progress.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_progress.ibd`.
241110 00:01:24 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241114/datadir/test/inc1.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc1.ibd`.
241110 00:01:24 RDR1 INFO: Completing the copy of innodb files.
241110 00:01:24 RDR1 INFO: Deleting full backup relaylog '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/./mysql1test-relay-bin.000001'
241110 00:01:24 RDR1 INFO: Deleting full backup relaylog ''
241110 00:01:24 RDR1 INFO: Deleting full backup relaylog index '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql1test-relay-bin.index'
241110 00:01:24 RDR1 INFO: Relay Log Index: '/mysql/backup/backup-db/20241114/datadir/mysql1test-relay-bin.index'
241110 00:01:24 RDR1 INFO: Binary Log Basename: ''
241110 00:01:24 RDR1 INFO: Binary Log Index: '/mysql/backup/backup-db/20241114/datadir/ntdt-binlog.index'
241110 00:01:24 RDR1 INFO: Deleting last binlog file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000013'
241110 00:01:24 RDR1 INFO: Updating full backup index file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.index'
241110 00:01:24 RDR1 INFO: End of full backup index file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.index'
241110 00:01:24 RDR1 INFO: Starting to copy Binlog files.
241110 00:01:24 RDR1 INFO: Copying /mysql/backup/backup-db/20241114/datadir/ntdt-binlog.000013.
241110 00:01:24 RDR1 INFO: Copying /mysql/backup/backup-db/20241114/datadir/ntdt-binlog.000014.
241110 00:01:24 RDR1 INFO: Copying /mysql/backup/backup-db/20241114/datadir/mysql1test-relay-bin.000001.
241110 00:01:24 RDR1 INFO: Starting to copy all non-innodb files in
subdirectories of '/mysql/backup/backup-db/20241114/datadir'
241110 00:01:24 RDR1 INFO: Copying the database directory 'calming'
241110 00:01:24 RDR1 INFO: Copying the database directory 'cs'
241110 00:01:24 RDR1 INFO: Copying the database directory 'hcj'
241110 00:01:24 RDR1 INFO: Copying the database directory 'hhh'
241110 00:01:24 RDR1 INFO: Copying the database directory 'itpuxdb1'
241110 00:01:24 RDR1 INFO: Copying the database directory 'itpuxdb2'
241110 00:01:24 RDR1 INFO: Copying the database directory 'itpuxdb3'
241110 00:01:24 RDR1 INFO: Copying the database directory 'mysql'
241110 00:01:24 RDR1 INFO: Copying the database directory 'ntmcpp'
241110 00:01:24 RDR1 INFO: Copying the database directory 'oracle'
241110 00:01:24 RDR1 INFO: Copying the database directory 'performance_schema'
241110 00:01:24 RDR1 INFO: Copying the database directory 'sys'
241110 00:01:24 RDR1 INFO: Copying the database directory 'test'
241110 00:01:24 RDR1 INFO: Copying the database directory 'test01'
241110 00:01:24 RDR1 INFO: Completing the copy of all non-innodb files.
241110 00:01:24 RDR1 INFO: Completed the copy of binlog files...
241110 00:01:24 RDR1 INFO: Copying server configuration files to backup_dir.
241110 00:01:24 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241114/datadir/backup-auto.cnf'
241110 00:01:24 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241114/datadir/backup-mysqld-auto.cnf'
241110 00:01:24 MAIN INFO: Apply-Incremental-Pages operation completed successfully.
241110 00:01:24 MAIN INFO: Creating 14 buffers each of size 65536.
241110 00:01:24 MAIN INFO: Apply-log operation starts with following threads
1 read-threads 1 process-threads 6 apply-threads
241110 00:01:24 MAIN INFO: Using up to 100 MB of memory.
241110 00:01:24 MAIN INFO: ibbackup_logfile's creation parameters:
start lsn 23445504, end lsn 23448277,
start checkpoint 23445848.
241110 00:01:24 MAIN INFO: Loading the space id : 0, space name : /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1.
241110 00:01:24 MAIN INFO: Loading the space id 4294967279 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001'.
241110 00:01:24 MAIN INFO: Loading the space id 4294967278 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002'.
241110 00:01:24 MAIN INFO: Loading the space id 22 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/calming/test01.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 23 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/cs/cs.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 14 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/hcj/test.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 2 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb1/itpuxbak11.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 3 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb1/itpuxbak12.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 6 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb2/itpuxbak21.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 7 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb2/itpuxbak22.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 8 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb3/itpuxbak22.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 9 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb3/t.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 5 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_history.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 4 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_progress.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 27 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/fullbackup.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 33 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/fulltest1.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 15 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hcj.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 25 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hh.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 26 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hh2.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 28 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental1.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 29 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental11.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 30 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental2.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 31 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental21.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 34 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/inctest1.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 16 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/itpuxbak11.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 17 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/test1.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 24 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/oracle/hh.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 1 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/sys/sys_config.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 35 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/full1.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 36 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc1.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 19 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpux.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 10 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak21.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 11 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak22.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 13 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak31.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 12 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak32.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 21 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/test11.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 4294967294 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql.ibd'.
241110 00:01:24 MAIN INFO: Loading the space id 4294967279 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001'.
241110 00:01:24 MAIN INFO: Loading the space id 4294967278 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002'.
241110 00:01:24 PCR1 INFO: Starting to parse redo log at lsn = 23445517, whereas checkpoint_lsn = 23445848 and start_lsn = 23445504.
241110 00:01:24 PCR1 INFO: Doing recovery: scanned up to log sequence number 23448277.
241110 00:01:24 PCR1 INFO: Starting to apply a batch of log records to the database....
InnoDB: Progress in percent: 11 22 33 44 55
241110 00:01:24 PCR1 INFO: Create redo log files. target start_lsn 23423488 last_checkpoint 23423690 end_lsn 23425840
241110 00:01:24 PCR1 INFO: Create redo log files. source start_lsn 23425841 last_checkpoint 23446304 end_lsn 23448277
241110 00:01:24 PCR1 INFO: Updating last checkpoint to 23446304 in redo log
241110 00:01:24 PCR1 INFO: We were able to parse ibbackup_logfile up to lsn 23448277.
241110 00:01:24 PCR1 INFO: Last MySQL binlog file position 0 158, file name ntdt-binlog.000014
241110 00:01:24 PCR1 INFO: The first data file is '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1'
and the new created log files are at '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir'
241110 00:01:24 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241114/datadir/backup-auto.cnf'
241110 00:01:24 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241114/datadir/backup-mysqld-auto.cnf'
241110 00:01:24 MAIN INFO: Apply-log operation completed successfully.
241110 00:01:24 MAIN INFO: Full backup prepared for recovery successfully.
mysqlbackup completed OK!
[root@tdsql01 backup-db]#
4、第二次增量备份文件的恢复
mysqlbackup --backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07 --incremental-backup-dir=/mysql/backup/backup-db/20241115 apply-incremental-backup
[root@tdsql01 backup-db]# mysqlbackup --backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07 --incremental-backup-dir=/mysql/backup/backup-db/20241115 apply-incremental-backup
MySQL Enterprise Backup Ver 8.4.2-commercial for Linux on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2024, Oracle and/or its affiliates.
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
--backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07
--incremental-backup-dir=/mysql/backup/backup-db/20241115
apply-incremental-backup
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'apply-incremental-backup' run mysqlbackup
prints "mysqlbackup completed OK!".
241110 00:02:52 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/20241115/meta/backup_variables.txt'
241110 00:02:52 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:02:52 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:02:52 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:02:52 MAIN INFO: backup variable meb_version=8.4.2
241110 00:02:52 MAIN INFO: backup variable start_lsn=23448278
241110 00:02:52 MAIN INFO: backup variable last_checkpoint=23494229
241110 00:02:52 MAIN INFO: backup variable end_lsn=23496589
241110 00:02:52 MAIN INFO: backup variable apply_log_done=0
241110 00:02:52 MAIN INFO: backup variable is_incremental=1
241110 00:02:52 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:02:52 MAIN INFO: backup variable is_partial=0
241110 00:02:52 MAIN INFO: backup variable is_compressed=0
241110 00:02:52 MAIN INFO: backup variable is_skip_binlog=0
241110 00:02:52 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:02:52 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:02:52 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:02:52 MAIN INFO: backup variable binlog_position=ntdt-binlog.000015:736
241110 00:02:52 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:02:52 MAIN INFO: backup variable relaylog_channels=
241110 00:02:52 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:02:52 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:02:52 MAIN INFO: backup variable has_tde_tables=0
241110 00:02:52 MAIN INFO: backup variable start_time_utc=1731600090257365
241110 00:02:52 MAIN INFO: backup variable end_time_utc=1731600092011319
241110 00:02:52 MAIN INFO: backup variable consistency_time_utc=1731600091968085
241110 00:02:52 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:02:52 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:02:52 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:02:52 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:02:52 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:02:52 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:02:52 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:02:52 MAIN INFO: backup variable innodb_undo_files_count=2
241110 00:02:52 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/20241115/meta/backup_variables.txt'
241110 00:02:52 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:02:52 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:02:52 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:02:52 MAIN INFO: backup variable meb_version=8.4.2
241110 00:02:52 MAIN INFO: backup variable start_lsn=23448278
241110 00:02:52 MAIN INFO: backup variable last_checkpoint=23494229
241110 00:02:52 MAIN INFO: backup variable end_lsn=23496589
241110 00:02:52 MAIN INFO: backup variable apply_log_done=0
241110 00:02:52 MAIN INFO: backup variable is_incremental=1
241110 00:02:52 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:02:52 MAIN INFO: backup variable is_partial=0
241110 00:02:52 MAIN INFO: backup variable is_compressed=0
241110 00:02:52 MAIN INFO: backup variable is_skip_binlog=0
241110 00:02:52 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:02:52 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:02:52 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:02:52 MAIN INFO: backup variable binlog_position=ntdt-binlog.000015:736
241110 00:02:52 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:02:52 MAIN INFO: backup variable relaylog_channels=
241110 00:02:52 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:02:52 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:02:52 MAIN INFO: backup variable has_tde_tables=0
241110 00:02:52 MAIN INFO: backup variable start_time_utc=1731600090257365
241110 00:02:52 MAIN INFO: backup variable end_time_utc=1731600092011319
241110 00:02:52 MAIN INFO: backup variable consistency_time_utc=1731600091968085
241110 00:02:52 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:02:52 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:02:52 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:02:52 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:02:52 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:02:52 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:02:52 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:02:52 MAIN INFO: backup variable innodb_undo_files_count=2
241110 00:02:52 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/2024-11-13_10-29-07/meta/backup_variables.txt'
241110 00:02:52 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:02:52 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:02:52 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:02:52 MAIN INFO: backup variable meb_version=8.4.2
241110 00:02:52 MAIN INFO: backup variable start_lsn=23423488
241110 00:02:52 MAIN INFO: backup variable last_checkpoint=23446304
241110 00:02:52 MAIN INFO: backup variable end_lsn=23448277
241110 00:02:52 MAIN INFO: backup variable apply_log_done=1
241110 00:02:52 MAIN INFO: backup variable apply_incremental_done=1
241110 00:02:52 MAIN INFO: backup variable is_incremental=0
241110 00:02:52 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:02:52 MAIN INFO: backup variable is_partial=0
241110 00:02:52 MAIN INFO: backup variable is_compressed=0
241110 00:02:52 MAIN INFO: backup variable is_skip_binlog=0
241110 00:02:52 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:02:52 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:02:52 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:02:52 MAIN INFO: backup variable binlog_position=ntdt-binlog.000014:158
241110 00:02:52 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:02:52 MAIN INFO: backup variable relaylog_channels=
241110 00:02:52 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:02:52 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:02:52 MAIN INFO: backup variable has_tde_tables=0
241110 00:02:52 MAIN INFO: backup variable start_time_utc=1731464947655292
241110 00:02:52 MAIN INFO: backup variable end_time_utc=1731464951939801
241110 00:02:52 MAIN INFO: backup variable consistency_time_utc=1731464951904176
241110 00:02:52 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:02:52 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:02:52 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:02:52 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:02:52 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:02:52 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:02:52 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:02:52 MAIN INFO: backup variable innodb_undo_files_count=0
241110 00:02:52 MAIN INFO: MEB logfile created at /mysql/backup/backup-db/2024-11-13_10-29-07/meta/MEB_2024-11-10.00-02-52_apply-incremental-backup.log
241110 00:02:52 MAIN INFO: The backup directory has no keyring.
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_data_home_dir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_data_file_path = ibdata1:200M;ibdata2:200M;ibdata3:200M:autoextend:max:5G
innodb_log_group_home_dir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_undo_directory = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
241110 00:02:52 MAIN INFO: Creating 14 buffers each of size 17301504.
241110 00:02:52 MAIN INFO: Apply-Incremental-Pages operation starts with following threads
1 read-threads 1 write-threads
241110 00:02:52 MAIN INFO: Starting to copy all innodb files...
241110 00:02:52 MAIN INFO: Starting deletion of obsolete ibd files in backup-dir...
241110 00:02:52 MAIN INFO: Deleting dropped ibd files.
241110 00:02:52 MAIN INFO: Deletion of obsolete ibd files in backup-dir is completed.
241110 00:02:52 MAIN INFO: Deleting non-innodb files in backup-dir...
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/ibdata1` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1`.
241110 00:02:52 RDR1 INFO: Starting to copy all undo files...
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/undo_002` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002`.
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/undo_001` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001`.
241110 00:02:52 RDR1 INFO: Applying incremental pages to innodb data files...
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/mysql.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql.ibd`.
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/mysql/backup_history.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_history.ibd`.
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/mysql/backup_progress.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_progress.ibd`.
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/test/inc2.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc2.ibd`.
241110 00:02:52 RDR1 INFO: Applying diff pages from `/mysql/backup/backup-db/20241115/datadir/test/inc22.ibd` to `/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc22.ibd`.
241110 00:02:52 RDR1 INFO: Completing the copy of innodb files.
241110 00:02:52 RDR1 INFO: Deleting full backup relaylog '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/./mysql1test-relay-bin.000001'
241110 00:02:52 RDR1 INFO: Deleting full backup relaylog ''
241110 00:02:52 RDR1 INFO: Deleting full backup relaylog index '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql1test-relay-bin.index'
241110 00:02:52 RDR1 INFO: Relay Log Index: '/mysql/backup/backup-db/20241115/datadir/mysql1test-relay-bin.index'
241110 00:02:52 RDR1 INFO: Binary Log Basename: ''
241110 00:02:52 RDR1 INFO: Binary Log Index: '/mysql/backup/backup-db/20241115/datadir/ntdt-binlog.index'
241110 00:02:52 RDR1 INFO: Deleting last binlog file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000014'
241110 00:02:52 RDR1 INFO: Updating full backup index file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.index'
241110 00:02:52 RDR1 INFO: End of full backup index file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.index'
241110 00:02:52 RDR1 INFO: Starting to copy Binlog files.
241110 00:02:52 RDR1 INFO: Copying /mysql/backup/backup-db/20241115/datadir/ntdt-binlog.000014.
241110 00:02:52 RDR1 INFO: Copying /mysql/backup/backup-db/20241115/datadir/ntdt-binlog.000015.
241110 00:02:52 RDR1 INFO: Copying /mysql/backup/backup-db/20241115/datadir/mysql1test-relay-bin.000001.
241110 00:02:52 RDR1 INFO: Starting to copy all non-innodb files in
subdirectories of '/mysql/backup/backup-db/20241115/datadir'
241110 00:02:52 RDR1 INFO: Copying the database directory 'calming'
241110 00:02:52 RDR1 INFO: Copying the database directory 'cs'
241110 00:02:52 RDR1 INFO: Copying the database directory 'hcj'
241110 00:02:52 RDR1 INFO: Copying the database directory 'hhh'
241110 00:02:52 RDR1 INFO: Copying the database directory 'itpuxdb1'
241110 00:02:52 RDR1 INFO: Copying the database directory 'itpuxdb2'
241110 00:02:52 RDR1 INFO: Copying the database directory 'itpuxdb3'
241110 00:02:52 RDR1 INFO: Copying the database directory 'mysql'
241110 00:02:52 RDR1 INFO: Copying the database directory 'ntmcpp'
241110 00:02:52 RDR1 INFO: Copying the database directory 'oracle'
241110 00:02:52 RDR1 INFO: Copying the database directory 'performance_schema'
241110 00:02:52 RDR1 INFO: Copying the database directory 'sys'
241110 00:02:52 RDR1 INFO: Copying the database directory 'test'
241110 00:02:52 RDR1 INFO: Copying the database directory 'test01'
241110 00:02:52 RDR1 INFO: Completing the copy of all non-innodb files.
241110 00:02:52 RDR1 INFO: Completed the copy of binlog files...
241110 00:02:52 RDR1 INFO: Copying server configuration files to backup_dir.
241110 00:02:52 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241115/datadir/backup-auto.cnf'
241110 00:02:52 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241115/datadir/backup-mysqld-auto.cnf'
241110 00:02:52 MAIN INFO: Apply-Incremental-Pages operation completed successfully.
241110 00:02:52 MAIN INFO: Creating 14 buffers each of size 65536.
241110 00:02:52 MAIN INFO: Apply-log operation starts with following threads
1 read-threads 1 process-threads 6 apply-threads
241110 00:02:52 MAIN INFO: Using up to 100 MB of memory.
241110 00:02:52 MAIN INFO: ibbackup_logfile's creation parameters:
start lsn 23494144, end lsn 23496589,
start checkpoint 23494229.
241110 00:02:52 MAIN INFO: Loading the space id : 0, space name : /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1.
241110 00:02:52 MAIN INFO: Loading the space id 4294967279 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001'.
241110 00:02:52 MAIN INFO: Loading the space id 4294967278 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002'.
241110 00:02:52 MAIN INFO: Loading the space id 22 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/calming/test01.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 23 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/cs/cs.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 14 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/hcj/test.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 2 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb1/itpuxbak11.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 3 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb1/itpuxbak12.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 6 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb2/itpuxbak21.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 7 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb2/itpuxbak22.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 8 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb3/itpuxbak22.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 9 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb3/t.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 5 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_history.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 4 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_progress.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 27 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/fullbackup.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 33 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/fulltest1.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 15 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hcj.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 25 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hh.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 26 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hh2.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 28 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental1.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 29 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental11.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 30 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental2.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 31 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental21.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 34 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/inctest1.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 16 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/itpuxbak11.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 17 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/test1.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 24 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/oracle/hh.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 1 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/sys/sys_config.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 35 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/full1.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 36 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc1.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 37 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc2.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 38 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc22.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 19 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpux.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 10 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak21.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 11 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak22.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 13 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak31.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 12 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak32.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 21 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/test11.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 4294967294 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql.ibd'.
241110 00:02:52 MAIN INFO: Loading the space id 4294967279 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001'.
241110 00:02:52 MAIN INFO: Loading the space id 4294967278 name '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002'.
241110 00:02:52 PCR1 INFO: Starting to parse redo log at lsn = 23494191, whereas checkpoint_lsn = 23494229 and start_lsn = 23494144.
241110 00:02:52 PCR1 INFO: Doing recovery: scanned up to log sequence number 23496589.
241110 00:02:52 PCR1 INFO: Starting to apply a batch of log records to the database....
InnoDB: Progress in percent: 12 25 37 50
241110 00:02:52 PCR1 INFO: Create redo log files. target start_lsn 23423488 last_checkpoint 23446304 end_lsn 23448277
241110 00:02:52 PCR1 INFO: Create redo log files. source start_lsn 23448278 last_checkpoint 23494229 end_lsn 23496589
241110 00:02:52 PCR1 INFO: Updating last checkpoint to 23494229 in redo log
241110 00:02:52 PCR1 INFO: We were able to parse ibbackup_logfile up to lsn 23496589.
241110 00:02:52 PCR1 INFO: Last MySQL binlog file position 0 736, file name ntdt-binlog.000015
241110 00:02:52 PCR1 INFO: The first data file is '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1'
and the new created log files are at '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir'
241110 00:02:52 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241115/datadir/backup-auto.cnf'
241110 00:02:52 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/20241115/datadir/backup-mysqld-auto.cnf'
241110 00:02:52 MAIN INFO: Apply-log operation completed successfully.
241110 00:02:52 MAIN INFO: Full backup prepared for recovery successfully.
mysqlbackup completed OK!
[root@tdsql01 backup-db]#
5、最后将备份文件copy到数据目录
mysqlbackup --defaults-file=/mysql/data/3306/my.cnf copy-back-and-apply-log --backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07
[root@tdsql01 backup-db]# mysqlbackup --defaults-file=/mysql/data/3306/my.cnf copy-back-and-apply-log --backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07
MySQL Enterprise Backup Ver 8.4.2-commercial for Linux on x86_64 (MySQL Enterprise - Commercial)
Copyright (c) 2003, 2024, Oracle and/or its affiliates.
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
--defaults-file=/mysql/data/3306/my.cnf
copy-back-and-apply-log
--backup-dir=/mysql/backup/backup-db/2024-11-13_10-29-07
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!".
241110 00:04:12 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/2024-11-13_10-29-07/meta/backup_variables.txt'
241110 00:04:12 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:04:12 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:04:12 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:04:12 MAIN INFO: backup variable meb_version=8.4.2
241110 00:04:12 MAIN INFO: backup variable start_lsn=23423488
241110 00:04:12 MAIN INFO: backup variable last_checkpoint=23494229
241110 00:04:12 MAIN INFO: backup variable end_lsn=23496589
241110 00:04:12 MAIN INFO: backup variable apply_log_done=1
241110 00:04:12 MAIN INFO: backup variable apply_incremental_done=1
241110 00:04:12 MAIN INFO: backup variable is_incremental=0
241110 00:04:12 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:04:12 MAIN INFO: backup variable is_partial=0
241110 00:04:12 MAIN INFO: backup variable is_compressed=0
241110 00:04:12 MAIN INFO: backup variable is_skip_binlog=0
241110 00:04:12 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:04:12 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:04:12 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:04:12 MAIN INFO: backup variable binlog_position=ntdt-binlog.000015:736
241110 00:04:12 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:04:12 MAIN INFO: backup variable relaylog_channels=
241110 00:04:12 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:04:12 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:04:12 MAIN INFO: backup variable has_tde_tables=0
241110 00:04:12 MAIN INFO: backup variable start_time_utc=1731464947655292
241110 00:04:12 MAIN INFO: backup variable end_time_utc=1731464951939801
241110 00:04:12 MAIN INFO: backup variable consistency_time_utc=1731464951904176
241110 00:04:12 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:04:12 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:04:12 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:04:12 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:04:12 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:04:12 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:04:12 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:04:12 MAIN INFO: backup variable innodb_undo_files_count=0
241110 00:04:12 MAIN INFO: read_backup_variables_txt_file: '/mysql/backup/backup-db/2024-11-13_10-29-07/meta/backup_variables.txt'
241110 00:04:12 MAIN INFO: backup variable mysql_version=8.4.2-commercial
241110 00:04:12 MAIN INFO: MySQL server version is '8.4.2-commercial'
241110 00:04:12 MAIN INFO: Restoring ...8.4.2-commercial version
241110 00:04:12 MAIN INFO: backup variable meb_version=8.4.2
241110 00:04:12 MAIN INFO: backup variable start_lsn=23423488
241110 00:04:12 MAIN INFO: backup variable last_checkpoint=23494229
241110 00:04:12 MAIN INFO: backup variable end_lsn=23496589
241110 00:04:12 MAIN INFO: backup variable apply_log_done=1
241110 00:04:12 MAIN INFO: backup variable apply_incremental_done=1
241110 00:04:12 MAIN INFO: backup variable is_incremental=0
241110 00:04:12 MAIN INFO: backup variable is_incremental_with_redo_log_only=0
241110 00:04:12 MAIN INFO: backup variable is_partial=0
241110 00:04:12 MAIN INFO: backup variable is_compressed=0
241110 00:04:12 MAIN INFO: backup variable is_skip_binlog=0
241110 00:04:12 MAIN INFO: backup variable is_skip_relaylog=0
241110 00:04:12 MAIN INFO: backup variable is_skip_unused_pages=0
241110 00:04:12 MAIN INFO: backup variable is_onlyinnodb=0
241110 00:04:12 MAIN INFO: backup variable binlog_position=ntdt-binlog.000015:736
241110 00:04:12 MAIN INFO: backup variable binlog_index=ntdt-binlog.index
241110 00:04:12 MAIN INFO: backup variable relaylog_channels=
241110 00:04:12 MAIN INFO: backup variable relaylog_index=mysql1test-relay-bin.index
241110 00:04:12 MAIN INFO: backup variable gtid_executed=92b541d3-890a-11ef-9964-00505691e4bd:1
241110 00:04:12 MAIN INFO: backup variable has_tde_tables=0
241110 00:04:12 MAIN INFO: backup variable start_time_utc=1731464947655292
241110 00:04:12 MAIN INFO: backup variable end_time_utc=1731464951939801
241110 00:04:12 MAIN INFO: backup variable consistency_time_utc=1731464951904176
241110 00:04:12 MAIN INFO: backup variable mysql_version_comment=MySQL Enterprise Server - Commercial
241110 00:04:12 MAIN INFO: backup variable log_bin_name=ntdt-binlog
241110 00:04:12 MAIN INFO: backup variable log_bin_path=/mysqldata/log/3306/binlog
241110 00:04:12 MAIN INFO: backup variable relay_log_name=mysql1test-relay-bin
241110 00:04:12 MAIN INFO: backup variable relay_index_name_prefix=mysql1test-relay-bin
241110 00:04:12 MAIN INFO: backup variable log_bin_index_name=ntdt-binlog
241110 00:04:12 MAIN INFO: backup variable log_bin_index_path=/mysqldata/log/3306/binlog
241110 00:04:12 MAIN INFO: backup variable innodb_undo_files_count=0
241110 00:04:12 MAIN INFO: MEB logfile created at /mysql/backup/backup-db/2024-11-13_10-29-07/meta/MEB_2024-11-10.00-04-12_copy-back-and-apply-log.log
241110 00:04:12 MAIN INFO: The backup directory has no keyring.
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /mysqldata/3306/data
innodb_data_home_dir = /mysqldata/3306/data
innodb_data_file_path = ibdata1:200M;ibdata2:200M;ibdata3:200M:autoextend:max:5G
innodb_log_group_home_dir = /mysqldata/3306/data
innodb_undo_directory = /mysqldata/3306/data
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = Null
innodb_checksum_algorithm = crc32
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_data_home_dir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_data_file_path = ibdata1:200M;ibdata2:200M;ibdata3:200M:autoextend:max:5G
innodb_log_group_home_dir = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_undo_directory = /mysql/backup/backup-db/2024-11-13_10-29-07/datadir
innodb_undo_tablespaces = 2
innodb_buffer_pool_filename = ib_buffer_pool
innodb_page_size = 16384
innodb_checksum_algorithm = crc32
241110 00:04:12 MAIN INFO: Creating 14 buffers each of size 16777216.
241110 00:04:12 MAIN INFO: Copy-back-and-apply-log from dir operation starts with following threads
1 read-threads 1 write-threads
241110 00:04:12 MAIN INFO: Starting to copy all innodb files...
241110 00:04:12 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata1.
241110 00:04:14 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata2.
RDR1 Progress in MB: 200
241110 00:04:14 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ibdata3.
RDR1 Progress in MB: 400
241110 00:04:15 RDR1 INFO: Starting to copy all undo files...
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_002.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/undo_001.
RDR1 Progress in MB: 600
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/calming/test01.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/cs/cs.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/hcj/test.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb1/itpuxbak11.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb1/itpuxbak12.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb2/itpuxbak21.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb2/itpuxbak22.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb3/itpuxbak22.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/itpuxdb3/t.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_history.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql/backup_progress.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/fullbackup.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/fulltest1.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hcj.ibd.
241110 00:04:15 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hh.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/hh2.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental1.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental11.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental2.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/incremental21.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/inctest1.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/itpuxbak11.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntmcpp/test1.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/oracle/hh.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/sys/sys_config.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/full1.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc1.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc2.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/inc22.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpux.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak21.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak22.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak31.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/itpuxbak32.ibd.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/test/test11.ibd.
241110 00:04:16 RDR1 INFO: Completing the copy of innodb files.
241110 00:04:16 RDR1 INFO: Relay Log Index: '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql1test-relay-bin.index'
241110 00:04:16 RDR1 INFO: log location /mysqldata/log/3306/binlog/ntdt-binlog
241110 00:04:16 RDR1 INFO: Binary Log Basename: '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog'
241110 00:04:16 RDR1 INFO: Binary Log Index: '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.index'
241110 00:04:16 RDR1 INFO: Relay Channel: ''
241110 00:04:16 RDR1 INFO: Relay Log Basename: '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql1test-relay-bin'
241110 00:04:16 RDR1 INFO: Starting to copy Binlog files.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000001.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000002.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000003.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000004.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000005.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000006.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000007.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000008.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000009.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000010.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000011.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000012.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000013.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000014.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/ntdt-binlog.000015.
241110 00:04:16 RDR1 INFO: Copying /mysql/backup/backup-db/2024-11-13_10-29-07/datadir/mysql1test-relay-bin.000001.
241110 00:04:16 RDR1 INFO: Copying the database directory 'calming'
241110 00:04:16 RDR1 INFO: Copying the database directory 'cs'
241110 00:04:16 RDR1 INFO: Copying the database directory 'hcj'
241110 00:04:16 RDR1 INFO: Copying the database directory 'hhh'
241110 00:04:16 RDR1 INFO: Copying the database directory 'itpuxdb1'
241110 00:04:16 RDR1 INFO: Copying the database directory 'itpuxdb2'
241110 00:04:16 RDR1 INFO: Copying the database directory 'itpuxdb3'
241110 00:04:16 RDR1 INFO: Copying the database directory 'mysql'
241110 00:04:16 RDR1 INFO: Copying the database directory 'ntmcpp'
241110 00:04:16 RDR1 INFO: Copying the database directory 'oracle'
241110 00:04:16 RDR1 INFO: Copying the database directory 'performance_schema'
241110 00:04:16 RDR1 INFO: Copying the database directory 'sys'
241110 00:04:16 RDR1 INFO: Copying the database directory 'test'
241110 00:04:16 RDR1 INFO: Copying the database directory 'test01'
241110 00:04:16 RDR1 INFO: Completing the copy of all non-innodb files.
241110 00:04:16 RDR1 INFO: Completed the copy of binlog files...
241110 00:04:16 RDR1 INFO: Copying the log file '#ib_redo0' type 3
241110 00:04:16 MAIN INFO: Apply-log operation has already been done on that backup.
241110 00:04:16 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/backup-auto.cnf'
241110 00:04:16 MAIN INFO: Copying the server config file '/mysql/backup/backup-db/2024-11-13_10-29-07/datadir/backup-mysqld-auto.cnf'
241110 00:04:16 MAIN INFO: Copy-back operation completed successfully.
mysqlbackup completed OK!
[root@tdsql01 backup-db]#
6、修改数据目录和binlog权限
目标端修改权限【主要是数据目录和binlog目录】
chown -R mysql:mysql /mysqldata
7、启动数据库
[root@tdsql01 binlog]# systemctl start mysqld
[root@tdsql01 binlog]# ps -ef|grep mysql
mysql 14387 1 0 00:09 ? 00:00:00 /bin/sh /mysql/app/mysql/bin/mysqld_safe --defaults-file=/mysql/data/3306/my.cnf --datadir=/mysqldata/3306/data --pid-file=/mysql/data/3306/mysql.pid
mysql 15542 14387 8 00:10 ? 00:00:03 /mysql/app/mysql/bin/mysqld --defaults-file=/mysql/data/3306/my.cnf --basedir=/mysql/app/mysql --datadir=/mysqldata/3306/data --plugin-dir=/mysql/app/mysql/lib/plugin --log-error=/mysql/log/3306/ntdt-error.err --open-files-limit=65536 --pid-file=/mysql/data/3306/mysql.pid --socket=/tmp/mysql.sock --port=3306
root 15651 3604 0 00:10 pts/1 00:00:00 grep --color=auto mysql
[root@tdsql01 3306]# ls
binlog gywl-error.err gywl-query.err ntdt-error.err ntdt-query.err relaylog
[root@tdsql01 3306]# tail -10f ntdt-error.err
2024-11-09T16:15:10.772681Z mysqld_safe Starting mysqld daemon with databases from /mysqldata/3306/data
2024-11-10T00:15:10.810078+08:00 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-11-10T00:15:11.166850+08:00 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-11-10T00:15:11.167638+08:00 0 [System] [MY-010116] [Server] /mysql/app/mysql/bin/mysqld (mysqld 8.4.2-commercial) starting as process 17165
2024-11-10T00:15:11.187421+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-11-10T00:15:16.479702+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-11-10T00:15:17.379039+08:00 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-11-10T00:15:17.379238+08:00 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-11-10T00:15:17.487277+08:00 0 [System] [MY-010931] [Server] /mysql/app/mysql/bin/mysqld: ready for connections. Version: '8.4.2-commercial' socket: '/tmp/mysql.sock' port: 3306 MySQL Enterprise Server - Commercial.
2024-11-10T00:15:17.489074+08:00 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
8、查看表数据
查看恢复的表数据
mysql> show tables;
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id: 8
Current database: test
+----------------+
| Tables_in_test |
+----------------+
| full1 |
| inc1 |
| inc2 |
| inc22 |
| itpux |
| itpuxbak21 |
| itpuxbak22 |
| itpuxbak31 |
| itpuxbak32 |
| test11 |
+----------------+
10 rows in set (0.07 sec)
mysql>
可以看到inc23没有、因为是在创建inc22后 进行增量备份，故此没有inc23、如果需要恢复inc23 需要恢复binlog文件
