EXPORT ALL FILES FROM A XATA LITE DATABASE

In order to export all files from a Xata Lite database, please clone this repository and follow the steps below.

1. If your database is enabled for Postgres direct access (it has a postgres endpoint in Database Settings), export the database schema to your project directory by running the command below. If the database is not enabled for Postgres direct access, skip this step.

pg_dump \
  --no-acl \
  --no-owner \
  --no-table-access-method \
  --no-privileges \
  --schema=public \
  --host=<host-region> \
  --username=<workspace-id> \
  --dbname=<database-name>:<branch> \
  --password \
  --schema-only \
  > xata-schema.sql

2. In the cloned directory, use the Xata Lite CLI to initialise your project, selecting the options listed below:

✗ xata init
🦋 Initializing project... We will ask you some questions.

You have a single workspace, using it by default: Example-workspace-xxxxxx
# [Xata] Configuration used by the CLI and the SDK
✔ Select a database or create a new one › database-with-files
✔ Generate code and types from your Xata database › JavaScript import syntax
✔ Choose the output path for the generated code … src/xata.js
✔ Do you want to generate the TypeScript declarations? … yes
✔ How should we install the @xata.io/client package? › npm

3. Add your Xata Lite database URL to the .env file as XATA_DATABASE_URL. You can find this in Database Settings.

4. Download files from the database using the appropriate script by running:

node download-files-from-pg-enabled-db.mjs

or, if your database is not enabled for Postgres direct access:

node download-files-from-non-pg-enabled-db.mjs