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
- Security & Privacy
  - Backup Encryption
  - How your data is processed
  - Uninstalling
  - How can I restrict/limit the permissions provided to SimpleBackups?
  - Data Processing Agreement
- 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
- MongoDB Backup
  - Restore a MongoDB backup
  - MongoDB Backup and User Roles
  - Restore MongoDB Atlas Collection using MongoDB Compass
  - Guides
- Redis Backup
  - Restore a Redis backup
- DBaaS Providers
  - How to create serverless backups for managed databases?
  - 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
- Help & Tips
  - FAQ
  - Connecting a private database
Server & File Backup
- Create a file/server backup
- Restore a file/server backup
- Incremental File Backups
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
  - Neon
  - Scalingo
  - Planetscale
  - Amazon RDS
- 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
- 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
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
More

Knack

Knack backup guides (Retrieving credentials, and backup restore guide)

Read our detailed guide on how to set up your Knack Backup.

Knack's cloud-based database management platform allows you to build and access databases online through an API. Apart from databases, you can also create workflows and business process automation for almost anything you do in your business. Ultimately, it gives you all the tools you need to build business applications quickly and easily.

https://simplebackups.com/blog/how-to-back-up-your-knack-data/

Creating your Knack Credentials

SimpleBackups will connect to your Knack database using your API credentials.

First, login into your Knack account: https://builder.knack.com/.

Click on “Settings”

From the Settings side menu, Click on API & Code

Copy your Application Key and API Key.

Paste your credentials in your Knack Backup Recipe inputs.

Restoring Your Knack backups

Restoring your knack backup is as easy as drag and dropping the CSV files into your knack table.

To get started, find the point in time log that you wish to restore to, and clicking on the ℹ️ button.

A popup will appear that displays the backup summary, please locate the Backup Archive link and click on it to begin downloading your backup.

Once the backup archive has been downloaded, please locate the archive in your download location and open it.

You’ll find a one CSV file or more depending on how many tables you have, navigate to your knack account, select the table you wish to restore and click on the upload button.

Then, Drag and drop the corrosponding csv file from your backup archive into the dropdown box.

Follow the import wizard and select the options that suits your data recovery strategy best.

If you have any questions or feedback, please do not hesitate to reach out to our support channels.

Did this answer your question?

😞

😐

🤩

Last updated on July 15, 2024

FAQ GitHub