Save and reopen a DB Studio database

Export a SQLite file, hand it in or move it to another computer, and import it without losing a same-named database.

Watch
Video coming soon
What you'll learn

What you'll learn

You will export your database as a .sqlite file, then reopen it in DB Studio on another computer.

Before you begin

Before you begin

Open a database you want to keep. There is no account: your work is stored in this browser on this device.

Steps

Steps

  1. In the open database, click the menu button (three lines) at the top right and choose Export.
  2. In File extension, choose .sqlite, then click Export.
  3. Save the downloaded file in a folder you can find later. The SQLite export includes tables, data, saved queries, forms, reports, and attachments.
  4. To hand in the work, give your teacher the .sqlite file using the method your teacher asked you to use.
  5. On another computer, open https://db.pyroom.app/ and click Open file in the database library.
  6. Choose the .sqlite file. In the import dialog, confirm the database name and click Import.
  7. If a database with that name already exists, choose Keep both databases before clicking Import.
  8. At the end of each lesson, export the latest work again and save the file where you can find it.
Expected result / Common mistakes

Expected result

The imported database appears in the library on the other computer. A .sqlite file is the way to move your work between computers or hand it in.

Common mistakes

  • Clearing site data or opening DB Studio in a different browser or on a different device means the browser-stored database is not there.
  • The single rolling safety copy is limited to 50 MB and is in the same browser. It is not a backup.
  • A link containing ?db=… works only in the same browser; it cannot share a database.
  • Offline use works only after the first online visit.
Try it in DB Studio
Try it in DB StudioStart with a blank database
Open DB Studio
Related tutorials