Skip to content
Manybases
esc

Search pages and sections. Try a tool name, an error code, a route.

↑↓ navigate↵ openesc close
  1. Guides
  2. Guides
  3. Export your data
Docs

Guides · Guides

Export your data

Your data leaves whenever you want. An export is a zip with the database as SQL, the project's files, and a manifest; it is made from the project's Settings → Export, by a signed-in human.

What the zip holds#

  • dump.sql — the schema and data of your tables, restorable in any SQLite (sqlite3 new.db < dump.sql) and mechanically importable into Postgres: the types are TEXT, INTEGER, REAL, BOOLEAN and JSON-as-text, and the five platform columns are plain columns.
  • files/<key> — the project's files, one entry per object.
  • manifest.json — the project (id, name, plan, region, app URL, creation date), the schema version, the tables with their access preset and creation date, the list of files with their sizes, and excluded: the internal tables the archive deliberately leaves out, each with its reason.

What stays out: the operational journals of the project (request log, SQL history, idempotency records, form rate counters), the sessions and verification tokens of end users, and their credentials (password hashes and provider tokens). What stays in: your tables, the spaces and their members, the presets, and the identity of your end users (id, e-mail, creation date).

A bound to know#

An export carries at most 40 files today. A project with more files answers 500 with the message "This project has more files than a single export can carry right now" — the database is not exported either in that case. Download the files from the Storage screen in the meantime, or contact us.

Why a human#

An export exposes the whole project, and an exposure cannot be taken back: the route requires a signed-in human, and refuses an agent before even checking that the project exists.

Leaving#

The export keeps your table names and presets, so the mapping to another backend is mechanical. Delete the project afterwards from Settings → Danger zone if you want nothing left; see Retention for what a deletion keeps.