New to retool but impressed with the AI app building which helps small businesses build bespoke systems at a low subscription price.
I've created a repair tracker for internal users and share with customers which will help them see and keep track of the lifecycle of a device from receiving in on a purchase order through the repair process to harvesting device for parts to be used on other devices.
Spent a lot of time and credits using the fantastic AI assisted new pp builder.
I'm looking to backup the app so don't have to spend time creating again if anything happens to it. I know I can download as zip is that basically a full backup of app I've created at its current state?
Also application holds tables & records in the retool postgresql database and id like to be able to back this up.
I can only see option to export each tables data into a CSV file which could take a while to do is there another way that would be easier?
Thanks in advance
2 Likes
Hi @simonwhitfield, welcome to the Retool Community!
Yes, exporting your app is a good way to back it up. I'd recommend using Export as JSON, as it's the simplest and most complete backup option, and you can import it back into Retool later if needed. You can also download the app as a ZIP file.
For Retool Database, there isn't currently a one-click option to back up the entire database from the UI. The built-in option is to export individual tables as CSV files.
If you have a large amount of data or many tables, you can also connect to the Retool database using a PostgreSQL client and create a database dump for a more complete backup.
Welcome Simon!
A quick clarification, for the new app builder: there's no Export to JSON (as you may of seen), so the Download as ZIP is the way to do it. The zipped app can then be re-imported via the Import React code option within the chat panel when creating a new app. Also to note, the builder keeps a version history of which you can restore from, which is the quickest recovery option if unwanted changes have been made.
For the database: as an admin, open Database → Settings, copy the connection details, and connect a Postgres client to then export the database (as @WidleStudioLLP mentioned).
Best,
Jordan
1 Like