How to access the Review Board database?

[Christian Kolb]

Hello all,

I'd like to know how I can access the Review Board database with a client like HeidiSQL.
As far as I know it is a MySQL database and I have a few questions:

1. Can the database be acessed with any account credentials that can enter my instance of review board?
2. Can I access the database with the same URL that leads to my review board?
3. Is a dump of the review board database suited for long-term archiving, meaning I can regenerate the whole information including attachments consistently after 10, 20 years?

Thanks in advance! :-)

[David Trowbridge]

Hi,

1. Account credentials for the Review Board application are separate from the database (and should be). The Review Board back-end is configured with some credentials for talking to the DB which can be found in the settings_local.py file.

2. The Review Board admin UI has some front-end for managing the contents of the database but it's not a full-fledged SQL interface. Whether the DB and the web UI are running on the same host is a decision that was made when setting up the server. It's often the case but not always.

3. For making backups, the DB has most of the data but you'll also want the contents of the "site directory" (which contains configuration and uploaded file attachments)

-David

--
Supercharge your Review Board with Power Pack: https://www.reviewboard.org/powerpack/
Want us to host Review Board for you? Check out RBCommons: https://rbcommons.com/
Happy user? Let us know! https://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups "reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email to reviewboard...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.