What problem does it solve? Generated mariadb-dump commands often miss MariaDB-specific defaults, producing backups that silently omit stored routines, block live writers, or fail on re-import. This Skill encodes the correct flags and traps so dump and restore commands work the first time. ## Core Features & Use Cases - Correct flag selection: Covers --single-transaction for live InnoDB snapshots, --routines/--events (off by default), --extended-insert vs diffable dumps, and schema-only/data-only modes. - Idempotent seeding and fixtures: Explains --replace/--insert-ignore for re-runnable seeds and --skip-extended-insert with --complete-insert for version-control-friendly fixtures. - Restore and replication guidance: Clarifies that dumps are restored by piping into the mariadb client, and that replication coordinates use --master-data/--dump-slave (not --source-data/--dump-replica). - Use Case: When asked to back up a live production database, produce mariadb-dump --single-transaction --routines --events appdb > dump.sql instead of a locking default dump missing procedures. ## Quick Start Ask the AI to write a mariadb-dump command that creates a consistent backup of your live database including stored procedures and events.
