不恢复,只是列出备份中包含哪些文件:
可以使用 list-image
下面是一个例子:
[root@sztech1 dbback1]# mysqlbackup -uroot -proot --socket=/usr/local/mysql/mysql.sock --backup-dir=/u01/dbback/ --backup-image=mybackup.bak list-image
MySQL Enterprise Backup version 3.11.0 Linux-3.8.13-16.2.1.el6uek.x86_64-x86_64 [2014/08/26]
Copyright (c) 2003, 2014, Oracle and/or its affiliates. All Rights Reserved.
mysqlbackup: INFO: Starting with following command line ...
mysqlbackup -uroot -pxxxx --socket=/usr/local/mysql/mysql.sock
--backup-dir=/u01/dbback/ --backup-image=mybackup.bak list-image
mysqlbackup: INFO:
IMPORTANT: Please check that mysqlbackup run completes successfully.
At the end of a successful 'list-image' run mysqlbackup
prints "mysqlbackup completed OK!".
mysqlbackup: INFO: Creating 14 buffers each of size 16777216.
mysqlbackup: INFO: Backup Image MEB version string: 3.11.0 [2014/08/26]
150424 10:58:28 mysqlbackup: INFO: List-image operation starts with following threads
1 read-threads 6 process-threads
[File]: [Size: 246]: backup-my.cnf
[File]: [Size: 228]: mybackup.bak
[File]: [Size: 12752]: server-all.cnf
[File]: [Size: 3810]: server-my.cnf
[Dir]: meta
[File]: [Size: 10539]: meta/MEB_2015-04-24.08-15-32_backup_apply_log.log
[File]: [Size: 6668]: meta/MEB_2015-04-24.08-49-36_copy_back.log
[File]: [Size: 0]: meta/MEB_2015-04-24.09-47-14_backup_dir_to_image.log
[File]: [Size: 92009]: meta/backup_content.xml
[File]: [Size: 6499]: meta/backup_create.xml
[File]: [Size: 340]: meta/backup_variables.txt
[Dir]: datadir
[File]: [Size: 536870912]: datadir/ib_logfile0
[File]: [Size: 536870912]: datadir/ib_logfile1
[File]: [Size: 536870912]: datadir/ib_logfile2
[File]: [Size: 1024]: datadir/ibbackup_logfile
[File]: [Size: 79691776]: datadir/ibdata1
[File]: [Size: 170]: datadir/mysql-binlog.000019
[File]: [Size: 343]: datadir/mysql-binlog.000020
[File]: [Size: 386]: datadir/mysql-binlog.000021
[File]: [Size: 143]: datadir/mysql-binlog.000022
[File]: [Size: 120]: datadir/mysql-binlog.000023
[File]: [Size: 110]: datadir/mysql-binlog.index
[Dir]: datadir/sys
[File]: [Size: 61]: datadir/sys/db.opt
[File]: [Size: 3111]: datadir/sys/host_summary.frm
[File]: [Size: 1151]: datadir/sys/host_summary_by_file_io.frm
[File]: [Size: 2528]: datadir/sys/host_summary_by_file_io_type.frm
[File]: [Size: 2503]: datadir/sys/host_summary_by_stages.frm
[File]: [Size: 2458]: datadir/sys/host_summary_by_statement_latency.frm
[File]: [Size: 4258]: datadir/sys/host_summary_by_statement_type.frm
[File]: [Size: 2526]: datadir/sys/innodb_buffer_stats_by_schema.frm
[File]: [Size: 2824]: datadir/sys/innodb_buffer_stats_by_table.frm
[File]: [Size: 4364]: datadir/sys/io_by_thread_by_latency.frm
[File]: [Size: 4233]: datadir/sys/io_global_by_file_by_bytes.frm
[File]: [Size: 2625]: datadir/sys/io_global_by_file_by_latency.frm
[File]: [Size: 5268]: datadir/sys/io_global_by_wait_by_bytes.frm
[File]: [Size: 5093]: datadir/sys/io_global_by_wait_by_latency.frm
[File]: [Size: 3524]: datadir/sys/latest_file_io.frm
[File]: [Size: 5042]: datadir/sys/processlist.frm
[File]: [Size: 1097]: datadir/sys/ps_check_lost_instrumentation.frm
[File]: [Size: 3688]: datadir/sys/schema_index_statistics.frm
[File]: [Size: 3733]: datadir/sys/schema_object_overview.frm
[File]: [Size: 4411]: datadir/sys/schema_table_statistics.frm
[File]: [Size: 5745]: datadir/sys/schema_table_statistics_with_buffer.frm
[File]: [Size: 1736]: datadir/sys/schema_tables_with_full_table_scans.frm
[File]: [Size: 2100]: datadir/sys/schema_unused_indexes.frm
[File]: [Size: 6478]: datadir/sys/statement_analysis.frm
[File]: [Size: 3836]: datadir/sys/statements_with_errors_or_warnings.frm
[File]: [Size: 5524]: datadir/sys/statements_with_full_table_scans.frm
[File]: [Size: 3607]: datadir/sys/statements_with_runtimes_in_95th_percentile.frm
[File]: [Size: 4403]: datadir/sys/statements_with_sorting.frm
[File]: [Size: 4406]: datadir/sys/statements_with_temp_tables.frm
[File]: [Size: 3720]: datadir/sys/user_summary.frm
[File]: [Size: 1151]: datadir/sys/user_summary_by_file_io.frm
[File]: [Size: 2962]: datadir/sys/user_summary_by_file_io_type.frm
[File]: [Size: 2735]: datadir/sys/user_summary_by_stages.frm
[File]: [Size: 2458]: datadir/sys/user_summary_by_statement_latency.frm
[File]: [Size: 4499]: datadir/sys/user_summary_by_statement_type.frm
[File]: [Size: 457]: datadir/sys/version.frm
[File]: [Size: 3628]: datadir/sys/wait_classes_global_by_avg_latency.frm
[File]: [Size: 3468]: datadir/sys/wait_classes_global_by_latency.frm
[File]: [Size: 3256]: datadir/sys/waits_by_host_by_latency.frm
[File]: [Size: 3463]: datadir/sys/waits_by_user_by_latency.frm
[File]: [Size: 2465]: datadir/sys/waits_global_by_latency.frm
[File]: [Size: 2934]: datadir/sys/x@0024host_summary.frm
[File]: [Size: 1092]: datadir/sys/x@0024host_summary_by_file_io.frm
[File]: [Size: 2410]: datadir/sys/x@0024host_summary_by_file_io_type.frm
[File]: [Size: 2385]: datadir/sys/x@0024host_summary_by_stages.frm
[File]: [Size: 2281]: datadir/sys/x@0024host_summary_by_statement_latency.frm
[File]: [Size: 4081]: datadir/sys/x@0024host_summary_by_statement_type.frm
[File]: [Size: 2464]: datadir/sys/x@0024innodb_buffer_stats_by_schema.frm
[File]: [Size: 2762]: datadir/sys/x@0024innodb_buffer_stats_by_table.frm
[File]: [Size: 4128]: datadir/sys/x@0024io_by_thread_by_latency.frm
[File]: [Size: 3864]: datadir/sys/x@0024io_global_by_file_by_bytes.frm
[File]: [Size: 2330]: datadir/sys/x@0024io_global_by_file_by_latency.frm
[File]: [Size: 4725]: datadir/sys/x@0024io_global_by_wait_by_bytes.frm
[File]: [Size: 4491]: datadir/sys/x@0024io_global_by_wait_by_latency.frm
[File]: [Size: 3344]: datadir/sys/x@0024latest_file_io.frm
[File]: [Size: 4717]: datadir/sys/x@0024processlist.frm
[File]: [Size: 1449]: datadir/sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
[File]: [Size: 852]: datadir/sys/x@0024ps_digest_avg_latency_distribution.frm
[File]: [Size: 2573]: datadir/sys/x@0024ps_schema_table_statistics_io.frm
[File]: [Size: 3452]: datadir/sys/x@0024schema_index_statistics.frm
[File]: [Size: 3815]: datadir/sys/x@0024schema_table_statistics.frm
[File]: [Size: 5212]: datadir/sys/x@0024schema_table_statistics_with_buffer.frm
[File]: [Size: 6168]: datadir/sys/x@0024statement_analysis.frm
[File]: [Size: 3762]: datadir/sys/x@0024statements_with_errors_or_warnings.frm
[File]: [Size: 5349]: datadir/sys/x@0024statements_with_full_table_scans.frm
[File]: [Size: 3356]: datadir/sys/x@0024statements_with_runtimes_in_95th_percentile.frm
[File]: [Size: 4270]: datadir/sys/x@0024statements_with_sorting.frm
[File]: [Size: 4273]: datadir/sys/x@0024statements_with_temp_tables.frm
[File]: [Size: 3543]: datadir/sys/x@0024user_summary.frm
[File]: [Size: 1092]: datadir/sys/x@0024user_summary_by_file_io.frm
[File]: [Size: 2844]: datadir/sys/x@0024user_summary_by_file_io_type.frm
[File]: [Size: 2617]: datadir/sys/x@0024user_summary_by_stages.frm
[File]: [Size: 2281]: datadir/sys/x@0024user_summary_by_statement_latency.frm
[File]: [Size: 4322]: datadir/sys/x@0024user_summary_by_statement_type.frm
[File]: [Size: 3284]: datadir/sys/x@0024wait_classes_global_by_avg_latency.frm
[File]: [Size: 3235]: datadir/sys/x@0024wait_classes_global_by_latency.frm
[File]: [Size: 3079]: datadir/sys/x@0024waits_by_host_by_latency.frm
[File]: [Size: 3286]: datadir/sys/x@0024waits_by_user_by_latency.frm
[File]: [Size: 2288]: datadir/sys/x@0024waits_global_by_latency.frm
[Dir]: datadir/performance_schema
[File]: [Size: 8706]: datadir/performance_schema/accounts.frm
[File]: [Size: 8624]: datadir/performance_schema/cond_instances.frm
[File]: [Size: 61]: datadir/performance_schema/db.opt
[File]: [Size: 8991]: datadir/performance_schema/events_stages_current.frm
[File]: [Size: 8991]: datadir/performance_schema/events_stages_history.frm
[File]: [Size: 8991]: datadir/performance_schema/events_stages_history_long.frm
[File]: [Size: 8874]: datadir/performance_schema/events_stages_summary_by_account_by_event_name.frm
[File]: [Size: 8844]: datadir/performance_schema/events_stages_summary_by_host_by_event_name.frm
[File]: [Size: 8854]: datadir/performance_schema/events_stages_summary_by_thread_by_event_name.frm
[File]: [Size: 8844]: datadir/performance_schema/events_stages_summary_by_user_by_event_name.frm
[File]: [Size: 8814]: datadir/performance_schema/events_stages_summary_global_by_event_name.frm
[File]: [Size: 10525]: datadir/performance_schema/events_statements_current.frm
[File]: [Size: 10525]: datadir/performance_schema/events_statements_history.frm
[File]: [Size: 10525]: datadir/performance_schema/events_statements_history_long.frm
[File]: [Size: 10000]: datadir/performance_schema/events_statements_summary_by_account_by_event_name.frm
[File]: [Size: 10102]: datadir/performance_schema/events_statements_summary_by_digest.frm
[File]: [Size: 9970]: datadir/performance_schema/events_statements_summary_by_host_by_event_name.frm
[File]: [Size: 9980]: datadir/performance_schema/events_statements_summary_by_thread_by_event_name.frm
[File]: [Size: 9970]: datadir/performance_schema/events_statements_summary_by_user_by_event_name.frm
[File]: [Size: 9940]: datadir/performance_schema/events_statements_summary_global_by_event_name.frm
[File]: [Size: 9389]: datadir/performance_schema/events_waits_current.frm
[File]: [Size: 9389]: datadir/performance_schema/events_waits_history.frm
[File]: [Size: 9389]: datadir/performance_schema/events_waits_history_long.frm
[File]: [Size: 8874]: datadir/performance_schema/events_waits_summary_by_account_by_event_name.frm
[File]: [Size: 8844]: datadir/performance_schema/events_waits_summary_by_host_by_event_name.frm
[File]: [Size: 8878]: datadir/performance_schema/events_waits_summary_by_instance.frm
[File]: [Size: 8854]: datadir/performance_schema/events_waits_summary_by_thread_by_event_name.frm
[File]: [Size: 8844]: datadir/performance_schema/events_waits_summary_by_user_by_event_name.frm
[File]: [Size: 8814]: datadir/performance_schema/events_waits_summary_global_by_event_name.frm
[File]: [Size: 8654]: datadir/performance_schema/file_instances.frm
[File]: [Size: 9740]: datadir/performance_schema/file_summary_by_event_name.frm
[File]: [Size: 9844]: datadir/performance_schema/file_summary_by_instance.frm
[File]: [Size: 10483]: datadir/performance_schema/host_cache.frm
[File]: [Size: 8676]: datadir/performance_schema/hosts.frm
[File]: [Size: 8684]: datadir/performance_schema/mutex_instances.frm
[File]: [Size: 8908]: datadir/performance_schema/objects_summary_global_by_type.frm
[File]: [Size: 8776]: datadir/performance_schema/performance_timers.frm
[File]: [Size: 8758]: datadir/performance_schema/rwlock_instances.frm
[File]: [Size: 8716]: datadir/performance_schema/session_account_connect_attrs.frm
[File]: [Size: 8716]: datadir/performance_schema/session_connect_attrs.frm
[File]: [Size: 8620]: datadir/performance_schema/setup_actors.frm
[File]: [Size: 8605]: datadir/performance_schema/setup_consumers.frm
[File]: [Size: 8637]: datadir/performance_schema/setup_instruments.frm
[File]: [Size: 8751]: datadir/performance_schema/setup_objects.frm
[File]: [Size: 8650]: datadir/performance_schema/setup_timers.frm
[File]: [Size: 8818]: datadir/performance_schema/socket_instances.frm
[File]: [Size: 9740]: datadir/performance_schema/socket_summary_by_event_name.frm
[File]: [Size: 9804]: datadir/performance_schema/socket_summary_by_instance.frm
[File]: [Size: 10578]: datadir/performance_schema/table_io_waits_summary_by_index_usage.frm
[File]: [Size: 10488]: datadir/performance_schema/table_io_waits_summary_by_table.frm
[File]: [Size: 13518]: datadir/performance_schema/table_lock_waits_summary_by_table.frm
[File]: [Size: 9201]: datadir/performance_schema/threads.frm
[File]: [Size: 8676]: datadir/performance_schema/users.frm
[Dir]: datadir/mysql
[File]: [Size: 35]: datadir/mysql/backup_history.CSM
[File]: [Size: 489]: datadir/mysql/backup_history.CSV
[File]: [Size: 71260]: datadir/mysql/backup_history.frm
[File]: [Size: 35]: datadir/mysql/backup_progress.CSM
[File]: [Size: 409]: datadir/mysql/backup_progress.CSV
[File]: [Size: 33370]: datadir/mysql/backup_progress.frm
[File]: [Size: 0]: datadir/mysql/columns_priv.MYD
[File]: [Size: 4096]: datadir/mysql/columns_priv.MYI
[File]: [Size: 8820]: datadir/mysql/columns_priv.frm
[File]: [Size: 0]: datadir/mysql/db.MYD
[File]: [Size: 2048]: datadir/mysql/db.MYI
[File]: [Size: 9582]: datadir/mysql/db.frm
[File]: [Size: 240]: datadir/mysql/event.MYD
[File]: [Size: 4096]: datadir/mysql/event.MYI
[File]: [Size: 10223]: datadir/mysql/event.frm
[File]: [Size: 0]: datadir/mysql/func.MYD
[File]: [Size: 1024]: datadir/mysql/func.MYI
[File]: [Size: 8665]: datadir/mysql/func.frm
[File]: [Size: 35]: datadir/mysql/general_log.CSM
[File]: [Size: 0]: datadir/mysql/general_log.CSV
[File]: [Size: 8776]: datadir/mysql/general_log.frm
[File]: [Size: 1120]: datadir/mysql/help_category.MYD
[File]: [Size: 3072]: datadir/mysql/help_category.MYI
[File]: [Size: 8700]: datadir/mysql/help_category.frm
[File]: [Size: 98303]: datadir/mysql/help_keyword.MYD
[File]: [Size: 19456]: datadir/mysql/help_keyword.MYI
[File]: [Size: 8612]: datadir/mysql/help_keyword.frm
[File]: [Size: 9963]: datadir/mysql/help_relation.MYD
[File]: [Size: 18432]: datadir/mysql/help_relation.MYI
[File]: [Size: 8630]: datadir/mysql/help_relation.frm
[File]: [Size: 548676]: datadir/mysql/help_topic.MYD
[File]: [Size: 20480]: datadir/mysql/help_topic.MYI
[File]: [Size: 8770]: datadir/mysql/help_topic.frm
[File]: [Size: 12982]: datadir/mysql/innodb_index_stats.frm
[File]: [Size: 98304]: datadir/mysql/innodb_index_stats.ibd
[File]: [Size: 8830]: datadir/mysql/innodb_table_stats.frm
[File]: [Size: 98304]: datadir/mysql/innodb_table_stats.ibd
[File]: [Size: 0]: datadir/mysql/ndb_binlog_index.MYD
[File]: [Size: 1024]: datadir/mysql/ndb_binlog_index.MYI
[File]: [Size: 8898]: datadir/mysql/ndb_binlog_index.frm
[File]: [Size: 0]: datadir/mysql/plugin.MYD
[File]: [Size: 1024]: datadir/mysql/plugin.MYI
[File]: [Size: 8586]: datadir/mysql/plugin.frm
[File]: [Size: 175212]: datadir/mysql/proc.MYD
[File]: [Size: 4096]: datadir/mysql/proc.MYI
[File]: [Size: 9996]: datadir/mysql/proc.frm
[File]: [Size: 0]: datadir/mysql/procs_priv.MYD
[File]: [Size: 4096]: datadir/mysql/procs_priv.MYI
[File]: [Size: 8875]: datadir/mysql/procs_priv.frm
[File]: [Size: 2772]: datadir/mysql/proxies_priv.MYD
[File]: [Size: 5120]: datadir/mysql/proxies_priv.MYI
[File]: [Size: 8800]: datadir/mysql/proxies_priv.frm
[File]: [Size: 0]: datadir/mysql/servers.MYD
[File]: [Size: 1024]: datadir/mysql/servers.MYI
[File]: [Size: 8838]: datadir/mysql/servers.frm
[File]: [Size: 10719]: datadir/mysql/slave_master_info.frm
[File]: [Size: 98304]: datadir/mysql/slave_master_info.ibd
[File]: [Size: 9334]: datadir/mysql/slave_relay_log_info.frm
[File]: [Size: 98304]: datadir/mysql/slave_relay_log_info.ibd
[File]: [Size: 9230]: datadir/mysql/slave_worker_info.frm
[File]: [Size: 98304]: datadir/mysql/slave_worker_info.ibd
[File]: [Size: 35]: datadir/mysql/slow_log.CSM
[File]: [Size: 0]: datadir/mysql/slow_log.CSV
[File]: [Size: 9016]: datadir/mysql/slow_log.frm
[File]: [Size: 0]: datadir/mysql/tables_priv.MYD
[File]: [Size: 4096]: datadir/mysql/tables_priv.MYI
[File]: [Size: 8955]: datadir/mysql/tables_priv.frm
[File]: [Size: 0]: datadir/mysql/time_zone.MYD
[File]: [Size: 1024]: datadir/mysql/time_zone.MYI
[File]: [Size: 8636]: datadir/mysql/time_zone.frm
[File]: [Size: 0]: datadir/mysql/time_zone_leap_second.MYD
[File]: [Size: 1024]: datadir/mysql/time_zone_leap_second.MYI
[File]: [Size: 8624]: datadir/mysql/time_zone_leap_second.frm
[File]: [Size: 0]: datadir/mysql/time_zone_name.MYD
[File]: [Size: 1024]: datadir/mysql/time_zone_name.MYI
[File]: [Size: 8606]: datadir/mysql/time_zone_name.frm
[File]: [Size: 0]: datadir/mysql/time_zone_transition.MYD
[File]: [Size: 1024]: datadir/mysql/time_zone_transition.MYI
[File]: [Size: 8686]: datadir/mysql/time_zone_transition.frm
[File]: [Size: 0]: datadir/mysql/time_zone_transition_type.MYD
[File]: [Size: 1024]: datadir/mysql/time_zone_transition_type.MYI
[File]: [Size: 8748]: datadir/mysql/time_zone_transition_type.frm
[File]: [Size: 344]: datadir/mysql/user.MYD
[File]: [Size: 2048]: datadir/mysql/user.MYI
[File]: [Size: 10684]: datadir/mysql/user.frm
[Dir]: datadir/innodb_memcache
[File]: [Size: 8794]: datadir/innodb_memcache/cache_policies.frm
[File]: [Size: 8592]: datadir/innodb_memcache/config_options.frm
[File]: [Size: 13024]: datadir/innodb_memcache/containers.frm
[File]: [Size: 61]: datadir/innodb_memcache/db.opt
[File]: [Size: 8660]: datadir/innodb_memcache/demo_test.frm
150424 10:58:30 mysqlbackup: INFO: Total files as specified in image: 346
150424 10:58:30 mysqlbackup: INFO: List-image operation completed successfully.
mysqlbackup: INFO: Source Image Path = /u01/dbback/mybackup.bak
mysqlbackup completed OK!
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |