由于线上环境数据库特别大，只能采取 xtrabackup备份还原
特点：
(1)备份过程快速、可靠；
(2)备份过程不会打断正在执行的事务；
(3)能够基于压缩等功能节约磁盘空间和流量；
(4)自动实现备份检验；
(5)还原速度快；
innobackupex --defaults-file=/etc/my.cnf --user=root -password=‘root‘ --database=root -socket=/var//mysql/mysql.sock /root/bakmysql
一直显示报错信息
innobackupex: Waiting for ibbackup (pid=1004) to suspend
innobackupex: Suspend file ‘/root/bakmysql/2015-12-01_17-06-01/xtrabackup_suspended_2‘
libgcc_s.so.1 must be installed for pthread_cancel to work
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 2703
main::wait_for_ibbackup_file_create(‘/root/bakmysql/2015-12-01_17-06-01/xtrabackup_suspended_2‘) called at /usr/bin/innobackupex line 2723
main::wait_for_ibbackup_suspend(‘/root/bakmysql/2015-12-01_17-06-01/xtrabackup_suspended_2‘) called at /usr/bin/innobackupex line 1976
main::backup() called at /usr/bin/innobackupex line 1601
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2703.
原来发现库没安装
解决方法：yum install libgcc.i686
本文出自 “浩子的▁运维笔录ヽ” 博客，请务必保留此出处http://chenhao6.blog.51cto.com/6228054/1718587
原文：http://chenhao6.blog.51cto.com/6228054/1718587