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!
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值