- 浏览: 393968 次
- 性别:
- 来自: 福州
文章分类
最新评论
-
生于菇乡:
GRANT CREATE ROUTINE,ALTER ROUT ...
mysql 存储过程权限相关 -
cocos:
[MYSQL] ERROR: cannot allocate ...
一次数据库升级过程 mysql5.0.78 到 5.1.57 -
cocos:
MySQL ERROR] Plugin 'InnoDB' in ...
一次数据库升级过程 mysql5.0.78 到 5.1.57 -
rjgcs123:
云集国内redis大佬的群正在招募各路redis朋友,不管你是 ...
redis 安装 配置解析 -
cocos:
mkfsmkfs -t 文件系统类型 /dev/设备名如要把/ ...
mount
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/
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!
发表评论
-
用SQL找出每种类型中时间最新的前N个数据组成的集合
2012-03-23 22:46 1495比如有文章表 Article(Id,Category ... -
mysql select 中的escape,转义
2011-10-17 16:57 2981SELECT * FROM tb1 WHERE varchar ... -
mysql 变量
2011-07-13 21:45 22051. 使用用户变量 可以清空MySQL 用 ... -
安装DBI组件。 Can't locate DBI.pm in @INC-mysql接口
2011-07-12 21:05 10657Can't locate DBI.pm in @INC ( ... -
mysql 排名
2011-07-08 11:21 1047SET @i=0; SELECT @i:=@i+1,user ... -
Linux下设置自动删除N天前备份
2011-07-06 21:00 1636find /data1/mysqldata/mysqlback ... -
修改数据库字符集
2011-07-05 13:08 1093ALTER DATABASE gongwuyuan_063 ... -
一个导数据的存储过程
2011-07-04 21:27 1244DELIMITER $$ USE `gongwuyu ... -
MySQL字符串函数:字符串截取
2011-07-04 20:08 1223MySQL 字符串截取函数:left(), right ... -
mysql 清理 binlog 二进制日志文件
2011-07-03 21:41 8700mysql> PURGE MASTER LOG ... -
MySQL的FLUSH句法
2011-07-03 19:14 2641MySQL的FLUSH句法(清除 ... -
mysql 存储过程权限相关
2011-06-30 01:43 72761.修改mysql 存储过程的definer 修改mysql. ... -
MySQL命令行的几个用法
2011-06-28 14:23 21091.使用\G按行垂直显示结果 如果一行很长,需要这行显示的话 ... -
MySQL命令行的几个用法
2011-06-28 14:17 1MySQL的客户端命令行工 ... -
mysql null
2011-06-20 20:22 1165mysql> select 0 is null, 0 ... -
External Locking skip-external-locking
2011-06-14 22:59 2088External locking is the use of ... -
innodb 日志文件异常引起innodb 启动失败
2011-06-14 22:13 15797innodb 日志文件异常引起innodb 启动失败 110 ... -
mysql innodb 引擎初始化错误
2011-06-14 22:06 3283错误日志: InnoDB: The InnoDB me ... -
mysql Incorrect integer value错误
2011-06-14 21:58 1673# Set the SQL mode to strict ... -
Out of memory mysql innodb 启动失败
2011-06-14 21:56 1607110614 9:47:07 [ERROR] /usr/lo ...
相关推荐
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-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是什么? 官方文档:https://www.percona.com/doc/percona-xtrabackup/2.4/intro.html Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具...
一、Xtrabackup是什么? 官方文档:https://www.percona.com/doc/percona-xtrabackup/2.4/intro.html Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具...
本文档是Percona XtraBackup 2.4.28版本 Percona XtraBackup是一个针对基于MySQL的服务的开源热备份实用程序,它在备份期间不会锁定 数据库。可以备份MySQL 5.1、5.5、5.6和5.7服务器上的InnoDB、XtraDB和MyISAM表上...
xtrabackup离线安装包-linux,包括依赖包目录,直接rpm -ivh * 即可,MySQL8需要使用xtrabackup8版本,MySQL8以前用xtrabackup2.4版本。具体安装方式请查看个人博客。
包含: 1 .xtrabackup-1.6.5.tar.gz 2. mysql-5.1.59.tar.gz
percona-xtrabackup-80-8.0.27-19.1.el7.x86_64.rpm percona-xtrabackup-80-8.0.7-1.el7.x86_64.rpm 参考文档: 阿里云RDS MySQL物理备份文件恢复到自建数据库 https://help.aliyun.com/document_detail/41817.html...
基于xtrabackup的MySQL数据库备份及还原Shell脚本
其中最主要的是 innobackupex 和 xtrabackup,前者是一个 perl 脚本,后者是 C/C++ 编译的二进制。 xtrabackup 是用来备份 InnoDB 表的,不能备份非 InnoDB 表,和 mysqld server 没有交互;innobackupex 脚本用来...
xtrabackup软件
基于xtrabackup8.0的数据库备份脚本,支持全库压缩备份、排除指定数据库压缩备份以及指定数据库压缩备份。备份规则:周一至周六增量备份,周日全库备份,自动管理备份和备份日志。如果有格式问题,应该是windows的...
percona-xtrabackup-2.0.2-461.rhel6.x86_64.rpm,MySQL备份工具percona-xtrabackup的rpm安装包。
XtraBackup是一个用来备份 MySQL 的 InnoDB 数据库的开源工具。例如执行增量备份的命令是: # ./xtrabackup --backup --target-dir=/backup/delta --incremental-basedir=/backup/base
官网下载的xtrabackup8.0版本rpm包,适合centos,redhat等linux操作系统使用。
MySQL+xtrabackup:1.0实现读写分离
xtrabackup 2.4
Innodb 热备份操作说明,xtrabackup说明文档
XtraBackup-8.0文档