​Self hosted version : What's the process for duplicating AFFiNE Cloud data to initialize a new self-hosted instance?

[Abdoulaye-Sayouti]

What happened?

I encountered an issue with my Ubuntu machine where I was self-hosting AFFiNE, necessitating the recreation of the three containers: PostgreSQL, Redis, and AFFiNE self-host. Upon completion, I was presented with the admin sign-up page. However, I was unable to log in using my previous credentials and couldn't find a way to recover my existing work.
I'm interested in knowing whether AFFiNE Cloud data is stored locally on the disk, if there's a method to check for the presence of previous data, and if it's possible to reconnect to the workspace that generated this data.
Additionally, it would be beneficial if the data could be synchronized with iCloud or Google Drive. This would allow users to simply connect to their cloud storage to retrieve their data, mitigating the risk of data loss in the event of local machine issues.

Distribution version

Linux

What browsers are you seeing the problem on if you're using web version?

Firefox

Are you self-hosting?

• Yes

Relevant log output

No response

Anything else?

Ubuntu : 24.04

[affine-issue-bot]

Issue Status: 🆕 *Untriaged

*🆕 Untriaged

The team has not yet reviewed the issue. We usually do it within one business day.
Docs: https://github.com/toeverything/AFFiNE/blob/canary/docs/issue-triaging.md

^{_{This is an automatic reply by the bot.}}

[emerikaji]

You could have a look directly inside the PostgreSQL database, since this is where Affine stores all of its data and configuration. At the very least, this will allow you to figure out if data has been lost or if it's just an access issue.

[forehalo]

you can run yarn prisma studio in affine selfhost container and take a look at the data of your instances