search

fr0tt / benotes

An open source self hosted notes and bookmarks taking web app.
https://benotes.org
MIT License
718 stars 49 forks source link

how to restore a backup #104

Open andreascschmidt opened 3 months ago

andreascschmidt commented 3 months ago

Silly question, but how do I restore a backup .zip to a new installation when using the docker-compose version?

Is there maybe even a way to restore a postgresql backup to a new install using SQLite?

Thanks

fr0tt commented 2 months ago

Apologies for the late response!

If you want to restore it you have to unzip the backup and put the storage folder inside your installation by replacing the existing storage folder. This only works if you manage to restore/import your database data as well.

Importing data from PostgreSQL to Sqlite could be achieved by installing a tool like https://github.com/caiiiycuk/postgresql-to-sqlite and putting the sqlite database inside the famous storage folder as database.sqlite and changing in your .env file the variable DB_CONNECTION to DB_CONNECTION=sqlite