`
cocos
  • 浏览: 400465 次
  • 性别: Icon_minigender_1
  • 来自: 福州
社区版块
存档分类
最新评论

xtrabackup

 
阅读更多
1. 下载

wget http://www.percona.com/redir/downloads/XtraBackup/XtraBackup-1.6/Linux/binary/x86_64/xtrabackup-1.6.tar.gz

2.my.cnf中必须有datadir=/var/lib/mysql

3.解压安装

tar zxvf xtrabackup.tar.gz  -C xtra   


cp xtra/bin/innobackupex
/usr/bin/innobackupex

cpxtra/bin/xtrabackup  /usr/bin/xtrabackup

cpxtra/bin/xtrabackup_51  /usr/bin/xtrabackup_51

xtra/bin/innobackupex  --user=root --defaults-file=/etc/my.cnf --database=gwy --port=3307 /data1/backup/backuptest/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2011.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

110703 20:10:15  innobackupex: Starting mysql with options:  --defaults-file='/etc/my.cnf' --user='root' --port='3307' --unbuffered --
110703 20:10:15  innobackupex: Connected to database with mysql child process (pid=28366)

110703 20:10:21  innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql  Ver 14.14 Distrib 5.1.57, for unknown-linux-gnu (x86_64) using  EditLine wrapper
innobackupex: Using mysql server version Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /data1/backup/backuptest/2011-07-03_20-10-21
110703 20:10:21  innobackupex: Starting mysql with options:  --defaults-file='/etc/my.cnf' --user='root' --port='3307' --unbuffered --
110703 20:10:21  innobackupex: Connected to database with mysql child process (pid=28389)
110703 20:10:25  innobackupex: Connection to database server closed

110703 20:10:25  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/data1/backup/backuptest/2011-07-03_20-10-21
innobackupex: Waiting for ibbackup (pid=28399) to suspend
innobackupex: Suspend file '/data1/backup/backuptest/2011-07-03_20-10-21/xtrabackup_suspended'

xtrabackup  Ver 1.6 Rev undefined for 5.1.55 unknown-linux-gnu (x86_64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data1/mysql5.1.57/data
xtrabackup: Target instance is assumed as followings.
xtrabackup:   innodb_data_home_dir = /data1/mysql5.1.57/innodb_data
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = /data1/mysql5.1.57/innodb_data
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 67108864
110703 20:10:26  InnoDB: Warning: allocated tablespace 37, old maximum was 9
>> log scanned up to (1072842)
[01] Copying /data1/mysql5.1.57/innodb_data/ibdata1 
     to /data1/backup/backuptest/2011-07-03_20-10-21/ibdata1
[01]        ...done
[01] Copying ./chapter_591up/answerresult_38.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_38.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_51.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_51.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_69.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_69.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_48.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_48.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_61.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_61.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_53.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_53.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_31.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_31.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_63.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_63.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_6.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_6.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_22.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_22.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_65.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_65.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_95.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_95.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_32.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_32.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_54.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_54.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_89.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_89.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_97.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_97.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_81.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_81.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_15.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_15.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_0.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_0.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_67.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_67.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_27.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_27.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_43.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_43.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_96.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_96.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_39.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_39.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_19.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_19.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_46.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_46.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_59.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_59.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_71.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_71.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_11.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_11.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_52.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_52.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_79.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_79.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_10.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_10.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_73.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_73.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_99.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_99.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_56.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_56.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_30.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_30.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_98.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_98.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_25.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_25.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_26.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_26.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_80.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_80.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_66.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_66.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_70.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_70.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_58.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_58.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_13.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_13.ibd
[01]        ...done
[01] Copying ./chapter_591up/tbl.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/tbl.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_57.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_57.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_83.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_83.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_7.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_7.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_90.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_90.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_29.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_29.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_9.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_9.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_64.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_64.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_20.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_20.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_78.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_78.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_82.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_82.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_8.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_8.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_84.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_84.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_40.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_40.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_3.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_3.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_50.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_50.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_55.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_55.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_85.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_85.ibd
[01]        ...done
[01] Copying ./chapter_591up/common_answerresult.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/common_answerresult.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_86.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_86.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_24.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_24.ibd
[01]        ...done
[01] Copying ./chapter_591up/common_answerlog.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/common_answerlog.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_74.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_74.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_44.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_44.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_28.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_28.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_49.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_49.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_47.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_47.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_2.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_2.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_21.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_21.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_91.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_91.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_76.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_76.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_34.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_34.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_33.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_33.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_88.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_88.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_35.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_35.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_72.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_72.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_4.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_4.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_14.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_14.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_93.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_93.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_37.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_37.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_18.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_18.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_16.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_16.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_92.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_92.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_87.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_87.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_17.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_17.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_77.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_77.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_41.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_41.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_75.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_75.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_42.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_42.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_45.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_45.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_68.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_68.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_12.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_12.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_5.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_5.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_60.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_60.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_94.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_94.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_36.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_36.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_1.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_1.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_23.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_23.ibd
[01]        ...done
[01] Copying ./chapter_591up/answerresult_62.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/chapter_591up/answerresult_62.ibd
[01]        ...done
[01] Copying ./race_gwy/race_answerlog_innodb.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/race_gwy/race_answerlog_innodb.ibd
[01]        ...done
[01] Copying ./gwy_591up_237/race_raceresult.ibd 
     to /data1/backup/backuptest/2011-07-03_20-10-21/gwy_591up_237/race_raceresult.ibd
[01]        ...done

110703 20:10:29  innobackupex: Continuing after ibbackup has suspended
110703 20:10:29  innobackupex: Starting mysql with options:  --defaults-file='/etc/my.cnf' --user='root' --port='3307' --unbuffered --
110703 20:10:29  innobackupex: Connected to database with mysql child process (pid=28413)
>> log scanned up to (1072842)

110703 20:10:33  innobackupex: Starting to lock all tables...
>> log scanned up to (1072842)
>> log scanned up to (1072842)
110703 20:10:43  innobackupex: All tables locked and flushed to disk

110703 20:10:43  innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/data1/mysql5.1.57/data'
innobackupex: Backing up files '/data1/mysql5.1.57/data/gwy/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (357 files)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)

>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
>> log scanned up to (1072842)
110703 20:57:06  innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files

innobackupex: Resuming ibbackup

xtrabackup: The latest check point (for incremental): '1072842'
>> log scanned up to (1072842)
xtrabackup: Stopping log copying thread..
xtrabackup: Transaction log of lsn (1072842) to (1072842) was copied.
110703 20:57:09  innobackupex: All tables unlocked
110703 20:57:09  innobackupex: Connection to database server closed

innobackupex: Backup created in directory '/data1/backup/backuptest/2011-07-03_20-10-21'
innobackupex: MySQL binlog position: filename 'binlog.000055', position 106
110703 20:57:09  innobackupex: completed OK!


分享到:
评论

相关推荐

    xtrabackup备份恢复shell脚本

    《Xtrabackup备份与恢复:Shell脚本详解》 在MySQL数据库管理中,数据安全至关重要,而定期备份和有效的恢复策略是保障数据安全的关键环节。Xtrabackup是一款开源的、针对InnoDB存储引擎的热备份工具,它能够在不...

    suse11编译安装xtrabackup.rar

    本文将重点讲解如何在SUSE 11操作系统上编译并安装XtraBackup,它是一个用于MySQL数据库的开源热备份工具。首先,我们来看看标题提及的两个主要文件:`xtrabackup-1.6.5.tar.gz` 和 `mysql-5.1.59.tar.gz`。 1. **...

    percona-xtrabackup-24-2.4.24-1-最新版..zip

    percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12-minimal.tar.gz percona-xtrabackup-2.4.24-Linux-x86_64.glibc2.12.tar.gz percona-xtrabackup-24-2.4.24-1.el6.x86_64.rpm percona-xtrabackup-24-2.4.24-1.el7...

    percona-xtrabackup-80-8.0.27-19.1最新版.zip

    percona-xtrabackup-8.0.27-19-Linux-x86_64.glibc2.12-minimal.tar.gz、 percona-xtrabackup-8.0.27-19-Linux-x86_64.glibc2.17-minimal.tar.gz、 percona-xtrabackup-80-8.0.27-19.1.el6.x86_64.rpm、 percona-...

    基于xtrabackup的MySQL数据库备份及还原Shell脚本.zip

    `xtrabackup`是Percona公司开发的一款高效、无锁的MySQL和MariaDB热备份工具,它允许在不影响数据库服务的情况下进行全备和增量备份。本教程将详细介绍如何使用`xtrabackup`结合Shell脚本来实现MySQL数据库的备份与...

    percona-xtrabackup-8.0.23-16.tar.gz

    《Percona XtraBackup 8.0.23-16:MySQL数据库备份与恢复的利器》 在MySQL数据库管理中,数据安全是至关重要的环节,而Percona XtraBackup正是一个不可或缺的工具,用于对MySQL数据库进行无损备份。这款软件在MySQL...

    percona-xtrabackup-24-2.4.20-1.el7.x86_64.rpm

    一、Xtrabackup是什么?  官方文档:https://www.percona.com/doc/percona-xtrabackup/2.4/intro.html  Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具...

    percona-xtrabackup mysql备份工具

    Percona XtraBackup是MySQL数据库管理系统的一个重要工具,专门用于高效、无损的数据备份。它在MySQL社区中广受欢迎,特别是在需要对InnoDB存储引擎进行热备份的场景下。这款工具的独特之处在于它可以在不中断服务的...

    percona-xtrabackup-80-8.0.11-1.el7.x86_64.rpm

    一、Xtrabackup是什么?  官方文档:https://www.percona.com/doc/percona-xtrabackup/2.4/intro.html  Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具...

    percona-xtrabackup-2.4.18-Linux-x86_64.libgcrypt183.tar.gz

    《Percona Xtrabackup 2.4.18:MySQL 5.7的高效热备份解决方案》 在MySQL数据库管理中,数据安全性和可恢复性是至关重要的环节。Percona Xtrabackup是一款备受推崇的开源备份工具,尤其在MySQL 5.7版本的环境中,它...

    percona-xtrabackup-2.4.8-Linux-x86_64.tar.gz

    《Percona Xtrabackup:MySQL数据库的高效备份与恢复解决方案》 Percona Xtrabackup是一款针对MySQL数据库的开源热备份工具,专为InnoDB和XtraDB存储引擎设计。它允许在不中断服务的情况下进行完整备份,极大地提高...

    percona-xtrabackup-2.3.6-Linux-x86_64.tar

    《Percona Xtrabackup 2.3.6 for MySQL 备份详解》 在数据库管理中,数据安全和高可用性是至关重要的。Percona Xtrabackup是一款针对MySQL数据库的强大开源备份工具,它能够实现无锁热备份,确保在不影响业务正常...

    xtrabackup8.0.35及依赖包

    xtrabackup8.0.35及依赖包

    Percona-XtraBackup-8.0.4

    Percona XtraBackup是一款开源的热备份工具,专门用于基于MySQL的服务器,它能在备份数据时不锁定数据库,确保备份过程不会对生产环境中的服务器性能造成干扰。Percona XtraBackup 8.0.4是该工具的最新版本,提供了...

    xtraBackup-8.0文档

    Percona XtraBackup 8.0 文档 Percona XtraBackup 8.0 是一个开源的热备份实用程序,用于备份 MySQL 基于服务器的数据,不会锁定数据库在备份期间。该工具适用于 24x7 高负载服务器或低事务卷环境,旨在使备份过程...

    percona-xtrabackup-8.0.23-16-Linux-x86_64.glibc2.17.tar

    《Percona XtraBackup在MySQL 8.0.x环境下的备份策略详解》 Percona XtraBackup是一款开源的、无阻塞的热备份工具,专为InnoDB存储引擎设计,适用于MySQL数据库系统。在MySQL 8.0.x版本中,由于引入了诸多新特性和...

    xtrabackup-2.4 for linux

    《Xtrabackup-2.4 for Linux:MySQL数据库备份与恢复的高效工具》 在MySQL数据库管理中,数据安全至关重要,而备份是保障数据安全的重要环节。Percona Xtrabackup-2.4 for Linux是一款专为MySQL设计的开源热备份...

Global site tag (gtag.js) - Google Analytics