search

mydumper / mydumper

Official MyDumper Project
GNU General Public License v3.0
2.57k stars 458 forks source link

[QUESTION] How to implement incremental backup with mydumper 16.5.1 #1595

Closed seajelly closed 2 months ago

seajelly commented 3 months ago

description the quuestion How to implement incremental backup with mydumper, Could you please give a case?

Environment (please complete the following information):

davidducos commented 2 months ago

Hi @seajelly, you can check this comments about incremental backups: https://github.com/mydumper/mydumper/issues/77#issuecomment-345322677 https://github.com/mydumper/mydumper/issues/421#issuecomment-936084126

mydumper doesn't support and it will never support incremental backups. It is not something that we could implement, you can use binlogs to accomplish that. However, if in a particular table, you are not deleting rows and only inserting using a numeric primary key, then you will be able to use the --where or where in the config file for that table and perform a partial backup.

If your question is why mydumper can't do it? the answer is simple, incremental backups record updates and deletes of rows, not just inserts, those statements are not available for mydumper, we might need to compare 2 databases, which is crazy as mydumper is just a logical backup tool.