bookwyrm-social/bookwyrm

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

Ouverte

#3 649 ouverte le 25 juil. 2025

 (2 commentaires) (0 réaction) (0 personne assignée)Python (326 forks)auto 404
help wantedquestion

Métriques du dépôt

Stars
 (2 754 étoiles)
Métriques de merge PR
 (Métriques PR en attente)

Description

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...

Guide contributeur