2.4k questions

2.4k answers

98.0k users

5 Online Users
0 Member 5 Guest
Today Visits : 1938
Yesterday Visits : 1735
Total Visits : 2425935

Categories

Notice

Dear All, These are my answers from Quora and primarily Google; please check the answer and from others sites; the answers are free and without any liability.To make a decision, write down all of the positives and negatives on a piece of paper.Thank you,

Elias Katsaniotis, MSc

Information

Viktoria Katsanioti,

Kaliningrad,

Russia,

matizegr@yahoo.com

0 votes
54 views

How do you handle incremetal backup using mysqldump in MySQL (MySQL, backup, DBA)?
in General by (95.8k points)

1 Answer

0 votes

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

  1. Install MySQL Server
  2. Enable Binary Logging.
  3. Create a Database and Table.
  4. Take a Full MySQL MySQL Backup.
  5. Perform some inserts, updates, and deletes
  6. 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

by (95.8k points)
...