重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1239|回复: 0
打印 上一主题 下一主题

[安装] Error: failed to fetch query result SELECT server_uuid, local, replication, s...

[复制链接]
跳转到指定楼层
楼主
发表于 2022-12-11 18:56:41 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
本帖最后由 jiawang 于 2022-12-12 17:01 编辑

执行全量备份报错
[root@sztech /]# xtrabackup-uroot -pWangjia --backup --target-dir=/xtrabackup
xtrabackup: recognized server arguments:--datadir=/usr/local/mysql/data
xtrabackup: recognized client arguments:--socket=/usr/local/mysql/mysql.sock --user=root --password=* --backup=1--target-dir=/xtrabackup
xtrabackup version 8.0.14 based on MySQL server8.0.21 Linux (x86_64) (revision id: 113f3d7)
221201 16:43:07  version_check Connecting to MySQL server withDSN'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/usr/local/mysql/mysql.sock'as 'root'  (using password: YES).
221201 16:43:07  version_check Connected to MySQL server
221201 16:43:07  version_check Executing a version checkagainst the server...
221201 16:43:07  version_check Done.
221201 16:43:07 Connecting to MySQL serverhost: localhost, user: root, password: set, port: not set, socket:/usr/local/mysql/mysql.sock
Using server version 8.0.11
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
xtrabackup: open files limit requested 0,set to 1024
xtrabackup: using the following InnoDBconfiguration:
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
Number of pools: 1
221201 16:43:07 Connecting to MySQL serverhost: localhost, user: root, password: set, port: not set, socket:/usr/local/mysql/mysql.sock
xtrabackup: Redo Log Archiving is not setup.
221201 16:43:08 >> log scanned up to(19022929)
xtrabackup: Generating a list oftablespaces
xtrabackup: Generating a list oftablespaces
Scanning './'
Completed space ID check of 2 files.
Allocated tablespace ID 2 for wangjia/test,old maximum was 0
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
221201 16:43:08 [01] Copying ./ibdata1 to/xtrabackup/ibdata1
221201 16:43:08 [01]        ...done
221201 16:43:08 [01] Copying./sys/sys_config.ibd to /xtrabackup/sys/sys_config.ibd
221201 16:43:08 [01]        ...done
221201 16:43:08 [01] Copying./wangjia/test.ibd to /xtrabackup/wangjia/test.ibd
221201 16:43:08 [01]        ...done
221201 16:43:08 [01] Copying ./mysql.ibd to/xtrabackup/mysql.ibd
221201 16:43:08 [01]        ...done
221201 16:43:08 [01] Copying ./undo_002 to/xtrabackup/undo_002
221201 16:43:08 [01]        ...done
221201 16:43:08 [01] Copying ./undo_001 to/xtrabackup/undo_001
221201 16:43:09 >> log scanned up to(19022929)
221201 16:43:09 [01]        ...done
221201 16:43:09 Starting to backupnon-InnoDB tables and files
221201 16:43:09 [01] Copyingmysql/general_log_195.sdi to /xtrabackup/mysql/general_log_195.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingmysql/general_log.CSM to /xtrabackup/mysql/general_log.CSM
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingmysql/general_log.CSV to /xtrabackup/mysql/general_log.CSV
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingmysql/slow_log_196.sdi to /xtrabackup/mysql/slow_log_196.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingmysql/slow_log.CSM to /xtrabackup/mysql/slow_log.CSM
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingmysql/slow_log.CSV to /xtrabackup/mysql/slow_log.CSV
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/cond_instances_72.sdi to/xtrabackup/performance_schema/cond_instances_72.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_cur_73.sdi to/xtrabackup/performance_schema/events_waits_cur_73.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_his_74.sdi to/xtrabackup/performance_schema/events_waits_his_74.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/events_waits_his_75.sdito /xtrabackup/performance_schema/events_waits_his_75.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_sum_76.sdi to/xtrabackup/performance_schema/events_waits_sum_76.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_sum_77.sdi to/xtrabackup/performance_schema/events_waits_sum_77.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_sum_78.sdi to/xtrabackup/performance_schema/events_waits_sum_78.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_sum_79.sdi to/xtrabackup/performance_schema/events_waits_sum_79.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_sum_80.sdi to/xtrabackup/performance_schema/events_waits_sum_80.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_waits_sum_81.sdi to/xtrabackup/performance_schema/events_waits_sum_81.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/file_instances_82.sdi to/xtrabackup/performance_schema/file_instances_82.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/file_summary_by__83.sdi to/xtrabackup/performance_schema/file_summary_by__83.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/file_summary_by__84.sdi to /xtrabackup/performance_schema/file_summary_by__84.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/host_cache_85.sdi to/xtrabackup/performance_schema/host_cache_85.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/mutex_instances_86.sdi to/xtrabackup/performance_schema/mutex_instances_86.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/objects_summary__87.sdi to /xtrabackup/performance_schema/objects_summary__87.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/performance_time_88.sdi to/xtrabackup/performance_schema/performance_time_88.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/rwlock_instances_89.sdi to/xtrabackup/performance_schema/rwlock_instances_89.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/setup_actors_90.sdi to/xtrabackup/performance_schema/setup_actors_90.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/setup_consumers_91.sdi to/xtrabackup/performance_schema/setup_consumers_91.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/setup_instrument_92.sdi to/xtrabackup/performance_schema/setup_instrument_92.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/setup_objects_93.sdi to/xtrabackup/performance_schema/setup_objects_93.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/setup_threads_94.sdi to/xtrabackup/performance_schema/setup_threads_94.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/table_io_waits_s_95.sdi to /xtrabackup/performance_schema/table_io_waits_s_95.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/table_io_waits_s_96.sdi to/xtrabackup/performance_schema/table_io_waits_s_96.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/table_lock_waits_97.sdi to/xtrabackup/performance_schema/table_lock_waits_97.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/threads_98.sdi to /xtrabackup/performance_schema/threads_98.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_cu_99.sdi to/xtrabackup/performance_schema/events_stages_cu_99.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_hi_100.sdi to/xtrabackup/performance_schema/events_stages_hi_100.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_hi_101.sdi to /xtrabackup/performance_schema/events_stages_hi_101.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_su_102.sdi to/xtrabackup/performance_schema/events_stages_su_102.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_su_103.sdi to/xtrabackup/performance_schema/events_stages_su_103.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_su_104.sdi to /xtrabackup/performance_schema/events_stages_su_104.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_su_105.sdi to/xtrabackup/performance_schema/events_stages_su_105.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_stages_su_106.sdi to/xtrabackup/performance_schema/events_stages_su_106.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_107.sdi to/xtrabackup/performance_schema/events_statement_107.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_108.sdi to/xtrabackup/performance_schema/events_statement_108.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/events_statement_109.sdito /xtrabackup/performance_schema/events_statement_109.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_110.sdi to/xtrabackup/performance_schema/events_statement_110.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_111.sdi to/xtrabackup/performance_schema/events_statement_111.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/events_statement_112.sdito /xtrabackup/performance_schema/events_statement_112.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_113.sdi to/xtrabackup/performance_schema/events_statement_113.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_114.sdi to/xtrabackup/performance_schema/events_statement_114.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/events_statement_115.sdito /xtrabackup/performance_schema/events_statement_115.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_116.sdi to/xtrabackup/performance_schema/events_statement_116.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_117.sdi to/xtrabackup/performance_schema/events_statement_117.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_statement_118.sdi to/xtrabackup/performance_schema/events_statement_118.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_119.sdi to/xtrabackup/performance_schema/events_transacti_119.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_120.sdi to/xtrabackup/performance_schema/events_transacti_120.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_121.sdi to/xtrabackup/performance_schema/events_transacti_121.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_122.sdi to/xtrabackup/performance_schema/events_transacti_122.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_123.sdi to/xtrabackup/performance_schema/events_transacti_123.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_124.sdi to/xtrabackup/performance_schema/events_transacti_124.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_125.sdi to/xtrabackup/performance_schema/events_transacti_125.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_transacti_126.sdi to/xtrabackup/performance_schema/events_transacti_126.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/events_errors_su_127.sdito /xtrabackup/performance_schema/events_errors_su_127.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_errors_su_128.sdi to/xtrabackup/performance_schema/events_errors_su_128.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_errors_su_129.sdi to/xtrabackup/performance_schema/events_errors_su_129.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/events_errors_su_130.sdito /xtrabackup/performance_schema/events_errors_su_130.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/events_errors_su_131.sdi to/xtrabackup/performance_schema/events_errors_su_131.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/users_132.sdi to/xtrabackup/performance_schema/users_132.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/accounts_133.sdi to/xtrabackup/performance_schema/accounts_133.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/hosts_134.sdi to/xtrabackup/performance_schema/hosts_134.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/socket_instances_135.sdi to/xtrabackup/performance_schema/socket_instances_135.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/socket_summary_b_136.sdi to/xtrabackup/performance_schema/socket_summary_b_136.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/socket_summary_b_137.sdi to/xtrabackup/performance_schema/socket_summary_b_137.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/session_connect__138.sdito /xtrabackup/performance_schema/session_connect__138.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/session_account__139.sdi to/xtrabackup/performance_schema/session_account__139.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/memory_summary_g_140.sdi to/xtrabackup/performance_schema/memory_summary_g_140.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/memory_summary_b_141.sdi to/xtrabackup/performance_schema/memory_summary_b_141.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/memory_summary_b_142.sdi to /xtrabackup/performance_schema/memory_summary_b_142.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/memory_summary_b_143.sdi to/xtrabackup/performance_schema/memory_summary_b_143.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/memory_summary_b_144.sdi to/xtrabackup/performance_schema/memory_summary_b_144.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/table_handles_145.sdi to /xtrabackup/performance_schema/table_handles_145.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/metadata_locks_146.sdi to/xtrabackup/performance_schema/metadata_locks_146.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/data_locks_147.sdi to/xtrabackup/performance_schema/data_locks_147.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/data_lock_waits_148.sdi to/xtrabackup/performance_schema/data_lock_waits_148.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_conn_149.sdi to/xtrabackup/performance_schema/replication_conn_149.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_grou_150.sdi to/xtrabackup/performance_schema/replication_grou_150.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_conn_151.sdi to/xtrabackup/performance_schema/replication_conn_151.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_appl_152.sdi to/xtrabackup/performance_schema/replication_appl_152.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_appl_153.sdi to/xtrabackup/performance_schema/replication_appl_153.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_appl_154.sdi to/xtrabackup/performance_schema/replication_appl_154.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_appl_155.sdi to/xtrabackup/performance_schema/replication_appl_155.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/replication_grou_156.sdito /xtrabackup/performance_schema/replication_grou_156.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_appl_157.sdi to/xtrabackup/performance_schema/replication_appl_157.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/replication_appl_158.sdi to/xtrabackup/performance_schema/replication_appl_158.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copying performance_schema/log_status_159.sdito /xtrabackup/performance_schema/log_status_159.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/prepared_stateme_160.sdi to/xtrabackup/performance_schema/prepared_stateme_160.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/user_variables_b_161.sdi to/xtrabackup/performance_schema/user_variables_b_161.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/status_by_accoun_162.sdi to/xtrabackup/performance_schema/status_by_accoun_162.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/status_by_host_163.sdi to/xtrabackup/performance_schema/status_by_host_163.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/status_by_thread_164.sdi to/xtrabackup/performance_schema/status_by_thread_164.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/status_by_user_165.sdi to/xtrabackup/performance_schema/status_by_user_165.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/global_status_166.sdi to/xtrabackup/performance_schema/global_status_166.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/session_status_167.sdi to/xtrabackup/performance_schema/session_status_167.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/variables_by_thr_168.sdi to /xtrabackup/performance_schema/variables_by_thr_168.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/global_variables_169.sdi to/xtrabackup/performance_schema/global_variables_169.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/session_variable_170.sdi to/xtrabackup/performance_schema/session_variable_170.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/variables_info_171.sdi to /xtrabackup/performance_schema/variables_info_171.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/persisted_variab_172.sdi to/xtrabackup/performance_schema/persisted_variab_172.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 [01] Copyingperformance_schema/user_defined_fun_173.sdi to/xtrabackup/performance_schema/user_defined_fun_173.sdi
221201 16:43:09 [01]        ...done
221201 16:43:09 Finished backing upnon-InnoDB tables and files
221201 16:43:09 Executing FLUSH NO_WRITE_TO_BINLOGBINARY LOGS
221201 16:43:09 Selecting LSN and binarylog position from p_s.log_status
Error: failed to fetchquery result SELECT server_uuid, local, replication, storage_engines FROMperformance_schema.log_status: Access denied; you need (at least one of) theBACKUP_ADMIN privilege(s) for this operation
报错原因:当前使用的这个备份的账号没有备份的权限

