Help, Tips & Troubleshooting – SimpleBackups Help Center

Getting Started
- Architecture
  - Backup Lifecycle & data flow
  - Backup workers
  - Our infrastructure
  - Connecting your worker/server
- Features
  - Scheduling
  - Retention
  - Notifications
  - Incremental Backups
  - Backup Automation
  - Backup Webhook
  - Backup Trigger URL
  - Teams, Projects & users
  - Backup storage
  - Backup Custom Scripts
  - Backup Anomaly Detection
  - Backup Recovery & Compliance Board
- Security & Privacy
  - Backup Encryption
  - How your data is processed
  - Uninstalling
  - How can I restrict/limit the permissions provided to SimpleBackups?
  - Data Processing Agreement
  - Data Processing Agreement DPA
- Account & Billing
  - Trial plan
  - Free plan
  - Subscriptions
  - How to cancel my account?
  - Manage invoices and payment receipts
  - My payment failed, what should I do?
  - How to redeem a coupon?
  - How can I give access to my accountant?
  - How to grant owner access to another user?
Database Backup
- MySQL Backup
  - Restore a MySQL backup
  - Guides
  - How to dump stored procedures / functions
  - How to Enable Binary Log for MySQL or MariaDB
  - How to create a Passwordless MySQL Backup
  - FAQ
  - Hot Backups in MySQL Using Percona XtraBackup
  - Restore PlanetScale / Vitess MySQL Backups
- PostgreSQL Backup
  - Restore a PostgreSQL backup
  - Guides
  - FAQ
  - Fix for pg_restore "unsupported file header" Version Error
- MongoDB Backup
  - Restore a MongoDB backup
  - MongoDB Backup and User Roles
  - Restore MongoDB Atlas Collection using MongoDB Compass
  - Guides
  - Backup From a Read-Replica Node
- Redis Backup
  - Restore a Redis backup
- DBaaS Providers
  - DigitalOcean Managed Redis
  - DigitalOcean Managed MySQL
  - DigitalOcean Managed PostgreSQL
  - DigitalOcean Managed MongoDB
  - DigitalOcean Managed database backup
  - Supabase PostgreSQL
  - Neon PostgreSQL
  - Aiven MySQL
  - Aiven PostgreSQL
  - Heroku PostgreSQL
  - Exoscale PostgreSQL
  - Vultr Database
  - OVH Database
  - Scaleway Database
  - Planetscale Database
  - Scalingo Database
  - Amazon RDS Database
  - Aiven Database
  - Scalingo Database
- Help & Tips
  - FAQ
  - Connecting a private database
  - Docker Containers Backup
  - How to create serverless backups for managed databases?
Server & File Backup
- Create a file/server backup
- Restore a file/server backup
- Incremental File Backups
- Create a File backup of a DigitalOcean Spaces Object Storage bucket
Storage Backup
- FAQ
- Guides
- Storage backup in a nutshell
- How to preserve S3 or DigitalOcean Spaces metadata on the files/objects
Server & Volume Snapshot
- Providers
  - Amazon Lightsail
  - AWS EC2
  - DigitalOcean
  - Exoscale
  - Hetzner
  - Linode
  - Scaleway
  - UpCloud
  - Vultr
  - OVH
  - Contabo
- Resources
  - Restore a Snapshot
  - FAQ
SaaS App Backup
- Apps
  - Knack
  - GitHub
  - Gitea
  - Gitlab
  - Notion
- Resources
  - FAQ
Storage Providers
- AWS S3
- Amazon S3 Glacier
- Azure Blob
- Alibaba Cloud
- Backblaze B2
- Synology C2
- CloudFlare R2
- DigitalOcean Spaces
- Dropbox
- Exoscale
- Egnyte
- Rsync.net
- Filebase
- Google Cloud Storage
- Google Cloud Storage (S3-compatible credentials)
- Google Drive
- Hetzner Storage Box
- IDrive e2
- Leviia
- MinIO
- NAS or local volume
- SFTP Storage
- SimpleStorage
- Storadera
- Storj
- UpCloud
- Wasabi
- Supabase
- IONOS
- CEPH
Help, Tips & Troubleshooting
- Connecting a Server
  - SimpleBackups IP addresses (firewall)
  - Automatically provision servers
  - Errors & Troubleshooting
