日期:2014-05-16 浏览次数:20749 次
mysql> use inno
Database changed
mysql> insert into mm select 1;
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into mm select 2;
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into mm select 3;
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from mm;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.00 sec)
mysql> show create table mm;
+-------+-------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------+
| mm | CREATE TABLE `mm` (
`a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------------+
1 row in set (0.00 sec)
mysql> exit
mysql> use inno
Database changed
mysql> create table t(a int)
-> ;
Query OK, 0 rows affected (0.06 sec)
mysql> show create table t;
+-------+------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------+
| t | CREATE TABLE `t` (
`a` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+------------------------------------------------+
1 row in set (0.01 sec)
mysql> insert into t select 1;
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into t select 2;
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> insert into t select 3;
Query OK, 1 row affected (0.00 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from t;
+------+
| a |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.00 sec)
mysql>
以上是准备环境,以下开始进行测试;
全备:
[root@Slave02 back_up]# xtrabackup_55 --defaults-file=/etc/my.cnf --backup --target-dir=/data/back_up/
xtrabackup_55 version 1.6.2 for MySQL server 5.5.10 Linux (i686) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /usr/local/mysql/data
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 = 5242880
130327 14:11:12 InnoDB: Using Linux native AIO
130327 14:11:12 InnoDB: Warning: allocated tablespace 2, old maximum was 0
>> log scanned up to (893330211)
[01] Copying ./ibdata1
to /data/back_up//ibdata1
>> log scanned up to (893330211)
>> log scanned up to (893330211)
[01] ...done
[01] Copying ./inno/mm.ibd
to /data/back_up//inno/mm.ibd
[01] ...done
[01] Copying ./inno/t.ibd
to /data/back_up//inno/t.ibd
[01] ...done
xtrabackup: The latest check point (for incremental): '893330211'
>> log scanned up to (893330211)
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (893330211) to (893330211) was copied.
[root@Slave02 back_up]#
[root@Slave02 back_up]# ls
ibdata1 inno xtrabackup_checkpoints xtrabackup_logfile
[root@Slave02 back_up]# cd inno/
[root@Slave02 inno]# ls
mm.ibd t.ibd
[root@Slave02 inno]# ll
total 208
-rw-r--r-- 1 root root 98304 Mar 27 14:11 mm.ibd
-rw-r--r-- 1 root root 98304 Mar 27 14:11 t.ibd
[root@Slave02 inno]#
[root@Slave02 inno]# cp /usr/local/mysql/data/inno/*.frm /data/back_up/inno/ --复制表结构文件进行到备份目录内;
[root@Slave02 inno]# cd /data/back_up/inno/
[root@Slave02 inno]# ls
mm.frm mm.ibd t.frm t.ibd ----此目录内有完整的IBD数据文件和frm表结构文件;
[root@Slave02 inno]#
[root@Slave02 inno]# cd ..
[root@Slave02 data]# ls
book log.1