解决办法
mysql> grant all on *.* to'root'@'%'with grant option;
Query OK, 0 rows affected (0.02 sec)

再次执行成功
[root@sztech /]# xtrabackup -uroot-pWangjia --backup --target-dir=/xtrabackup
xtrabackup: recognized server arguments:--datadir=/usr/local/mysql/data
xtrabackup: recognized client arguments:--socket=/usr/local/mysql/mysql.sock --user=root --password=* --backup=1--target-dir=/xtrabackup
xtrabackup version 8.0.14 based on MySQLserver 8.0.21 Linux (x86_64) (revision id: 113f3d7)
221201 16:48:07  version_check Connecting to MySQL server withDSN'dbi:mysql:;mysql_read_default_group=xtrabackup;mysql_socket=/usr/local/mysql/mysql.sock'as 'root'  (using password: YES).
221201 16:48:07  version_check Connected to MySQL server
221201 16:48:07  version_check Executing a version checkagainst the server...
221201 16:48:07  version_check Done.
221201 16:48:07 Connecting to MySQL serverhost: localhost, user: root, password: set, port: not set, socket:/usr/local/mysql/mysql.sock
Using server version 8.0.11
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
xtrabackup: open files limit requested 0,set to 1024
xtrabackup: using the following InnoDBconfiguration:
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
Number of pools: 1
221201 16:48:07 Connecting to MySQL serverhost: localhost, user: root, password: set, port: not set, socket:/usr/local/mysql/mysql.sock
xtrabackup: Redo Log Archiving is not setup.
221201 16:48:07 >> log scanned up to(19026836)
xtrabackup: Generating a list oftablespaces
xtrabackup: Generating a list oftablespaces
Scanning './'
Completed space ID check of 2 files.
Allocated tablespace ID 2 for wangjia/test,old maximum was 0
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
221201 16:48:07 [01] Copying ./ibdata1 to/xtrabackup/ibdata1
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying./sys/sys_config.ibd to /xtrabackup/sys/sys_config.ibd
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying./wangjia/test.ibd to /xtrabackup/wangjia/test.ibd
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying ./mysql.ibd to/xtrabackup/mysql.ibd
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying ./undo_002 to/xtrabackup/undo_002
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying ./undo_001 to/xtrabackup/undo_001
221201 16:48:08 [01]        ...done
221201 16:48:08 >> log scanned up to(19026836)
221201 16:48:08 Starting to backupnon-InnoDB tables and files
221201 16:48:08 [01] Copyingmysql/general_log_195.sdi to /xtrabackup/mysql/general_log_195.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingmysql/general_log.CSM to /xtrabackup/mysql/general_log.CSM
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingmysql/general_log.CSV to /xtrabackup/mysql/general_log.CSV
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingmysql/slow_log_196.sdi to /xtrabackup/mysql/slow_log_196.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingmysql/slow_log.CSM to /xtrabackup/mysql/slow_log.CSM
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingmysql/slow_log.CSV to /xtrabackup/mysql/slow_log.CSV
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/cond_instances_72.sdi to/xtrabackup/performance_schema/cond_instances_72.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_cur_73.sdi to/xtrabackup/performance_schema/events_waits_cur_73.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_his_74.sdi to/xtrabackup/performance_schema/events_waits_his_74.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying performance_schema/events_waits_his_75.sdito /xtrabackup/performance_schema/events_waits_his_75.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_sum_76.sdi to/xtrabackup/performance_schema/events_waits_sum_76.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_sum_77.sdi to/xtrabackup/performance_schema/events_waits_sum_77.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_sum_78.sdi to/xtrabackup/performance_schema/events_waits_sum_78.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_sum_79.sdi to/xtrabackup/performance_schema/events_waits_sum_79.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_sum_80.sdi to/xtrabackup/performance_schema/events_waits_sum_80.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_waits_sum_81.sdi to/xtrabackup/performance_schema/events_waits_sum_81.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/file_instances_82.sdi to/xtrabackup/performance_schema/file_instances_82.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/file_summary_by__83.sdi to/xtrabackup/performance_schema/file_summary_by__83.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/file_summary_by__84.sdi to /xtrabackup/performance_schema/file_summary_by__84.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/host_cache_85.sdi to/xtrabackup/performance_schema/host_cache_85.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/mutex_instances_86.sdi to/xtrabackup/performance_schema/mutex_instances_86.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/objects_summary__87.sdi to /xtrabackup/performance_schema/objects_summary__87.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/performance_time_88.sdi to/xtrabackup/performance_schema/performance_time_88.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying performance_schema/rwlock_instances_89.sdito /xtrabackup/performance_schema/rwlock_instances_89.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/setup_actors_90.sdi to/xtrabackup/performance_schema/setup_actors_90.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/setup_consumers_91.sdi to/xtrabackup/performance_schema/setup_consumers_91.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/setup_instrument_92.sdi to/xtrabackup/performance_schema/setup_instrument_92.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/setup_objects_93.sdi to/xtrabackup/performance_schema/setup_objects_93.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/setup_threads_94.sdi to/xtrabackup/performance_schema/setup_threads_94.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/table_io_waits_s_95.sdi to /xtrabackup/performance_schema/table_io_waits_s_95.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/table_io_waits_s_96.sdi to/xtrabackup/performance_schema/table_io_waits_s_96.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/table_lock_waits_97.sdi to/xtrabackup/performance_schema/table_lock_waits_97.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/threads_98.sdi to /xtrabackup/performance_schema/threads_98.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_cu_99.sdi to/xtrabackup/performance_schema/events_stages_cu_99.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying performance_schema/events_stages_hi_100.sdito /xtrabackup/performance_schema/events_stages_hi_100.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_hi_101.sdi to/xtrabackup/performance_schema/events_stages_hi_101.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_su_102.sdi to/xtrabackup/performance_schema/events_stages_su_102.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_su_103.sdi to/xtrabackup/performance_schema/events_stages_su_103.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_su_104.sdi to/xtrabackup/performance_schema/events_stages_su_104.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_su_105.sdi to/xtrabackup/performance_schema/events_stages_su_105.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_stages_su_106.sdi to/xtrabackup/performance_schema/events_stages_su_106.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_statement_107.sdi to/xtrabackup/performance_schema/events_statement_107.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copyingperformance_schema/events_statement_108.sdi to/xtrabackup/performance_schema/events_statement_108.sdi
221201 16:48:08 [01]        ...done
221201 16:48:08 [01] Copying performance_schema/events_statement_109.sdito /xtrabackup/performance_schema/events_statement_109.sdi
221201 16:48:08 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_110.sdi to/xtrabackup/performance_schema/events_statement_110.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_111.sdi to/xtrabackup/performance_schema/events_statement_111.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copying performance_schema/events_statement_112.sdito /xtrabackup/performance_schema/events_statement_112.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_113.sdi to/xtrabackup/performance_schema/events_statement_113.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_114.sdi to/xtrabackup/performance_schema/events_statement_114.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_115.sdi to/xtrabackup/performance_schema/events_statement_115.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_116.sdi to/xtrabackup/performance_schema/events_statement_116.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_117.sdi to/xtrabackup/performance_schema/events_statement_117.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_statement_118.sdi to/xtrabackup/performance_schema/events_statement_118.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_119.sdi to/xtrabackup/performance_schema/events_transacti_119.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_120.sdi to/xtrabackup/performance_schema/events_transacti_120.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_121.sdi to/xtrabackup/performance_schema/events_transacti_121.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_122.sdi to/xtrabackup/performance_schema/events_transacti_122.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_123.sdi to/xtrabackup/performance_schema/events_transacti_123.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_124.sdi to/xtrabackup/performance_schema/events_transacti_124.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_125.sdi to/xtrabackup/performance_schema/events_transacti_125.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_transacti_126.sdi to/xtrabackup/performance_schema/events_transacti_126.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_errors_su_127.sdi to /xtrabackup/performance_schema/events_errors_su_127.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_errors_su_128.sdi to/xtrabackup/performance_schema/events_errors_su_128.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_errors_su_129.sdi to/xtrabackup/performance_schema/events_errors_su_129.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_errors_su_130.sdi to /xtrabackup/performance_schema/events_errors_su_130.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/events_errors_su_131.sdi to/xtrabackup/performance_schema/events_errors_su_131.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/users_132.sdi to/xtrabackup/performance_schema/users_132.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/accounts_133.sdi to/xtrabackup/performance_schema/accounts_133.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/hosts_134.sdi to/xtrabackup/performance_schema/hosts_134.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/socket_instances_135.sdi to/xtrabackup/performance_schema/socket_instances_135.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/socket_summary_b_136.sdi to/xtrabackup/performance_schema/socket_summary_b_136.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/socket_summary_b_137.sdi to/xtrabackup/performance_schema/socket_summary_b_137.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/session_connect__138.sdi to /xtrabackup/performance_schema/session_connect__138.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/session_account__139.sdi to/xtrabackup/performance_schema/session_account__139.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/memory_summary_g_140.sdi to/xtrabackup/performance_schema/memory_summary_g_140.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/memory_summary_b_141.sdi to /xtrabackup/performance_schema/memory_summary_b_141.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/memory_summary_b_142.sdi to/xtrabackup/performance_schema/memory_summary_b_142.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/memory_summary_b_143.sdi to/xtrabackup/performance_schema/memory_summary_b_143.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/memory_summary_b_144.sdi to /xtrabackup/performance_schema/memory_summary_b_144.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/table_handles_145.sdi to/xtrabackup/performance_schema/table_handles_145.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/metadata_locks_146.sdi to/xtrabackup/performance_schema/metadata_locks_146.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/data_locks_147.sdi to/xtrabackup/performance_schema/data_locks_147.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/data_lock_waits_148.sdi to/xtrabackup/performance_schema/data_lock_waits_148.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_conn_149.sdi to/xtrabackup/performance_schema/replication_conn_149.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_grou_150.sdi to/xtrabackup/performance_schema/replication_grou_150.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_conn_151.sdi to/xtrabackup/performance_schema/replication_conn_151.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copying performance_schema/replication_appl_152.sdito /xtrabackup/performance_schema/replication_appl_152.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_appl_153.sdi to/xtrabackup/performance_schema/replication_appl_153.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_appl_154.sdi to/xtrabackup/performance_schema/replication_appl_154.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copying performance_schema/replication_appl_155.sdito /xtrabackup/performance_schema/replication_appl_155.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_grou_156.sdi to/xtrabackup/performance_schema/replication_grou_156.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_appl_157.sdi to/xtrabackup/performance_schema/replication_appl_157.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/replication_appl_158.sdi to/xtrabackup/performance_schema/replication_appl_158.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/log_status_159.sdi to/xtrabackup/performance_schema/log_status_159.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/prepared_stateme_160.sdi to/xtrabackup/performance_schema/prepared_stateme_160.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/user_variables_b_161.sdi to/xtrabackup/performance_schema/user_variables_b_161.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/status_by_accoun_162.sdi to/xtrabackup/performance_schema/status_by_accoun_162.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/status_by_host_163.sdi to/xtrabackup/performance_schema/status_by_host_163.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/status_by_thread_164.sdi to /xtrabackup/performance_schema/status_by_thread_164.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/status_by_user_165.sdi to/xtrabackup/performance_schema/status_by_user_165.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/global_status_166.sdi to/xtrabackup/performance_schema/global_status_166.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/session_status_167.sdi to /xtrabackup/performance_schema/session_status_167.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/variables_by_thr_168.sdi to/xtrabackup/performance_schema/variables_by_thr_168.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/global_variables_169.sdi to/xtrabackup/performance_schema/global_variables_169.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/session_variable_170.sdi to /xtrabackup/performance_schema/session_variable_170.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/variables_info_171.sdi to/xtrabackup/performance_schema/variables_info_171.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copying performance_schema/persisted_variab_172.sdito /xtrabackup/performance_schema/persisted_variab_172.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 [01] Copyingperformance_schema/user_defined_fun_173.sdi to/xtrabackup/performance_schema/user_defined_fun_173.sdi
221201 16:48:09 [01]        ...done
221201 16:48:09 Finished backing upnon-InnoDB tables and files
221201 16:48:09 Executing FLUSHNO_WRITE_TO_BINLOG BINARY LOGS
221201 16:48:09 Selecting LSN and binarylog position from p_s.log_status
221201 16:48:09 [00] Copying/usr/local/mysql/data/binlog.000003 to /xtrabackup/binlog.000003 up to position155
221201 16:48:09 [00]        ...done
221201 16:48:09 [00] Writing/xtrabackup/binlog.index
221201 16:48:09 [00]        ...done
221201 16:48:09 [00] Writing/xtrabackup/xtrabackup_binlog_info
221201 16:48:09 [00]        ...done
221201 16:48:09 Executing FLUSHNO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (forincremental): '19026836'
xtrabackup: Stopping log copying thread atLSN 19026836.
Starting to parse redo log at lsn =19026527

