【三】xtrabackup 全备和时间点增量恢复详细过程

已于 2022-08-26 18:33:40 修改
阅读量632 收藏 1
点赞数
分类专栏： 数据库 文章标签： linux 运维
于 2021-09-09 22:05:23 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/cpxsxn/article/details/120211091
版权

全量恢复：

[root@dbs-recover-dest mybackup]#
[root@dbs-recover-dest mybackup]#
[root@dbs-recover-dest mybackup]# systemctl stop mysqld     ------step0------
[root@dbs-recover-dest mybackup]#
[root@dbs-recover-dest mybackup]#
[root@dbs-recover-dest mybackup]# pwd
/root/mybackup
[root@dbs-recover-dest mybackup]# 
[root@dbs-recover-dest mybackup]# ls
full_20210909210500.tar.gz
[root@dbs-recover-dest mybackup]# mkdir mysql3306                 ------step1------
[root@dbs-recover-dest mybackup]# cd 
[root@dbs-recover-dest ~]# pigz -p 4 -c -d /root/mybackup/full_20210909210500.tar.gz | tar -xi -C /root/mybackup/mysql3306  ------step2------
[root@dbs-recover-dest ~]# 
[root@dbs-recover-dest ~]# 
[root@dbs-recover-dest ~]# cd mybackup/
[root@dbs-recover-dest mybackup]# ls
full_20210909210500.tar.gz  mysql3306
[root@dbs-recover-dest mybackup]# 
[root@dbs-recover-dest mybackup]# 
[root@dbs-recover-dest mybackup]# cd mysql3306/
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# ls
backup-my.cnf   ibdata1             sys                     xtrabackup_logfile
dbs             mysql               xtrabackup_checkpoints  xtrabackup_slave_info
ib_buffer_pool  performance_schema  xtrabackup_info
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# cd
[root@dbs-recover-dest ~]# /opt/dbs/bin/xtrabackup --defaults-file=/root/mybackup/mysql3306/backup-my.cnf --prepare --use-memory=5G --target-dir=/root/mybackup/mysql3306  ------step3------
xtrabackup: recognized server arguments: --innodb_checksum_algorithm=crc32 --innodb_log_checksum_algorithm=strict_crc32 --innodb_data_file_path=ibdata1:12M:autoextend --innodb_log_files_in_group=2 --innodb_log_file_size=50331648 --innodb_fast_checksum=0 --innodb_page_size=16384 --innodb_log_block_size=512 --innodb_undo_directory=./ --innodb_undo_tablespaces=0 --server-id=0 --redo-log-version=1  
xtrabackup: recognized client arguments: --prepare=1 --use-memory=5G --target-dir=/root/mybackup/mysql3306 
/opt/dbs/bin/xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64) (revision id: 5988af5)
xtrabackup: cd to /root/mybackup/mysql3306/
xtrabackup: This target seems to be not prepared yet.
InnoDB: Number of pools: 1
xtrabackup: xtrabackup_logfile detected: size=8388608, start_lsn=(2852145)
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = .
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = .
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 8388608
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = .
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = .
xtrabackup:   innodb_log_files_in_group = 1
xtrabackup:   innodb_log_file_size = 8388608
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 5368709120 bytes for buffer pool (set by --use-memory parameter)
InnoDB: PUNCH HOLE support available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Number of pools: 1
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size = 5G, instances = 1, chunk size = 128M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority: -20
InnoDB: Highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 2852145
InnoDB: Doing recovery: scanned up to log sequence number 2852154 (0%)
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Creating shared tablespace for temporary tables
InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
InnoDB: File './ibtmp1' size is now 12 MB.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: 5.7.32 started; log sequence number 2852154

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 2852173
InnoDB: Number of pools: 1
xtrabackup: using the following InnoDB configuration for recovery:
xtrabackup:   innodb_data_home_dir = .
xtrabackup:   innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup:   innodb_log_group_home_dir = .
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
InnoDB: PUNCH HOLE support available
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Uses event mutexes
InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
InnoDB: Compressed tables use zlib 1.2.3
InnoDB: Number of pools: 1
InnoDB: Using CPU crc32 instructions
InnoDB: Initializing buffer pool, total size = 5G, instances = 1, chunk size = 128M
InnoDB: Completed initialization of buffer pool
InnoDB: page_cleaner coordinator priority: -20
InnoDB: Setting log file ./ib_logfile101 size to 48 MB
InnoDB: Setting log file ./ib_logfile1 size to 48 MB
InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
InnoDB: New log files created, LSN=2852173
InnoDB: Highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 2852364
InnoDB: Doing recovery: scanned up to log sequence number 2852373 (0%)
InnoDB: Database was not shutdown normally!
InnoDB: Starting crash recovery.
InnoDB: Removed temporary tablespace data file: "ibtmp1"
InnoDB: Creating shared tablespace for temporary tables
InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
InnoDB: File './ibtmp1' size is now 12 MB.
InnoDB: 96 redo rollback segment(s) found. 1 redo rollback segment(s) are active.
InnoDB: 32 non-redo rollback segment(s) are active.
InnoDB: 5.7.32 started; log sequence number 2852373
xtrabackup: starting shutdown with innodb_fast_shutdown = 1
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
InnoDB: Shutdown completed; log sequence number 2852392
210909 21:16:08 completed OK!
[root@dbs-recover-dest ~]# ls
aaa  anaconda-ks.cfg  mybackup  pkg
[root@dbs-recover-dest ~]# 
[root@dbs-recover-dest ~]# cd mybackup/
[root@dbs-recover-dest mybackup]# ls
full_20210909210500.tar.gz  mysql3306
[root@dbs-recover-dest mybackup]# cd mysql3306/
[root@dbs-recover-dest mysql3306]# ls
backup-my.cnf   ibdata1      ibtmp1              sys                     xtrabackup_logfile
dbs             ib_logfile0  mysql               xtrabackup_checkpoints  xtrabackup_master_key_id
ib_buffer_pool  ib_logfile1  performance_schema  xtrabackup_info         xtrabackup_slave_info
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# cd
[root@dbs-recover-dest ~]# /opt/dbs/bin/xtrabackup  --defaults-file=/etc/my.cnf --move-back --use-memory=5G --target-dir=/root/mybackup/mysql3306     ------step4------
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql 
xtrabackup: recognized client arguments: --move-back=1 --use-memory=5G --target-dir=/root/mybackup/mysql3306 
/opt/dbs/bin/xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64) (revision id: 5988af5)
Original data directory /var/lib/mysql is not empty!
[root@dbs-recover-dest ~]# /opt/dbs/bin/xtrabackup  --defaults-file=/etc/my.cnf --move-back --use-memory=5G --target-dir=/root/mybackup/mysql3306
xtrabackup: recognized server arguments: --datadir=/var/lib/mysql 
xtrabackup: recognized client arguments: --move-back=1 --use-memory=5G --target-dir=/root/mybackup/mysql3306 
/opt/dbs/bin/xtrabackup version 2.4.21 based on MySQL server 5.7.32 Linux (x86_64) (revision id: 5988af5)
210909 21:19:32 [01] Moving ib_logfile0 to /var/lib/mysql/ib_logfile0
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ib_logfile1 to /var/lib/mysql/ib_logfile1
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ibdata1 to /var/lib/mysql/ibdata1
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/plugin.ibd to /var/lib/mysql/mysql/plugin.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/servers.ibd to /var/lib/mysql/mysql/servers.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_topic.ibd to /var/lib/mysql/mysql/help_topic.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_category.ibd to /var/lib/mysql/mysql/help_category.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_relation.ibd to /var/lib/mysql/mysql/help_relation.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_keyword.ibd to /var/lib/mysql/mysql/help_keyword.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_name.ibd to /var/lib/mysql/mysql/time_zone_name.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone.ibd to /var/lib/mysql/mysql/time_zone.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_transition.ibd to /var/lib/mysql/mysql/time_zone_transition.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_transition_type.ibd to /var/lib/mysql/mysql/time_zone_transition_type.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_leap_second.ibd to /var/lib/mysql/mysql/time_zone_leap_second.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slave_relay_log_info.ibd to /var/lib/mysql/mysql/slave_relay_log_info.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slave_master_info.ibd to /var/lib/mysql/mysql/slave_master_info.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slave_worker_info.ibd to /var/lib/mysql/mysql/slave_worker_info.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/gtid_executed.ibd to /var/lib/mysql/mysql/gtid_executed.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/server_cost.ibd to /var/lib/mysql/mysql/server_cost.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/engine_cost.ibd to /var/lib/mysql/mysql/engine_cost.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/db.opt to /var/lib/mysql/mysql/db.opt
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/ndb_binlog_index.frm to /var/lib/mysql/mysql/ndb_binlog_index.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/ndb_binlog_index.MYI to /var/lib/mysql/mysql/ndb_binlog_index.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/ndb_binlog_index.MYD to /var/lib/mysql/mysql/ndb_binlog_index.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slave_relay_log_info.frm to /var/lib/mysql/mysql/slave_relay_log_info.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slave_master_info.frm to /var/lib/mysql/mysql/slave_master_info.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/slave_worker_info.frm to /var/lib/mysql/mysql/slave_worker_info.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/gtid_executed.frm to /var/lib/mysql/mysql/gtid_executed.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/server_cost.frm to /var/lib/mysql/mysql/server_cost.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/engine_cost.frm to /var/lib/mysql/mysql/engine_cost.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/sys_config.ibd to /var/lib/mysql/sys/sys_config.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/db.opt to /var/lib/mysql/sys/db.opt
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/version.frm to /var/lib/mysql/sys/version.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/sys_config.frm to /var/lib/mysql/sys/sys_config.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/statements_with_full_table_scans.frm to /var/lib/mysql/sys/statements_with_full_table_scans.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/sys_config_insert_set_user.TRN to /var/lib/mysql/sys/sys_config_insert_set_user.TRN
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/processlist.frm to /var/lib/mysql/sys/processlist.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/sys_config.TRG to /var/lib/mysql/sys/sys_config.TRG
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/statements_with_sorting.frm to /var/lib/mysql/sys/statements_with_sorting.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/sys_config_update_set_user.TRN to /var/lib/mysql/sys/sys_config_update_set_user.TRN
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024statements_with_sorting.frm to /var/lib/mysql/sys/x@0024statements_with_sorting.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/innodb_buffer_stats_by_schema.frm to /var/lib/mysql/sys/innodb_buffer_stats_by_schema.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_index_statistics.frm to /var/lib/mysql/sys/schema_index_statistics.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024innodb_buffer_stats_by_schema.frm to /var/lib/mysql/sys/x@0024innodb_buffer_stats_by_schema.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/statements_with_temp_tables.frm to /var/lib/mysql/sys/statements_with_temp_tables.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/innodb_buffer_stats_by_table.frm to /var/lib/mysql/sys/innodb_buffer_stats_by_table.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024ps_schema_table_statistics_io.frm to /var/lib/mysql/sys/x@0024ps_schema_table_statistics_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024innodb_buffer_stats_by_table.frm to /var/lib/mysql/sys/x@0024innodb_buffer_stats_by_table.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/host_summary.frm to /var/lib/mysql/sys/host_summary.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/innodb_lock_waits.frm to /var/lib/mysql/sys/innodb_lock_waits.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024host_summary.frm to /var/lib/mysql/sys/x@0024host_summary.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024innodb_lock_waits.frm to /var/lib/mysql/sys/x@0024innodb_lock_waits.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/waits_by_user_by_latency.frm to /var/lib/mysql/sys/waits_by_user_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_object_overview.frm to /var/lib/mysql/sys/schema_object_overview.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/user_summary_by_file_io_type.frm to /var/lib/mysql/sys/user_summary_by_file_io_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_auto_increment_columns.frm to /var/lib/mysql/sys/schema_auto_increment_columns.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/user_summary_by_file_io.frm to /var/lib/mysql/sys/user_summary_by_file_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024schema_flattened_keys.frm to /var/lib/mysql/sys/x@0024schema_flattened_keys.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024user_summary_by_file_io.frm to /var/lib/mysql/sys/x@0024user_summary_by_file_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_redundant_indexes.frm to /var/lib/mysql/sys/schema_redundant_indexes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/user_summary_by_statement_type.frm to /var/lib/mysql/sys/user_summary_by_statement_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/ps_check_lost_instrumentation.frm to /var/lib/mysql/sys/ps_check_lost_instrumentation.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/latest_file_io.frm to /var/lib/mysql/sys/latest_file_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/waits_by_host_by_latency.frm to /var/lib/mysql/sys/waits_by_host_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024latest_file_io.frm to /var/lib/mysql/sys/x@0024latest_file_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/waits_global_by_latency.frm to /var/lib/mysql/sys/waits_global_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/io_by_thread_by_latency.frm to /var/lib/mysql/sys/io_by_thread_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/user_summary_by_stages.frm to /var/lib/mysql/sys/user_summary_by_stages.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024io_by_thread_by_latency.frm to /var/lib/mysql/sys/x@0024io_by_thread_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024user_summary_by_stages.frm to /var/lib/mysql/sys/x@0024user_summary_by_stages.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/io_global_by_file_by_bytes.frm to /var/lib/mysql/sys/io_global_by_file_by_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024schema_index_statistics.frm to /var/lib/mysql/sys/x@0024schema_index_statistics.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024io_global_by_file_by_bytes.frm to /var/lib/mysql/sys/x@0024io_global_by_file_by_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/user_summary.frm to /var/lib/mysql/sys/user_summary.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/io_global_by_file_by_latency.frm to /var/lib/mysql/sys/io_global_by_file_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_table_statistics.frm to /var/lib/mysql/sys/schema_table_statistics.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024io_global_by_file_by_latency.frm to /var/lib/mysql/sys/x@0024io_global_by_file_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024user_summary.frm to /var/lib/mysql/sys/x@0024user_summary.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/io_global_by_wait_by_bytes.frm to /var/lib/mysql/sys/io_global_by_wait_by_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024schema_table_statistics.frm to /var/lib/mysql/sys/x@0024schema_table_statistics.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024io_global_by_wait_by_bytes.frm to /var/lib/mysql/sys/x@0024io_global_by_wait_by_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/host_summary_by_file_io_type.frm to /var/lib/mysql/sys/host_summary_by_file_io_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/io_global_by_wait_by_latency.frm to /var/lib/mysql/sys/io_global_by_wait_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_table_statistics_with_buffer.frm to /var/lib/mysql/sys/schema_table_statistics_with_buffer.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024io_global_by_wait_by_latency.frm to /var/lib/mysql/sys/x@0024io_global_by_wait_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/host_summary_by_file_io.frm to /var/lib/mysql/sys/host_summary_by_file_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/memory_by_user_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_user_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_table_lock_waits.frm to /var/lib/mysql/sys/schema_table_lock_waits.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024memory_by_user_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_user_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024host_summary_by_file_io.frm to /var/lib/mysql/sys/x@0024host_summary_by_file_io.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/memory_by_host_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_host_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024schema_table_lock_waits.frm to /var/lib/mysql/sys/x@0024schema_table_lock_waits.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024memory_by_host_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_host_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/statement_analysis.frm to /var/lib/mysql/sys/statement_analysis.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/memory_by_thread_by_current_bytes.frm to /var/lib/mysql/sys/memory_by_thread_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024statement_analysis.frm to /var/lib/mysql/sys/x@0024statement_analysis.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024memory_by_thread_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_by_thread_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/host_summary_by_statement_type.frm to /var/lib/mysql/sys/host_summary_by_statement_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/memory_global_by_current_bytes.frm to /var/lib/mysql/sys/memory_global_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/statements_with_errors_or_warnings.frm to /var/lib/mysql/sys/statements_with_errors_or_warnings.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024memory_global_by_current_bytes.frm to /var/lib/mysql/sys/x@0024memory_global_by_current_bytes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/metrics.frm to /var/lib/mysql/sys/metrics.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/memory_global_total.frm to /var/lib/mysql/sys/memory_global_total.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/host_summary_by_stages.frm to /var/lib/mysql/sys/host_summary_by_stages.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024memory_global_total.frm to /var/lib/mysql/sys/x@0024memory_global_total.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/session.frm to /var/lib/mysql/sys/session.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024schema_table_statistics_with_buffer.frm to /var/lib/mysql/sys/x@0024schema_table_statistics_with_buffer.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024statements_with_errors_or_warnings.frm to /var/lib/mysql/sys/x@0024statements_with_errors_or_warnings.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_tables_with_full_table_scans.frm to /var/lib/mysql/sys/schema_tables_with_full_table_scans.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/schema_unused_indexes.frm to /var/lib/mysql/sys/schema_unused_indexes.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024schema_tables_with_full_table_scans.frm to /var/lib/mysql/sys/x@0024schema_tables_with_full_table_scans.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024host_summary_by_stages.frm to /var/lib/mysql/sys/x@0024host_summary_by_stages.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024statements_with_full_table_scans.frm to /var/lib/mysql/sys/x@0024statements_with_full_table_scans.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024ps_digest_avg_latency_distribution.frm to /var/lib/mysql/sys/x@0024ps_digest_avg_latency_distribution.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm to /var/lib/mysql/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/statements_with_runtimes_in_95th_percentile.frm to /var/lib/mysql/sys/statements_with_runtimes_in_95th_percentile.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm to /var/lib/mysql/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024statements_with_temp_tables.frm to /var/lib/mysql/sys/x@0024statements_with_temp_tables.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024user_summary_by_file_io_type.frm to /var/lib/mysql/sys/x@0024user_summary_by_file_io_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024user_summary_by_statement_type.frm to /var/lib/mysql/sys/x@0024user_summary_by_statement_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/user_summary_by_statement_latency.frm to /var/lib/mysql/sys/user_summary_by_statement_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024user_summary_by_statement_latency.frm to /var/lib/mysql/sys/x@0024user_summary_by_statement_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024host_summary_by_file_io_type.frm to /var/lib/mysql/sys/x@0024host_summary_by_file_io_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024host_summary_by_statement_type.frm to /var/lib/mysql/sys/x@0024host_summary_by_statement_type.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/host_summary_by_statement_latency.frm to /var/lib/mysql/sys/host_summary_by_statement_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024host_summary_by_statement_latency.frm to /var/lib/mysql/sys/x@0024host_summary_by_statement_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/wait_classes_global_by_avg_latency.frm to /var/lib/mysql/sys/wait_classes_global_by_avg_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024wait_classes_global_by_avg_latency.frm to /var/lib/mysql/sys/x@0024wait_classes_global_by_avg_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/wait_classes_global_by_latency.frm to /var/lib/mysql/sys/wait_classes_global_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024wait_classes_global_by_latency.frm to /var/lib/mysql/sys/x@0024wait_classes_global_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024waits_by_user_by_latency.frm to /var/lib/mysql/sys/x@0024waits_by_user_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024waits_by_host_by_latency.frm to /var/lib/mysql/sys/x@0024waits_by_host_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024waits_global_by_latency.frm to /var/lib/mysql/sys/x@0024waits_global_by_latency.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024processlist.frm to /var/lib/mysql/sys/x@0024processlist.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/x@0024session.frm to /var/lib/mysql/sys/x@0024session.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./sys/session_ssl_status.frm to /var/lib/mysql/sys/session_ssl_status.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/agent.ibd to /var/lib/mysql/dbs/agent.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/task.ibd to /var/lib/mysql/dbs/task.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/bk_file_attr_binlog.ibd to /var/lib/mysql/dbs/bk_file_attr_binlog.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/ds_attr_mysql.ibd to /var/lib/mysql/dbs/ds_attr_mysql.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/data_source.ibd to /var/lib/mysql/dbs/data_source.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/mysqldump_attr.ibd to /var/lib/mysql/dbs/mysqldump_attr.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/backup_plan.ibd to /var/lib/mysql/dbs/backup_plan.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/backup_file.ibd to /var/lib/mysql/dbs/backup_file.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/xtrabackup_attr.ibd to /var/lib/mysql/dbs/xtrabackup_attr.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/precheck_plan.ibd to /var/lib/mysql/dbs/precheck_plan.ibd
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/db.opt to /var/lib/mysql/dbs/db.opt
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/agent.frm to /var/lib/mysql/dbs/agent.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/task.frm to /var/lib/mysql/dbs/task.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/bk_file_attr_binlog.frm to /var/lib/mysql/dbs/bk_file_attr_binlog.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/ds_attr_mysql.frm to /var/lib/mysql/dbs/ds_attr_mysql.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/data_source.frm to /var/lib/mysql/dbs/data_source.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/mysqldump_attr.frm to /var/lib/mysql/dbs/mysqldump_attr.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/backup_plan.frm to /var/lib/mysql/dbs/backup_plan.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/backup_file.frm to /var/lib/mysql/dbs/backup_file.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/xtrabackup_attr.frm to /var/lib/mysql/dbs/xtrabackup_attr.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./dbs/precheck_plan.frm to /var/lib/mysql/dbs/precheck_plan.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/cond_instances.frm to /var/lib/mysql/performance_schema/cond_instances.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_current.frm to /var/lib/mysql/performance_schema/events_waits_current.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_history.frm to /var/lib/mysql/performance_schema/events_waits_history.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_history_long.frm to /var/lib/mysql/performance_schema/events_waits_history_long.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_summary_by_instance.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_instance.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_host_by_event_name.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_user_by_event_name.frm
210909 21:19:32 [01]        ...done
210909 21:19:32 [01] Moving ./performance_schema/events_waits_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_account_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_by_thread_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_waits_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_waits_summary_global_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/file_instances.frm to /var/lib/mysql/performance_schema/file_instances.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/file_summary_by_event_name.frm to /var/lib/mysql/performance_schema/file_summary_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/file_summary_by_instance.frm to /var/lib/mysql/performance_schema/file_summary_by_instance.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/socket_instances.frm to /var/lib/mysql/performance_schema/socket_instances.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/socket_summary_by_instance.frm to /var/lib/mysql/performance_schema/socket_summary_by_instance.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/socket_summary_by_event_name.frm to /var/lib/mysql/performance_schema/socket_summary_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/host_cache.frm to /var/lib/mysql/performance_schema/host_cache.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/mutex_instances.frm to /var/lib/mysql/performance_schema/mutex_instances.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/objects_summary_global_by_type.frm to /var/lib/mysql/performance_schema/objects_summary_global_by_type.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/performance_timers.frm to /var/lib/mysql/performance_schema/performance_timers.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/rwlock_instances.frm to /var/lib/mysql/performance_schema/rwlock_instances.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/setup_actors.frm to /var/lib/mysql/performance_schema/setup_actors.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/setup_consumers.frm to /var/lib/mysql/performance_schema/setup_consumers.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/setup_instruments.frm to /var/lib/mysql/performance_schema/setup_instruments.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/setup_objects.frm to /var/lib/mysql/performance_schema/setup_objects.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/setup_timers.frm to /var/lib/mysql/performance_schema/setup_timers.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/table_io_waits_summary_by_index_usage.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_index_usage.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/table_io_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_io_waits_summary_by_table.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/table_lock_waits_summary_by_table.frm to /var/lib/mysql/performance_schema/table_lock_waits_summary_by_table.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/threads.frm to /var/lib/mysql/performance_schema/threads.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_current.frm to /var/lib/mysql/performance_schema/events_stages_current.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_history.frm to /var/lib/mysql/performance_schema/events_stages_history.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_history_long.frm to /var/lib/mysql/performance_schema/events_stages_history_long.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_thread_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_host_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_user_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_by_account_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_stages_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_stages_summary_global_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_current.frm to /var/lib/mysql/performance_schema/events_statements_current.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_history.frm to /var/lib/mysql/performance_schema/events_statements_history.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_history_long.frm to /var/lib/mysql/performance_schema/events_statements_history_long.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_thread_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_host_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_user_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_account_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_statements_summary_global_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_current.frm to /var/lib/mysql/performance_schema/events_transactions_current.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_history.frm to /var/lib/mysql/performance_schema/events_transactions_history.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_history_long.frm to /var/lib/mysql/performance_schema/events_transactions_history_long.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_thread_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_host_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_user_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_by_account_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_transactions_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/events_transactions_summary_global_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/hosts.frm to /var/lib/mysql/performance_schema/hosts.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/users.frm to /var/lib/mysql/performance_schema/users.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/accounts.frm to /var/lib/mysql/performance_schema/accounts.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/memory_summary_global_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_global_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/memory_summary_by_thread_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_thread_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/memory_summary_by_account_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_account_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/memory_summary_by_host_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_host_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/memory_summary_by_user_by_event_name.frm to /var/lib/mysql/performance_schema/memory_summary_by_user_by_event_name.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_by_digest.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_digest.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/events_statements_summary_by_program.frm to /var/lib/mysql/performance_schema/events_statements_summary_by_program.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/prepared_statements_instances.frm to /var/lib/mysql/performance_schema/prepared_statements_instances.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_connection_configuration.frm to /var/lib/mysql/performance_schema/replication_connection_configuration.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_group_member_stats.frm to /var/lib/mysql/performance_schema/replication_group_member_stats.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_group_members.frm to /var/lib/mysql/performance_schema/replication_group_members.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_connection_status.frm to /var/lib/mysql/performance_schema/replication_connection_status.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_applier_configuration.frm to /var/lib/mysql/performance_schema/replication_applier_configuration.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_applier_status.frm to /var/lib/mysql/performance_schema/replication_applier_status.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_applier_status_by_coordinator.frm to /var/lib/mysql/performance_schema/replication_applier_status_by_coordinator.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/replication_applier_status_by_worker.frm to /var/lib/mysql/performance_schema/replication_applier_status_by_worker.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/session_connect_attrs.frm to /var/lib/mysql/performance_schema/session_connect_attrs.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/session_account_connect_attrs.frm to /var/lib/mysql/performance_schema/session_account_connect_attrs.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/table_handles.frm to /var/lib/mysql/performance_schema/table_handles.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/metadata_locks.frm to /var/lib/mysql/performance_schema/metadata_locks.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/user_variables_by_thread.frm to /var/lib/mysql/performance_schema/user_variables_by_thread.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/variables_by_thread.frm to /var/lib/mysql/performance_schema/variables_by_thread.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/global_variables.frm to /var/lib/mysql/performance_schema/global_variables.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/session_variables.frm to /var/lib/mysql/performance_schema/session_variables.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/status_by_thread.frm to /var/lib/mysql/performance_schema/status_by_thread.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/status_by_user.frm to /var/lib/mysql/performance_schema/status_by_user.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/status_by_host.frm to /var/lib/mysql/performance_schema/status_by_host.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/status_by_account.frm to /var/lib/mysql/performance_schema/status_by_account.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/global_status.frm to /var/lib/mysql/performance_schema/global_status.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./performance_schema/session_status.frm to /var/lib/mysql/performance_schema/session_status.frm
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./xtrabackup_slave_info to /var/lib/mysql/xtrabackup_slave_info
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./xtrabackup_master_key_id to /var/lib/mysql/xtrabackup_master_key_id
210909 21:19:33 [01]        ...done
210909 21:19:33 [01] Moving ./ibtmp1 to /var/lib/mysql/ibtmp1
210909 21:19:33 [01]        ...done
210909 21:19:33 completed OK!
[root@dbs-recover-dest ~]# ls
aaa  anaconda-ks.cfg  mybackup  pkg
[root@dbs-recover-dest ~]# cd mybackup/
[root@dbs-recover-dest mybackup]# ls
full_20210909210500.tar.gz  mysql3306
[root@dbs-recover-dest mybackup]# cd mysql3306/
[root@dbs-recover-dest mysql3306]#
[root@dbs-recover-dest mysql3306]# ll -ht
total 8.1M
drwxr-xr-x 2 root root    6 Sep  9 21:19 performance_schema
drwxr-xr-x 2 root root    6 Sep  9 21:19 dbs
drwxr-xr-x 2 root root    6 Sep  9 21:19 sys
drwxr-xr-x 2 root root    6 Sep  9 21:19 mysql
-rw-rw---- 1 root root  135 Sep  9 21:16 xtrabackup_checkpoints
-rw-rw---- 1 root root 8.0M Sep  9 21:16 xtrabackup_logfile
-rw-rw---- 1 root root  487 Sep  9 21:05 backup-my.cnf
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# ll /var/lib/ -ht
.....
drwxr-x--- 6 root    root     240 Sep  9 21:19 mysql
drwxr-xr-x 6 root    root      80 Sep  9 20:37 yum
drwxr-x--x 5 mysql   mysql    314 Sep  9 20:13 mysql20210909
.....
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql3306]# chown -R mysql:mysql /var/lib/mysql     ------step5------
[root@dbs-recover-dest mysql3306]# 
[root@dbs-recover-dest mysql]# 
[root@dbs-recover-dest mysql]# 
[root@dbs-recover-dest mysql]# systemctl start mysqld                      ------step6------
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
[root@dbs-recover-dest mysql]# 
[root@dbs-recover-dest mysql]# 
[root@dbs-recover-dest mysql]#

