Home Sign Up Sign In
esolve
V2EX  ›  问与答

Mysql 开启 binlog 不就自动备份了吗，为何还需要 xtrabackup 和 mysqldump 备份？

  •   
  •   esolve · May 25, 2018 · 1863 views
    This topic created in 2932 days ago, the information mentioned may be changed or developed.
  • binlog
  • xtrabackup
  • mysqldump
  • MySQL
    2 replies  •  2018-05-26 17:13:20 +08:00
    esolve
        1
    esolve  
    OP
       May 25, 2018
    ding
    fmumu
        2
    fmumu  
       May 26, 2018 via Android
    binlog 记录的是操作过程，dump 备份的是结果数据，如有说错请各位大佬轻喷
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1691 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 16:27 · PVG 00:27 · LAX 09:27 · JFK 12:27
    ♥ Do have faith in what you're doing.