221201 16:48:09 All tables unlocked
221201 16:48:09 [00] Copying ib_buffer_poolto /xtrabackup/ib_buffer_pool
221201 16:48:09 [00]        ...done
221201 16:48:09 Backup created in directory'/xtrabackup/'
MySQL binlog position: filename'binlog.000003', position '155'
221201 16:48:09 [00] Writing/xtrabackup/backup-my.cnf
221201 16:48:09 [00]        ...done
221201 16:48:09 [00] Writing/xtrabackup/xtrabackup_info
221201 16:48:09 [00]        ...done
xtrabackup: Transaction log of lsn(19026836) to (19026836) was copied.
221201 16:48:10 completedOK!
验证
[root@sztech xtrabackup]# ll
total 57392
-rw-r-----. 1 root root      475 Dec 1 16:48 backup-my.cnf
-rw-r-----. 1 root root      155 Dec 1 16:48 binlog.000003
-rw-r-----. 1 root root       16 Dec 1 16:48 binlog.index
-rw-r-----. 1 root root     5927 Dec 1 16:48 ib_buffer_pool
-rw-r-----. 1 root root 12582912 Dec  1 16:48 ibdata1
drwxr-x---. 2 root root      143 Dec 1 16:48 mysql
-rw-r-----. 1 root root 25165824 Dec  1 16:48 mysql.ibd
drwxr-x---. 2 root root     4096 Dec 1 16:48 performance_schema
drwxr-x---. 2 root root       28 Dec 1 16:48 sys
-rw-r-----. 1 root root 10485760 Dec  1 16:48 undo_001
-rw-r-----. 1 root root 10485760 Dec  1 16:48 undo_002
drwxr-x---. 2 root root       22 Dec 1 16:48 wangjia
-rw-r-----. 1 root root       18 Dec 1 16:48 xtrabackup_binlog_info
-rw-r-----. 1 root root       95 Dec 1 16:48 xtrabackup_checkpoints
-rw-r-----. 1 root root      461 Dec 1 16:48 xtrabackup_info
-rw-r-----. 1 root root     2560 Dec 1 16:48 xtrabackup_logfile
-rw-r-----. 1 root root       39 Dec 1 16:48 xtrabackup_tablespaces
[root@sztech xtrabackup]#
[root@sztech xtrabackup]# morextrabackup_checkpoints
backup_type = full-backuped  备份类型(如完全或增量)
from_lsn = 0
to_lsn = 19026836
last_lsn = 19026836
flushed_lsn = 0
[root@sztech xtrabackup]#
备份目录下面的各项文件说明
1xtrabackup_checkpoints—— 备份类型(如完全或增量)、备份状态(如是否已经为prepared状态)和LSN(日志序列号)范围信息;
2)每个InnoDB(通常为16k大小)都会包含一个日志序列号,即LSNLSN是整个数据库系统的系统版本号,每个页面相关的LSN能够表明此页面最近是如何发生改变的。
3xtrabackup_binlog_info—— mysql服务器当前正在使用的二进制日志文件及至备份这一刻为止二进制日志事件的位置。
4xtrabackup_binlog_pos_innodb—— 二进制日志文件及用于InnoDBXtraDB表的二进制日志文件的当前position
5xtrabackup_binary —— 备份中用到的xtrabackup的可执行文件;
6backup-my.cnf —— 备份命令用到的配置选项信息;

分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-11-28 20:20 , Processed in 0.135320 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表