Home
MySQL

MySQL Database Backup Process

Anurag Dobade

Database backup is a process of creating a copy of the organization’s data within the database which can be used and restored in case of any:

  1. Incidents like table drop, data deletion etc.

  2. Cyberattack

  3. natural disaster


There are 2 types of backups:

  1. Physical – Copy of physical files to a different location.

  2. Logical backup – Through MySQL native tool (MySQLDUMP)


Logical backup through MySQLDump is used as part of Database Backup.


  1. Objective:

The objective of this document is to provide the details of database backup process.

  1. Database Backup Schedule

Full backup is scheduled every day at 2 AM.



  1. Backup Script

The below is the database backup script implemented to backup all databases on the instance:


A black screen with white text Description automatically generated

  1. Database Backup Retention

Currently DB backup retention is 30 days. Once the system is live will be reduced to 7 days.


  1. Sample Log

The sample database backup log:


A black background with white text Description automatically generated

Post a Comment