MySQL / MariaDB - Capsule Docs

Required tools

Capsule uses mysqldump to create backups and mysql to restore them.

Debian / Ubuntu
RHEL / CentOS / Amazon Linux
macOS

sudo apt-get install mysql-client

For MariaDB:

sudo apt-get install mariadb-client

sudo dnf install mysql

brew install mysql-client && brew link --force mysql-client

Verify:

capsule doctor

Connection details

Field	Example
Host	`localhost` or `10.0.0.5`
Port	`3306`
Database name	`myapp_production`
Username	`myapp_user`
Password	your database password

Authentication

Capsule passes credentials to mysqldump via environment variables — your password is never written to a .my.cnf file or exposed in the process list.

Dump flags

Capsule runs mysqldump with --single-transaction for InnoDB tables to ensure a consistent snapshot without locking your tables during backup.

Docker

If MySQL runs in a Docker container, enter the container name in the Docker field when adding the connection. Capsule will exec into the container to run mysqldump, so no host-side MySQL tools are needed. See Docker containers for details.

Troubleshooting

Access denied for user

Confirm the username and password are correct
Make sure the user has SELECT, LOCK TABLES, SHOW VIEW, EVENT, and TRIGGER privileges on the target database

mysqldump: command not found Install MySQL client tools and run capsule doctor to confirm. MariaDB MariaDB is fully supported. The mysqldump binary shipped with MariaDB works identically for Capsule’s purposes.

​Required tools

​Connection details

​Authentication

​Dump flags

​Docker

​Troubleshooting