Error: failed to fetch query result SELECT server_uuid, local, replication, s...

jiawang

执行全量备份报错

[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]#

备份目录下面的各项文件说明

1）xtrabackup_checkpoints—— 备份类型（如完全或增量）、备份状态（如是否已经为prepared状态）和LSN(日志序列号)范围信息；

2）每个InnoDB页(通常为16k大小)都会包含一个日志序列号，即LSN。LSN是整个数据库系统的系统版本号，每个页面相关的LSN能够表明此页面最近是如何发生改变的。

3）xtrabackup_binlog_info—— mysql服务器当前正在使用的二进制日志文件及至备份这一刻为止二进制日志事件的位置。

4）xtrabackup_binlog_pos_innodb—— 二进制日志文件及用于InnoDB或XtraDB表的二进制日志文件的当前position

5）xtrabackup_binary —— 备份中用到的xtrabackup的可执行文件；

6）backup-my.cnf —— 备份命令用到的配置选项信息；