bookwyrm-social/bookwyrm

Possible to restore a bookwyrm instance using a .sql backup?

オープン

#3,649 opened on 2025/07/25

 (2 件のコメント) (0 件のリアクション) (0 人の担当者)Python (326 件のフォーク)auto 404
help wantedquestion

Repository metrics

Stars
 (2,754 個のスター)
PR merge metrics
 (PR metrics pending)

説明

Hi, I was running a bookwyrm instance that got accidentally deleted due to a bad server policy and all I've got is an .sql backup (just one, fortuitiously, from 22 July). There is no documentation yet on how to restore using the .sql so I hope it is okay to ask a couple questions here. Any help is appreciated.

  1. I don't have .env file. Does that render my .sql backup totally useless?
  2. Are user accounts and password hashes also included the .sql database? Querying my .sql backup it returns no rows for user accounts even though the instance had 20 or so active users.
  3. My understanding is I would not need to run a bw-dev migration because I am not initialising a new db but restoring using an existing one. Am I correct?
  4. Is the latest Bookwyrm version db schema compatible with the 0.7.5 one?

Many thanks!

Nightmare day...

コントリビューターガイド