Skip to main content

Backup database (PostgreSQL/MySQL)

Create a local dump folder:

mkdir -p ./db-dumps

Use a single rolling dump file and overwrite it daily. Do not create a new timestamped filename every day.

PostgreSQL (custom-format dump)​

export PGPASSWORD='your_password'
pg_dump \
  --host=127.0.0.1 \
  --port=5432 \
  --username=postgres \
  --format=custom \
  --file=./db-dumps/app.dump \
  app_db

MySQL (single transaction dump)​

mysqldump \
  --host=127.0.0.1 \
  --port=3306 \
  --user=root \
  --password='your_password' \
  --single-transaction \
  --quick \
  --routines \
  --triggers \
  app_db > ./db-dumps/app.sql

This page currently focuses on SQL database backup commands (such as for PostgreSQL and MySQL). Additional guides for backing up other types of databases (for example, MongoDB) will be added soon.