Back up and restore a database

Back up a database every night or whenever you want, and restore a backup into a new database.

Back up now

Open the database, press ⌘K and choose Backups › Back up now. A database that sleeps wakes first, so the backup holds it as it is.

Every PostgreSQL and MySQL database is also backed up every night, from the moment you add it. To stop that, choose Backups › Every night and turn it off. How many backups are kept depends on your plan. Backups cover databases only, not caches.

Restore a backup

  1. Press ⌘K and choose Backups › All backups, then pick a backup.
  2. Choose Restore.

    Ghaym restores the backup into a new database beside the old one, at the monthly price the row shows, and never touches the old one.

  3. Point your services at the new database through their DATABASE_URL variable.

Delete a backup

Pick the backup under Backups › All backups and choose Delete backup.