- Storing your backups
  - Errors & Troubleshooting
  - How to customize the backup storage path
  - Backup Storage FAQ
  - Connecting read-only storage bucket
  - Google Cloud Storage Updated
- Backups & Logs
  - How to download individual files when backing up all databases?
  - How to generate an RSA PEM (asymmetric) key pair?
- Backup Settings & Options
  - Custom backup schedule via cron
- Others
  - curl 35 ssl error
  - The displayed Storage Usage seems incorrect, what should I do?
  - Can I connect multiple "Cloud Providers" within the same account?
  - Solving Error 2013: Lost connection to MySQL server during query when dumping table
  - Backups failing for MySQL server versions (5.7.41 and 8.0.32)
  - PostgreSQL Backup Privileges Issues
  - pg_dump: error: Error message from server: SSL SYSCALL error: EOF detected
  - mysqldump: Couldn’t execute ‘show create table table_name‘
  - Using Tailscale with Docker for Secure Database Backups
  - Couldn't execute 'FLUSH TABLES WITH READ LOCK’
More

Connecting a Server

SimpleBackups IP addresses (firewall)

In order for SimpleBackups to schedule your backups, you need to make sure its IP addresses are well whitelisted if you have a firewall.

Automatically provision servers

Automatically connect SimpleBackups to newly provisioned servers on AWS EC2, Amazon Lightsail, DigitalOcean, Laravel Forge, …

Errors & Troubleshooting

Error messages while connecting your server and how to troubleshoot them.

Storing your backups

Errors & Troubleshooting

General error messages related to storage and how to troubleshoot them.

How to customize the backup storage path

Explains the different ways you can customize your backup storage path(s).

Backup Storage FAQ

Answers to some common questions related to storing backups

Connecting read-only storage bucket

How to limit the permissions needed when connecting your storage.

Google Cloud Storage Updated

Google Cloud Storage connection using S3-compliant API has been replaced by a newer connector.

Backups & Logs

How to download individual files when backing up all databases?

You can download individual backup files when backing up all databases.

How to generate an RSA PEM (asymmetric) key pair?

Step to generate an RSA PEM (asymmetric) key pair for use with SimpleBackups Encryption

Backup Settings & Options

Custom backup schedule via cron

How to set the right backup schedule using cron expression, sample cron expressions.

Others

curl 35 ssl error

How to solve curl 35 ssl error - involving SSL/TLS handshake

The displayed Storage Usage seems incorrect, what should I do?

How to reclaim storage space from SimpleStorage and remove backups

Can I connect multiple "Cloud Providers" within the same account?

How to reclaim storage space from SimpleStorage and remove backups

Solving Error 2013: Lost connection to MySQL server during query when dumping table

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Backups failing for MySQL server versions (5.7.41 and 8.0.32)

Backups breaking for MySQL server versions (5.7.41 and 8.0.32)

PostgreSQL Backup Privileges Issues

How to grant enough permissions to your postgres user to create a backup.

pg_dump: error: Error message from server: SSL SYSCALL error: EOF detected

How to solve Postgres dump error: Dumping the contents of table failed: PQgetCopyData() failed

mysqldump: Couldn’t execute ‘show create table table_name‘

How to solve MySQL dump error: mysqldump: Couldn’t execute ‘show create table table_name‘

Using Tailscale with Docker for Secure Database Backups

Learn how to securely backup Dockerized databases using Tailscale, eliminating the need for a jump or bastion host. This step-by-step tutorial guides you through the process of setting up a Tailscale connection within a Docker container for hassle-free, private backups.

Couldn't execute 'FLUSH TABLES WITH READ LOCK’

Learn how to deal with the READ LOCK permission error, and why LOCK is needed on certain MySQL databases.