| 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.