1. logic backup
   1. sql statement
   2. 粒度可选
      1. all database
      2. database
      3. table
   3. 存储引擎无关
   4. 数据库无关
      1. portable
   5. server must running
      1. mysqldump
      2. mysqlimport
2. physic backup
   1. file copy only
   2. not portable
   3. lock when backup
   4. tool
      1. mysqlhotcopy
      2. ibbackup
      3. ibback
3. 全部或增量备份
   1. mysqldump --flush-logs
   2. flush后的新log将是增量备份
4. 时间点恢复
   1. 先用备份文件做大恢复
      1. mysql < sqlfile
   2. 再用binlog恢复到时间点
      1. mysqlbinlog binfile | mysql
   3. 具体时间控制
      1. --start-date
      2. --stop-date
   4. 具体位置控制
      1. --start-position
      2. --stop-position