Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

Command-Line Tool Skills

Reference for the MariaDB AI Plugins skills that cover the MariaDB command-line client and utilities.

Each of these skills covers one MariaDB command-line program, with the options and behavior that differ from the corresponding MySQL program.

Skill
Plugins
What it covers

mariadb-dump

dev

MariaDB-specific behavior of the mariadb-dump client for dev workflows (seeding, fixtures, schema snapshots, consistent backups) — why --single-transaction is the live-InnoDB flag and its limits, that --routines/--events are off by default while --triggers is on, --extended-insert vs diffable dumps, schema-only/data-only, --replace/--insert-ignore for idempotent seeding, that plain dbname omits CREATE DATABASE, restoring by piping into the mariadb client, and that the replication-coordinate flags are --master-data/--dump-slave (not --source-data/--dump-replica).

mariadb-import

dev

MariaDB-specific behavior of the mariadb-import client — a command-line wrapper around LOAD DATA INFILE for bulk-loading text files. Covers the table-name-from-filename rule, TAB (not CSV) defaults, the --local vs server-side fork, --replace/--ignore, --columns vs --ignore-lines, --parallel and its --lock-tables interaction, and the locale-autodetected charset.

mariadb-client

dev

MariaDB-specific behavior of the mariadb command-line client — batch mode auto-enables silent/tab output, \G/\g and client-side DELIMITER for stored-routine bodies, --safe-updates sets max_join_size (no sql_ prefix) not sql_max_join_size, default charset auto-detects from locale rather than defaulting to latin1, and mysql is a kept symlink for the same binary.

mariadb-binlog

dev

MariaDB-specific behavior of the mariadb-binlog utility — that decoded row events (-v/-vv) are commented pseudo-SQL riding alongside the still-executable base64 BINLOG blob (not a replacement for it), that ANNOTATE_ROWS original-SQL comments are a MariaDB-only event printed by default, that --flashback generates MariaDB-specific reverse/undo SQL for DML only, --disable-log-bin to avoid re-logging on replay, and that replay means piping into the mariadb client, never running the tool itself.

This page is licensed: GPLv2

Last updated

Was this helpful?