CentOS-6.5下MariaDB-10基于XtraBackup备份工具的原理及配置详解 - 数据库编程

+-----------+---------------------+------+-----+---------+----------------+

2.4 然后将此表的表空间删除：

MariaDB [mydb]> ALTER TABLE students DISCARD TABLESPACE;

2.5 接下来，将来自于“导出”表的服务器的mytable表的mytable.ibd和mytable.exp文件复制到当前服务器的数据目录：

[root@localhost ~]# cd /mybackups/2014-03-07_14-16-07/hellodb/

[root@localhost hellodb]# cp students.exp students.ibd /data/mydata/mydb/

[root@localhost hellodb]# ls /data/mydata/mydb/

db.opt students.exp students.frm students.ibd

[root@localhost hellodb]#

2.6 修改其属组属主：

[root@localhost hellodb]# cd /data/mydata/mydb/

[root@localhost mydb]# chown -R mysql:mysql students.*

3.1 然后使用如下命令将其导入：

MariaDB [mydb]> ALTER TABLE students IMPORT TABLESPACE;

3.2 查看是否导入成功：

MariaDB [mydb]> SELECT * FROM students;

+-------+---------------+-----+--------+---------+-----------+

+-------+---------------+-----+--------+---------+-----------+

| 1 | Shi Zhongyu | 22 | M | 2 | 3 |

| 2 | Shi Potian | 22 | M | 1 | 7 |

| 3 | Xie Yanke | 53 | M | 2 | 16 |

| 4 | Ding Dian | 32 | M | 4 | 4 |

| 5 | Yu Yutong | 26 | M | 3 | 1 |

| 6 | Shi Qing | 46 | M | 5 | NULL |

| 7 | Xi Ren | 19 | F | 3 | NULL |

| 8 | Lin Daiyu | 17 | F | 7 | NULL |

| 9 | Ren Yingying | 20 | F | 6 | NULL |

| 10 | Yue Lingshan | 19 | F | 3 | NULL |

| 11 | Yuan Chengzhi | 23 | M | 6 | NULL |

| 12 | Wen Qingqing | 19 | F | 1 | NULL |

| 13 | Tian Boguang | 33 | M | 2 | NULL |

| 14 | Lu Wushuang | 17 | F | 3 | NULL |

| 15 | Duan Yu | 19 | M | 4 | NULL |

| 16 | Xu Zhu | 21 | M | 1 | NULL |

| 17 | Lin Chong | 25 | M | 4 | NULL |

| 18 | Hua Rong | 23 | M | 7 | NULL |

| 19 | Xue Baochai | 18 | F | 6 | NULL |

| 20 | Diao Chan | 19 | F | 7 | NULL |

| 21 | Huang Yueying | 22 | F | 6 | NULL |

| 22 | Xiao Qiao | 20 | F | 1 | NULL |

| 23 | Ma Chao | 23 | M | 4 | NULL |

| 24 | Xu Xian | 27 | M | NULL | NULL |

| 25 | Sun Dasheng | 100 | M | NULL | NULL |

+-------+---------------+-----+--------+---------+-----------+

OK！！！

CentOS-6.5下MariaDB-10基于XtraBackup备份工具的原理及配置详解(五)