日期:2014-05-16 浏览次数:20494 次
普通备份模式 [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