- 浏览: 400465 次
- 性别:
- 来自: 福州
文章分类
最新评论
-
生于菇乡:
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 1536比如有文章表 Article(Id,Category ... -
mysql select 中的escape,转义
2011-10-17 16:57 3041SELECT * FROM tb1 WHERE varchar ... -
mysql 变量
2011-07-13 21:45 22681. 使用用户变量 可以清空MySQL 用 ... -
安装DBI组件。 Can't locate DBI.pm in @INC-mysql接口
2011-07-12 21:05 10725Can't locate DBI.pm in @INC ( ... -
mysql 排名
2011-07-08 11:21 1103SET @i=0; SELECT @i:=@i+1,user ... -
Linux下设置自动删除N天前备份
2011-07-06 21:00 1689find /data1/mysqldata/mysqlback ... -
修改数据库字符集
2011-07-05 13:08 1146ALTER DATABASE gongwuyuan_063 ... -
一个导数据的存储过程
2011-07-04 21:27 1294DELIMITER $$ USE `gongwuyu ... -
MySQL字符串函数:字符串截取
2011-07-04 20:08 1269MySQL 字符串截取函数:left(), right ... -
mysql 清理 binlog 二进制日志文件
2011-07-03 21:41 8772mysql> PURGE MASTER LOG ... -
MySQL的FLUSH句法
2011-07-03 19:14 2689MySQL的FLUSH句法(清除 ... -
mysql 存储过程权限相关
2011-06-30 01:43 73451.修改mysql 存储过程的definer 修改mysql. ... -
MySQL命令行的几个用法
2011-06-28 14:23 21641.使用\G按行垂直显示结果 如果一行很长,需要这行显示的话 ... -
MySQL命令行的几个用法
2011-06-28 14:17 1MySQL的客户端命令行工 ... -
mysql null
2011-06-20 20:22 1214mysql> select 0 is null, 0 ... -
External Locking skip-external-locking
2011-06-14 22:59 2130External locking is the use of ... -
innodb 日志文件异常引起innodb 启动失败
2011-06-14 22:13 15846innodb 日志文件异常引起innodb 启动失败 110 ... -
mysql innodb 引擎初始化错误
2011-06-14 22:06 3323错误日志: InnoDB: The InnoDB me ... -
mysql Incorrect integer value错误
2011-06-14 21:58 1759# Set the SQL mode to strict ... -
Out of memory mysql innodb 启动失败
2011-06-14 21:56 1646110614 9:47:07 [ERROR] /usr/lo ...
相关推荐
《Xtrabackup备份与恢复:Shell脚本详解》 在MySQL数据库管理中,数据安全至关重要,而定期备份和有效的恢复策略是保障数据安全的关键环节。Xtrabackup是一款开源的、针对InnoDB存储引擎的热备份工具,它能够在不...
本文将重点讲解如何在SUSE 11操作系统上编译并安装XtraBackup,它是一个用于MySQL数据库的开源热备份工具。首先,我们来看看标题提及的两个主要文件:`xtrabackup-1.6.5.tar.gz` 和 `mysql-5.1.59.tar.gz`。 1. **...
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`是Percona公司开发的一款高效、无锁的MySQL和MariaDB热备份工具,它允许在不影响数据库服务的情况下进行全备和增量备份。本教程将详细介绍如何使用`xtrabackup`结合Shell脚本来实现MySQL数据库的备份与...
《Percona XtraBackup 8.0.23-16:MySQL数据库备份与恢复的利器》 在MySQL数据库管理中,数据安全是至关重要的环节,而Percona XtraBackup正是一个不可或缺的工具,用于对MySQL数据库进行无损备份。这款软件在MySQL...
一、Xtrabackup是什么? 官方文档:https://www.percona.com/doc/percona-xtrabackup/2.4/intro.html Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具...
Percona XtraBackup是MySQL数据库管理系统的一个重要工具,专门用于高效、无损的数据备份。它在MySQL社区中广受欢迎,特别是在需要对InnoDB存储引擎进行热备份的场景下。这款工具的独特之处在于它可以在不中断服务的...
一、Xtrabackup是什么? 官方文档:https://www.percona.com/doc/percona-xtrabackup/2.4/intro.html Xtrabackup是一个对InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具...
《Percona Xtrabackup 2.4.18:MySQL 5.7的高效热备份解决方案》 在MySQL数据库管理中,数据安全性和可恢复性是至关重要的环节。Percona Xtrabackup是一款备受推崇的开源备份工具,尤其在MySQL 5.7版本的环境中,它...
《Percona Xtrabackup:MySQL数据库的高效备份与恢复解决方案》 Percona Xtrabackup是一款针对MySQL数据库的开源热备份工具,专为InnoDB和XtraDB存储引擎设计。它允许在不中断服务的情况下进行完整备份,极大地提高...
《Percona Xtrabackup 2.3.6 for MySQL 备份详解》 在数据库管理中,数据安全和高可用性是至关重要的。Percona Xtrabackup是一款针对MySQL数据库的强大开源备份工具,它能够实现无锁热备份,确保在不影响业务正常...
xtrabackup8.0.35及依赖包
Percona XtraBackup是一款开源的热备份工具,专门用于基于MySQL的服务器,它能在备份数据时不锁定数据库,确保备份过程不会对生产环境中的服务器性能造成干扰。Percona XtraBackup 8.0.4是该工具的最新版本,提供了...
Percona XtraBackup 8.0 文档 Percona XtraBackup 8.0 是一个开源的热备份实用程序,用于备份 MySQL 基于服务器的数据,不会锁定数据库在备份期间。该工具适用于 24x7 高负载服务器或低事务卷环境,旨在使备份过程...
《Percona XtraBackup在MySQL 8.0.x环境下的备份策略详解》 Percona XtraBackup是一款开源的、无阻塞的热备份工具,专为InnoDB存储引擎设计,适用于MySQL数据库系统。在MySQL 8.0.x版本中,由于引入了诸多新特性和...
《Xtrabackup-2.4 for Linux:MySQL数据库备份与恢复的高效工具》 在MySQL数据库管理中,数据安全至关重要,而备份是保障数据安全的重要环节。Percona Xtrabackup-2.4 for Linux是一款专为MySQL设计的开源热备份...