- Posts: 3957
How do you handle incremetal backup using mysqldump in MySQL?
- ekatsa
- Topic Author
- Offline
- Admin
Less
More
3 weeks 10 hours ago #3252
by ekatsa
How do you handle incremetal backup using mysqldump in MySQL? was created by ekatsa
How do you handle incremetal backup using mysqldump in MySQL (MySQL, backup, DBA)?
Please Log in to join the conversation.
- ekatsa
- Topic Author
- Offline
- Admin
Less
More
- Posts: 3957
3 weeks 10 hours ago - 3 weeks 10 hours ago #3253
by ekatsa
Replied by ekatsa on topic How do you handle incremetal backup using mysqldump in MySQL?
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
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.
Last edit: 3 weeks 10 hours ago by ekatsa.
Please Log in to join the conversation.
Time to create page: 0.276 seconds