Guides

Backup MySQL

Archive MySQL databases with ColdPlane.

This guide covers archiving MySQL databases to cold storage using ColdPlane.

Prerequisites

MySQL 5.7 or later
A user with SELECT permission on target tables
ColdPlane CLI installed

Create the Backup

coldplane backup create \
  --db-url "mysql://readonly:password@db.example.com:3306/production" \
  --tables "users,orders,products"

Verify the Backup

coldplane backup list
coldplane backup describe <backup-id>

ColdPlane uses read-only connections and does not acquire locks on your database. For extra safety, consider using a read replica for large tables.

Backup PostgreSQL

Archive PostgreSQL databases with ColdPlane.

Querying Data

Run SQL queries against your archived cold storage data.

On this page

Prerequisites Create the Backup Verify the Backup