- 论坛徽章:
- 0
|
本帖最后由 syzxlyx_cu 于 2012-11-30 17:27 编辑
备份过程无任何报错。但是The latest check point (for incremental)在to_lsn---last_lsn之外
备份过程摘录：
export MYSQL_DATADIR=/home/mysql/${platform}_${sid}
export MYSQL_BACKDIR_BASE=/home/data/${platform}-${sid}-bak
export BINLOG_FILE_PREFIX=${platform}_${sid}
export BINLOG_DIR=/home/mysql/binlog/
export INNOBACKUPEX=/usr/bin/innobackupex
export BACKUP_LOG=/home/mysql/${platform}_${sid}/mysql-backup.log
$INNOBACKUPEX --host=127.0.0.1 --port=${dbport} --user=${dbuser} --password="${dbpass}" --defaults-file=/etc/${platform}_${sid}.cnf $MYSQL_BACKDIR 2>>$BACKUP_LOG
备份日志：
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
121102 04:04:01 innobackupex: Starting mysql with options:
--defaults-file='/etc/game2_4.cnf' --password=xxxxxxxx --user='back'
--host='127.0.0.1' --port='3307' --unbuffered --
121102 04:04:01 innobackupex: Connected to database with mysql child
process (pid=1117)
121102 04:04:07 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.5.15, for Linux (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
/data/game2-4-bak/20121102/2012-11-02_04-04-07
121102 04:04:07 innobackupex: Starting mysql with options:
--defaults-file='/etc/game2_4.cnf' --password=xxxxxxxx --user='back'
--host='127.0.0.1' --port='3307' --unbuffered --
121102 04:04:07 innobackupex: Connected to database with mysql child
process (pid=1143)
121102 04:04:09 innobackupex: Connection to database server closed
121102 04:04:09 innobackupex: Starting ibbackup with command:
xtrabackup_55 --defaults-file="/etc/game2_4.cnf"
--defaults-group="mysqld" --backup --suspend-at-end
--target-dir=/data/game2-4-bak/20121102/2012-11-02_04-04-07
innobackupex: Waiting for ibbackup (pid=1150) to suspend
innobackupex: Suspend file
'/data/game2-4-bak/20121102/2012-11-02_04-04-07/xtrabackup_suspended'
xtrabackup_55 version 2.0.3 for Percona Server 5.5.16 Linux (x86_64)
(revision id: 470)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /home/mysql/game2_4
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 104857600
121102 4:04:10 InnoDB: Using Linux native AIO
xtrabackup: using O_DIRECT
121102 4:04:10 InnoDB: Warning: allocated tablespace 271, old maximum was 9
>> log scanned up to (15049348096)
[01] Copying ./ibdata1 to
/data/game2-4-bak/20121102/2012-11-02_04-04-07/ibdata1
[01] ...done
……
……
……
>> log scanned up to (15049348096)
[01] ...done
>> log scanned up to (15049348096)
[01] ...done
>> log scanned up to (15049348096)
121102 04:04:25 innobackupex: Continuing after ibbackup has suspended
121102 04:04:25 innobackupex: Starting mysql with options:
--defaults-file='/etc/game2_4.cnf' --password=xxxxxxxx --user='back'
--host='127.0.0.1' --port='3307' --unbuffered --
121102 04:04:25 innobackupex: Connected to database with mysql child
process (pid=1164)
121102 04:04:28 innobackupex: Starting to lock all tables...
>> log scanned up to (15049348096)
>> log scanned up to (15049348096)
121102 04:04:38 innobackupex: All tables locked and flushed to disk
121102 04:04:38 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/home/mysql/game2_4'
innobackupex: Backing up files
'/home/mysql/game2_4/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'
(72 files)
innobackupex: Backing up files
'/home/mysql/game2_4/char/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'
(54 files)
i……
……
……
innobackupex: Backing up files
'/home/mysql/game2_4/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}'
(18 files)
121102 04:04:40 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): '15049700513'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (15049348096)
xtrabackup: Transaction log of lsn (15049348375) to (15049348096) was
copied.
121102 04:04:43 innobackupex: All tables unlocked
121102 04:04:43 innobackupex: Connection to database server closed
innobackupex: Backup created in directory
'/data/game2-4-bak/20121102/2012-11-02_04-04-07'
innobackupex: MySQL binlog position: filename 'game2_4.000034', position
413785124
121102 04:04:43 innobackupex: completed OK!
备份文件# more xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 15049700513
last_lsn = 15049348096 |
|
免费注册
发表于 2012-11-29 17:01
发表于 2012-11-29 21:04
