天堂

  :: :: 博问 :: 闪存 :: :: :: 订阅 订阅 :: 管理 ::

2012年9月28日

摘要: 原文链接:http://www.mysqlperformanceblog.com/2012/01/25/how-to-recover-a-single-innodb-table-from-a-full-backup/Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tabl 阅读全文
posted @ 2012-09-28 15:18 zuoxingyu 阅读(515) 评论(0) 推荐(0) 编辑

摘要: 1:数据目录 1 mysql> show global variables like '%datadir'; 3 +---------------+------------------+ 5 | Variable_name | Value | 7 +---------------+------------------+ 9 | datadir | /home/mysqldata/ |11 +---------------+------------------+13 1 row in set (0.00 sec)2:INNODB数据文件。存储INNODB数据,索引<I 阅读全文
posted @ 2012-09-28 13:45 zuoxingyu 阅读(326) 评论(0) 推荐(0) 编辑