Back to documentation
Database

Backing Up and Restoring Databases

Learn how to create database backups and restore them when needed.

Intermediate6 min readUpdated 2024-02-01

Exporting data

To export database data:

  1. Open the Database Admin interface
  2. Select tables/collections to export
  3. Choose export format (CSV, JSON, SQL dump)
  4. Click "Export"
  5. Download the exported file

Creating SQL dumps

For full database backups:

  1. Go to Database > Backup
  2. Select the database
  3. Choose backup options
  4. Click "Create Backup"
  5. Download the SQL dump file

Importing data

To import data:

  1. Open Database Admin
  2. Click "Import"
  3. Select your file (CSV, JSON, or SQL)
  4. Map columns if needed
  5. Preview the import
  6. Click "Import"

Scheduled backups

Set up automated backups using cron jobs:

  1. Go to Cron Jobs
  2. Use a backup template or create custom
  3. Schedule daily/weekly backups
  4. Store backups on the server or external storage

Screenshots

Backing Up and Restoring Databases - Screenshot 1
Backing Up and Restoring Databases - Screenshot 2

Screenshots may vary slightly from the current version

Related Features

CSV Import

Import CSV files into database tables with column mapping and data preview. Validate before committing.

Data Export

Export database tables and query results. Support for CSV and JSON formats with filtering options.

Previous

Using the Database Admin Interface

Ready to try Server Compass?

Download the app and deploy your first application in under 5 minutes. No terminal knowledge required.

Download Server CompassMore Documentation