58136: Acronis Cyber Protect, Acronis Cyber Backup: Backing Up MySQL

Last update: Wed, 2020-09-09 10:02

This article applies to Linux OS.

Follow this article to back up MySQL databases on a machine in consistent state:

  1. Download and unpack scripts that should be executed before and after snapshot creation. The scripts lock tables with “FLUSH TABLES WITH READ LOCK;” command and unlock them after Acronis software takes the snapshot.
  2. Place config.sh to the working directory of the scripts.
  3. Apply the scripts:
      • when backing up a VMware virtual machine at hypervisor level (agent-less backup), place the scripts on a VMware virtual machine to specific directories listed in this article. The scripts will be executed inside the VM upon quiesced snapshot creation automatically. There is no need to add these scripts into backup options when configuring a backup task in the Cyber Protection console.
      • when backing up a physical machine, specify these scripts in the Pre-post data capture commands section of your backup plan options:

  4. Use either Entire Machine or Disk/Volumes backup method for backing up machine with MySQL: these methods create a snapshot during backup which ensures that the database will be backed up in consistent state. File/folder backup method is not recommended for backing up relational databases such as MySQL, as capturing Pre-post data commands may not be effective.