Home Sign Up Sign In
esolve
V2EX  ›  问与答

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

  •   
  •   esolve · May 25, 2018 · 2213 views
    This topic created in 3085 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
    esolve
    OP
    May 25, 2018
    1
    ding
    fmumu
    fmumu
    May 26, 2018 via Android
    2
    binlog 记录的是操作过程，dump 备份的是结果数据，如有说错请各位大佬轻喷
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   5160 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 30ms · UTC 03:41 · PVG 11:41 · LAX 19:41 · JFK 22:41
    ♥ Do have faith in what you're doing.