- Elias
Topic Author- Offline
- Administrator

Less More- Posts: 4306
- Thank you received: 0
5 months 3 weeks ago#3252by Elias How do you handle incremetal backup using mysqldump in MySQL (MySQL, backup, DBA)?
- Elias
Topic Author- Offline
- Administrator

Less More- Posts: 4306
- Thank you received: 0
5 months 3 weeks ago - 5 months 3 weeks ago#3253by Elias 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
Last edit: 5 months 3 weeks ago by Elias.
- Q&A
- Index
- Database
- How do you handle incremetal backup using mysqldump in MySQL?
Time to create page: 0.094 seconds