what is an incremental backup?
An incremental backup scenario requires one full backup and then subsequent incrementals over a period of time. For example, if a full backup was performed on Monday, Tuesday's incremental will take a snapshot and back up all new or changed files since Monday's backup.
How do you take incremental backup in MySQL?
Incremental Backup in MySQL
- Install MySQL Server
- Enable Binary Logging.
- Create a Database and Table.
- Take a Full MySQL MySQL Backup.
- Perform some inserts, updates, and deletes
- Take an Incremental MySQL Backup.
of course as you know if the db is down you may use the server’s backup tools, but always shut down the db