MySQL 8 Cookbook

How to do it...

Before you begin your backup, lock the instance for backup:

mysql> LOCK INSTANCE FOR BACKUP;

Perform the backup, and after completion, unlock the instance:

mysql> UNLOCK INSTANCE;