MySQL / MariaDB

mysql_dump

Dumps a MySQL or MariaDB database.

Typical Usage

host "db-host", hostname: "db.example.com"

job "db-backup" do
  resource "database", name: "my-database", host: "db-host"
  remotely as: "user" do
    mysql_dump user: "mysql-user", password: "secret"
  end
end

Exclude some tables

host "db-host", hostname: "db.example.com"

job "db-backup" do
  resource "database", name: "my-database", host: "db-host"
  remotely as: "user" do
    mysql_dump user: "mysql-user", password: "secret", exclude_tables: ["table1", "table2"]
    # or, to exclude a single table
    # mysql_dump user: "mysql-user", password: "secret", exclude_tables: "table1"
  end
end

Input resources

Resources of type database are allowed.

Output resource

A resource of type file.

Command options

Option	Description
`user`	The user account to use.	Required: no Defaults to: the current shell user
`password`	The password to provide.	Required: no
`exclude_tables`	A list of tables to ignore.	Required: no