Browse articles

Database backup

# How to back up MySQL / MariaDB automatically with Linuxteknosia Cloud

Scheduled MySQL or MariaDB backups: install the agent, add a connection, create a full or incremental (binlog) job, optional encryption, and restore from the dashboard.

2 min readUpdated: October 22, 2026[Baca dalam Bahasa Indonesia](/docs/backup-mysql)

The Linuxteknosia Cloud agent runs `mysqldump` on a schedule on your server, compresses it, encrypts it if selected, and uploads it straight to object storage without temporary files. Incremental mode uses the MySQL binlog.

## 1\. Prepare the server

Make sure `mysqldump` and `mysql` (the official MySQL 8 client or MariaDB ≥ 10.4) are on the PATH. For incremental backups: `log_bin` must be enabled (`binlog_format=ROW`) and the backup user needs the REPLICATION CLIENT, REPLICATION SLAVE, and RELOAD privileges.

## 2\. Install the agent

In the dashboard open **Servers → Add server**, then run the command shown on the server as root. The server appears online within a few seconds.

```bash
curl -fsSL https://linuxteknosia.cloud/install.sh | sudo bash -s -- --server https://linuxteknosia.cloud --token <token from the dashboard>
```

## 3\. Add a database connection

On the server page choose **Add database connection**, select the MySQL / MariaDB engine, and enter the host, user, password, and database name. The password is sent once over an encrypted channel and stored encrypted on your server, not in the control plane.

## 4\. Create a backup job

The new-job wizard walks you through four steps: source, schedule & mode, storage, notifications. Choose **Full every time** or **Full + incremental** (a new full every N runs), zstd compression, retention, and **Encrypted** or **Unencrypted**.

## 5\. Run and restore

Click **Run now** for the first backup. To restore, open the run under **History**, choose **Restore**, then select the target connection and database name. For an incremental point, the agent restores the base full backup followed by every incremental in order.

## See also

-   [How to back up PostgreSQL automatically with Linuxteknosia Cloud](/docs/backup-postgresql)
-   [How to back up MongoDB automatically with incremental oplog](/docs/backup-mongodb)
-   [How to use the AWS CLI with Linuxteknosia Cloud](/docs/aws-cli)

Still need help?

Open a support ticket from the dashboard and our team will reply as soon as possible.

[Help center](/en/help)[Open a ticket](/app/support/new)