this post was submitted on 11 Aug 2023
1 points (100.0% liked)

mysql reddit

1 readers
0 users here now

Discussion of MySQL and assistance for MySQL related questions.

founded 1 year ago
MODERATORS
[email protected]
1
I don't understand incremental backups (Percona MySQL 8, Percona Xtrabackup 8) (zerobytes.monster)
submitted 1 year ago by [email protected] to c/[email protected]
0 comments fedilink hide all child comments
 
This is an automated archive.

The original was posted on /r/mysql by /u/UpperDelay6105 on 2023-08-11 18:49:24+00:00.

hello everyone,

right now I am doing full backups of my mysql servers using percona xtrabackup, each an every night. it has been suggested that I use incremental backups, but I don't understand how that would help me. here's my situation:

  1. sunday - full backup, not prepared
  2. monday - incremental backup
  3. tuesday - incremental backup
  4. wednesday - oh no, the server has crashed and I must rebuild. but I can't use my incremental backups because they are not prepared, and they must be prepared before they can used to restore the server. but I can't prepare them, b/c the server has died, never to return.

what am I missing here? I'm tired of doing full backups every night, but it seems to be the only way to guarantee that I can restore a crashed server.

help!

no comments (yet)
sorted by: hot top controversial new old
there doesn't seem to be anything here