MariaDB

​

Example

sources:
  - type: mariadb
    host: db.internal
    port: 3306
    username: backup
    password: env:MARIADB_PASSWORD
    database: app
    extraParams:
      single-transaction: ''

​

Options

​

Requirements

• Either mariadb-dump (preferred) or mysqldump must be installed on the snapr host and available in PATH. snapr looks up mariadb-dump first; if it is missing, it falls back to mysqldump. Install at least one.
• Install via the mariadb-client package on Debian/Ubuntu (provides mariadb-dump), or mysql-client for the fallback.
• The backup user needs the same grants as MySQL: at minimum SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER, PROCESS.

​

Notes

• For mixed MySQL/MariaDB hosts, prefer the matching client package — flag compatibility is good but not perfect across major versions.

​

All databases

sources:
  - type: mariadb
    host: db.internal
    username: backup
    password: env:MARIADB_PASSWORD
    allDatabases: true

​

Related

• Sources overview
• MySQL source