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
- In the open database, click the menu button (three lines) at the top right and choose Export.
- In File extension, choose
.sqlite, then click Export. - Save the downloaded file in a folder you can find later. The SQLite export includes tables, data, saved queries, forms, reports, and attachments.
- To hand in the work, give your teacher the
.sqlitefile using the method your teacher asked you to use. - On another computer, open
https://db.pyroom.app/and click Open file in the database library. - Choose the
.sqlitefile. In the import dialog, confirm the database name and click Import. - If a database with that name already exists, choose Keep both databases before clicking Import.
- 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 StudioRelated tutorials