search

dublinbranch / myBackupV2

backup are not easy, expecially if you have dozen and dozen of product
0 stars 0 forks source link

Partial backup #2

Open RoyBellingan opened 3 years ago

RoyBellingan commented 3 years ago

Managing incremental backup is VERY complex to say the least and VERY timeconsuming to restore ecc

A quick option is mark a table as append only, store the max id before the start of the backup and pass the where condition to [mysql|mariadb]dump like

mysqldump --opt --quick --where="id between X AND Y"

RoyBellingan commented 3 years ago

Il problema è che poi i file saranno sparpagliati ovunque, seguire quindi https://github.com/dublinbranch/myBackupV2/wiki/Incremental-Backup