Less More -
Posts: 4306
-
Thank you received: 0
-
-
-
3 months 4 days ago #3252 by Elias Katsaniotis,MSc
How do you handle incremetal backup using mysqldump in MySQL (MySQL, backup, DBA)?
Less More -
Posts: 4306
-
Thank you received: 0
-
-
-
3 months 4 days ago - 3 months 4 days ago #3253 by Elias Katsaniotis,MSc
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
- Q&A
- Index
- Database
- How do you handle incremetal backup using mysqldump in MySQL?
Time to create page: 0.073 seconds