1.安装qpress
下载解压扔进usr/bin >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>就安装完了
2.执行xbstream -x <abc.qp -C dir_name
例：
xbstream -x <back.qp -C backmysqlcls
3.执行innobackupex –decompress dir_name（恢复数据库）
innobackupex --decompress backmysqlcls/ 180327 12:24:39 innobackupex: Starting the decrypt and decompress operation IMPORTANT: Please check that the decrypt and decompress run completes successfully. At the end of a successful decrypt and decompress run innobackupex prints "completed OK!". innobackupex version 2.4.9 based on MySQL server 5.7.13 Linux (x86_64) (revision id: a467167cdd4) 180327 12:24:39 [01] decompressing ./performance_schema/threads.frm.qp 180327 12:24:39 [01] decompressing ./performance_schema/events_waits_summary_by_host_by_event_name.frm.qp 180327 12:24:39 [01] decompressing ./performance_schema/session_connect_attrs.frm.qp 180327 12:24:39 [01] decompressing ./performance_schema/variables_by_thread.frm.qp 180327 12:24:39 [01] decompressing ./performance_schema/events_waits_summary_by_account_by_event_name.frm.qp 180327 12:24:39 [01] decompressing ./performance_schema/events_stages_summary_by_account_by_event_name.frm.qp ................................... 180327 12:25:03 [01] decompressing ./sys/x@0024wait_classes_global_by_latency.frm.qp 180327 12:25:03 [01] decompressing ./sys/x@0024host_summary_by_stages.frm.qp 180327 12:25:03 [01] decompressing ./xtrabackup_binlog_info.qp 180327 12:25:03 [01] decompressing ./backup-my.cnf.qp 180327 12:25:03 completed OK!
重点强调 completed OK! 才正常结束。
微信扫一扫，打赏作者吧～