时间点恢复：开启 gtid

  1. 先用最近的全量备份

  2. 设置 gtid_purged: SET GLOBAL gtid_purged=‘153f7dd4-107e-11ec-8a59-fa163e771f31:1-226’; 该值来自文件 xtrabackup_info，否则回放 binlog 的时候，可能会报主键冲突

  3. 再执行 mysqlbinlog 回放 binlog

    a. 只需要回放一个 binlog：
mysqlbinlog --start-position=xxx  --stop-datetime=xxx  path/to/last_binlog | mysql -h127.0.0.1 -uroot -p3306 -P123456

b. 需要回放多个 binlog
mysqlbinlog --start-position=xxx  path/to/first_binlog | mysql -h127.0.0.1 -uroot -p3306 -P123456

mysqlbinlog  path/to/binlogN | mysql -h127.0.0.1 -uroot -p3306 -P123456
 
mysqlbinlog --stop-datetime=xxx  path/to/last_binlog | mysql -h127.0.0.1 -uroot -p3306 -P123456
robch
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Mysql数据库—日志、备份与恢复
Yusheng9527的博客
02-14 1308
Mysql数据库—日志、备份与恢复Mysql常用日志概述错误日志通用查询日志二进制日志(binlog)慢查询日志查询日志状态查看通用日志开启状态查看二进制日志开启状态查看慢查询日志功能是否开启查看慢查询时间设置在数据库中设置开启慢查询的办法（临时）备份与恢复概述备份类型从物理与逻辑的角度分类（逻辑备份、物理备份）从数据库的备份策略角度分类（完全备份、差异备份、增量备份）备份方法物理冷备份专用备份工具mysqldump或mysqlhotcopy通过启用二进制日志进行增量备份通过第三方工具备份完全备份/恢复操作
xtrabackup全量增量备份+全量增量恢复+binlog增量恢复
qinhuaifeng的博客
03-26 324
xtrabackup全量增量备份+全量增量恢复+binlog增量恢复案例，记录自己的学习过程
mysql实战——xtrabackup全量备份/增量备份及恢复
最新发布
zyjzyjjyzjyz的博客
05-23 1549
恢复的机器必须有my.cnf配置文件，再配置文件中配置好datadir目录即数据问目录，数据目录也必须为空，若不为空则会报错。可以看到第一次增量备份后新增的表空间被恢复了。可以看到inc4是第一次增量备份生成的文件。增量备份需要获取全量备份的to_lsn。如上图to_lsn=18374406。可以看到test2表空间。
xtrabackup全量备份+binlog基于时间点恢复
weixin_30416871的博客
06-13 286
1.通过xtrabackup的备份恢复数据库。 2.找到start-position和binlog名称 cat xtrabackup_info 3.导出mysqlbinlog为sql文件，并确定恢复的时间点 mysqlbinlog --no-defaults --start-position=51178055 --stop-datetime='2017-05-22 15:30'...
Xtrabackup增量备份、恢复以及时间点恢复
weixin_34223655的博客
11-16 480
1、记录当前的status信息| master.000001 | 120 | 2、制作一个完整的备份文件# innobackupex /backup备份的文件：/backup/2016-11-16_16-18-54查看其status信息# cat xtrabackup_binlog_infomaster.000001 120#3、修改数据库信息以使...
mysql通过percona xtrabackup全备和mysql binlog实现基于时间点的数据库恢复
congse3359的博客
02-26 204
前一段时间,开发人员不小心在delete的时候忘了加条件,把一张表的全部数据给删了. 以下是模拟的恢复操作记录: --os rhel 5.6 x64 --mysql version 5.6.14 --------...
使用xtrbackup/mysqldump全量备份+binlog备份恢复到最近一个时间点
wukong_666的博客
05-12 560
先用xtrabackup做全备： innobackupex --defaults-file=/usr/local/mysql/my.cnf --user=root --password=123 /home/backup/xtrabackup/ 全备完成之后新建sanguoyanyi表，并插入数据： mysql> create table sanguoyanyi (     -> id in
MySQL基于xtrabackup全量备份进行单表恢复
lichunliang的博客
03-15 1182
MySQL基于xtrabackup全量备份进行单表恢复 一、背景 ​ Percona-xtrabackup是Percona开发的用于MySQL数据库物理热备的备份工具，在生产环境中经常用于做MySQL InnoDB类型表的备份。数据库使用者经常可能更新数据时忘记添加WHERE条件或者进行了误删除操作。此时若进行整库恢复会造成时间成本很高，并且DBA一般不会直接操作业务数据，这时会新建一个临时的独立节点只针对误操作的表进行单表恢复。 二、所需要的文件 由于备份时进行了压缩，所以这里显示的数据文件
MySQL——GTID复制如何用xtrabackup恢复数据库
授人以鱼不如授之以渔
08-12 740
背景 我们的数据库使用的是GTID复制，今天老任为了避免单点利用备份文件恢复搭建从库的时候遇到了一些问题，所以就写了这篇笔记，加深学习理解。 大家都知道，在搭建从库的时候，基本都是利用最近的一份xtrabackup备份文件，解压 apply对应的log之后会生成下图的一些相关文件。 #可以看到解压应用后的关于备份位点信息的文件如下图所示 $ ls -l xtrabackup* -rw-r--r--. 1 mysql mysql 400 8月 11 21:25 xtrabackup_bin
基于xtrabackup的MySQL数据库备份及还原Shell脚本.zip
08-27
`xtrabackup`是Percona公司开发的一款高效、无锁的MySQL和MariaDB热备份工具，它允许在不影响数据库服务的情况下进行全备和增量备份。本教程将详细介绍如何使用`xtrabackup`结合Shell脚本来实现MySQL数据库的备份与...
percona-xtrabackup-8.0.23-16.tar.gz
07-09
在恢复阶段，Percona XtraBackup提供了灵活的选项，可以将备份快速恢复到任意时间点，甚至可以恢复到新的硬件或云环境，这对于灾难恢复或者迁移场景非常有用。同时，它还支持并行恢复，大大缩短了恢复时间。 使用...
percona-xtrabackup-2.3.zip 源码
01-04
4. **增量备份**：在全量备份的基础上，Xtrabackup支持基于时间点的增量备份，只备份自上次备份以来发生改变的数据，进一步提高效率。 5. **在线恢复**：备份数据可以直接在原地进行恢复，无需额外的空间，简化了...
percona-xtrabackup-2.3.4-Linux-x86-64.tar.gz
11-19
5. **恢复操作**：提供简单的命令行工具，可以方便地将备份数据恢复到任意时间点，确保业务连续性。 6. **验证与修复**：在恢复前，可以通过工具进行备份文件的验证，确保数据的完整性和一致性，如果发现问题，可以...
percona-xtrabackup-2.4.8-Linux-x86_64.tar.gz
03-02
总结起来，Percona Xtrabackup是MySQL数据库管理员不可或缺的工具，其高效、灵活的备份和恢复功能使得数据库管理更加便捷和安全。通过了解和熟练掌握其使用方法，可以提升数据库的稳定性和业务连续性。
如何采用percona的xtrabackup 进行数据备份和恢复？！
db_murphy的博客
10-10 646
摘要： 如何使用percona提供的xtrabackup 工具来做数据备份和恢复。 Xtrabackup是一个对InnoDB做数据备份的工具，支持在线热备份(备份时不影响数据读写)，是商业备份工具InnoDB Hotbackup的一个很好的替代品。Xtrabackup有两个主要的工具：xtrabackup、innobackupex。innobackupex是参考了InnoDBHotbackup的innoback脚本修改而来的.innobackupex是一个perl脚本封装，封装了xtrabackup。主
MySQL之Xtrabackup备份与恢复
Richardlygo的博客
08-30 1198
一、Xtrabackup介绍 　　MySQL冷备、mysqldump、MySQL热拷贝都无法实现对数据库进行增量备份。在实际生产环境中增量备份是非常实用的，如果数据大于50G或100G，存储空间足够的情况下，可以每天进行完整备份，如果每天产生的数据量较大，需要定制数据备份策略。例如每周实用完整备份，周一到周六实用增量备份。而Percona-Xtrabackup就是为了实现增量备份而出现的一...
mysql增量备份失败xtrabackup: This target seems to be already prepared with --apply-log-only.
awerft的博客
05-18 1345
xtrabackup: This target seems to be already prepared with --apply-log-only. xtrabackup: error: This incremental backup seems not to be proper for the target. xtrabackup: Check 'to_lsn' of the target and 'from_lsn' of the incremental.
Mysql迁移xtrabackup_xtrabackup迁移mysql5.7.32
weixin_29224529的博客
01-27 265
问题描述：利用外部xtrabackup工具来做迁移mysql数据库，或者恢复数据库xtrabackup迁移mysql1.环境mysql源库mysql目标迁移库IP192.168.163.3196.168.163.16操作系统Ceontos7.8Ceontos7.8数据库版本mysql-5.7.32mysql-5.7.32mysql实例db_hzh03db_hzh03my.cnf路径/data/my...
MySQL中使用percona-xtrabackup工具 三种备份及恢复 （超详细教程）
博客之路,前途漫漫
01-28 3247
MySQL使用percona-xtrabackup（完整 增量 差异）备份及恢复 超详细教程 Percona 实现完整备份及恢复流程 增量备份和恢复流程 差异备份和恢复流程 以及mysql中常见的报错情况 解决办法（比如mysql启动报错 登录报错 以及恢复目录时报错）
Ubuntu xtrabackup mysql 8_xtrabackup 8.0.22 自动化全备和增量备份MySQL8脚本
05-31
好的，这里是一个自动化全备和增量备份MySQL8的脚本，基于您之前的要求进行修改： ``` #!/bin/bash # 设置备份相关的变量 MYSQL_USER="your_username" MYSQL_PASSWORD="your_password" BACKUP_DIR="/path/to/...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值