---

name: syn-mysql-backup description: Operate, configure, troubleshoot, and manage MySQL. Use for MySQL engineering tasks, day-to-day operations, and production support.

MySQL: logical and physical backups

When to use

Use this skill for logical and physical backups in MySQL. This skill specifically handles logical and physical backups and nothing else in the MySQL family.

Procedure

Take logical dumps with mysqldump/mysqlpump, physical backups with Percona XtraBackup, and restore to a point in time using binlogs.

Notes

This is the MySQL skill dedicated to logical and physical backups. Sibling skills cover other MySQL capabilities; this one is the right choice only when the task is about logical and physical backups.