Skip to content

Your database and backups

Where your website's data lives, how we back it up every day and how to restore a backup.

Your website keeps data: contact-form messages, appointments, orders, blog posts. This page explains where that lives, how we protect it with backups and how to bring back an older version.

#What is your database?

A database is your website's archive: a kind of big, tidy spreadsheet where your website keeps everything visitors and you fill in. At Switchboard it's a single file on our server (an SQLite database, for those who want to know).

That file lives in a separate, permanent folder. When you publish a new version of your website, only the code is replaced; your data stays where it is.

#Automatic backups

You don't have to do anything. We make backups automatically:

  • Every night. We keep the backups of the last two weeks plus one per week for the last two months, in a separate, safe place.
  • Before every publish. Just before a new version goes live, we make a backup. If an update messes up your data, you can go back to the moment just before.
  • Whenever you like. On the Backups page you can make a backup yourself with one click, for example before letting your AI assistant change something big.

#Restoring a backup

  1. Open Backups. In your dashboard, go to your website and open Backups. You'll see a list of backups with date, time and kind (nightly, before a publish, manual).
  2. Pick a backup. Choose the moment you want to go back to and click Restore.
  3. Confirm. Your website pauses briefly (usually a few seconds), we put the old data back and start your website again.

Two things a backup does not restore:

  • Your code. Want to go back to a previous version of the website itself? Do that under Publishes, or ask your AI assistant.
  • Files in File storage. They're not part of the database backup. See Managing your files.

#Downloading your data

You can download a backup with the download button next to it on the Backups page. You'll get the database file (ending in .db).

You can open it with the free program DB Browser for SQLite (Windows, macOS and Linux). Or ask your AI assistant: "Convert the data in this database file to an Excel file."

#Next step

Was this helpful?

Guide

Search the guide

Type a word or a question. Tip: press Ctrl K to open this anywhere.