Forum

Notifications

Clear all

How do you handle incremetal backup using mysqldump in MySQL?

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 16/10/2024 9:19 pm

How do you handle incremetal backup using mysqldump in MySQL (MySQL, backup, DBA)?

Quote

(@elias)

Illustrious Member

Joined: 5 months ago

Posts: 4277

Topic starter 16/10/2024 9:19 pm

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
[list=1]

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

ReplyQuote

Share: