日期:2014-05-16 浏览次数:20572 次
普通备份模式
[root@Slave02 tmp]# innobackupex --database="inno test" --user=root --password=root --no-lock --defaults-file=/etc/my.cnf /data0/backup/mysql 2>/tmp/mysqlbackup.log
xtrabackup_55 version 1.6.2 for MySQL server 5.5.10 Linux (i686) (revision id: undefined)
[01] Copying ./ibdata1
to /data0/backup/mysql/2013-03-28_10-10-45/ibdata1
[01] ...done
[01] Copying ./inno/mm.ibd
to /data0/backup/mysql/2013-03-28_10-10-45/inno/mm.ibd
[01] ...done
[01] Copying ./inno/t.ibd
to /data0/backup/mysql/2013-03-28_10-10-45/inno/t.ibd
[01] ...done
xtrabackup: The latest check point (for incremental): '893330831'
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (893330831) to (893330831) was copied.
[root@Slave02 tmp]#
注:使用mysql的root用户将数据库testinnodb和test的备份,备份路径是/data0/backup/mysql/。备份 成功后会在该目录下将创建以时间戳为名称的备份目录。no-lock参数用于指定备份时不锁定表。2>/tmp/mysqlbackup.log是 将备份过程中的输出信息保存到/tmp/mysqlbackup.log中
[root@Slave02 tmp]# cd /data0/backup/mysql/ ---校验备份的文件
[root@Slave02 mysql]# ll
total 20
drwxr-xr-x 4 root root 4096 Mar 28 10:11 2013-03-28_10-10-45
-rw-r--r-- 1 root root 83 Mar 28 10:10 stderr
-rw-r--r-- 1 root root 0 Mar 28 10:10 stdout
[root@Slave02 mysql]# cd 2013-03-28_10-10-45/
[root@Slave02 2013-03-28_10-10-45]# ll
total 469520
-rw-r--r-- 1 root root 363 Mar 28 10:10 backup-my.cnf
-rw-r--r-- 1 root root 480247808 Mar 28 10:11 ibdata1
drwx------ 2 root root 4096 Mar 28 10:11 inno
-rw-r--r-- 1 root root 0 Mar 28 10:11 mysql-stderr
-rw-r--r-- 1 root root 76 Mar 28 10:11 mysql-stdout
drwxr-xr-x 2 root root 4096 Mar 28 10:11 test
-rw-r--r-- 1 root root 13 Mar 28 10:11 xtrabackup_binary
-rw-r--r-- 1 root root 81 Mar 28 10:11 xtrabackup_checkpoints
-rw-r--r-- 1 root root 2560 Mar 28 10:11 xtrabackup_logfile
[root@Slave02 2013-03-28_10-10-45]# cd inno/
[root@Slave02 inno]# ll
total 2096
-rw-r----- 1 mysql mysql 8554 Mar 27 14:49 mm.frm
-rw-r--r-- 1 root root 1048576 Mar 28 10:11 mm.ibd
-rw-r----- 1 mysql mysql 8554 Mar 27 14:49 t.frm
-rw-r--r-- 1 root root 1048576 Mar 28 10:11 t.ibd
[root@Slave02 inno]#
[root@Slave02 tmp]# cat mysqlbackup.log ----查看备份记录的详细过程
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.
130328 10:10:39 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:10:39 innobackupex: Connected to database with mysql child process (pid=3714)
130328 10:10:45 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.13, for Linux (i686) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
innobackupex: Created backup directory /data0/backup/mysql/2013-03-28_10-10-45
130328 10:10:45 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --password='root' --user='root' --unbuffered --
130328 10:10:45 innobackupex: Connected to database with mysql child process (pid=3742)
130328 10:10:49 innobackupex: Connection to database server closed
130328 10:10:49 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/data0/backup/mysql/2013-03-28_10-10-45
innobackupex: Waiting for ibbackup (pid=3754) to suspend
innobackupex: Suspend file '/data0/backup/mysql/2013-03-28_10-10-45/xtrabackup_suspended'
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
xtrabackup: Target instan