Thank you Christian,

I was just curious as to whether the size of DB was a big issue. Looks
like it isn't from your response and looking at my (limited) usage.

And yes, I'll come up with a suitable backup plan.

Thanks again,

On Mar 17, 10:36 pm, Christian Hammond <> wrote:
> Hi Raghu,
> Thanks for the nice words about the project!
> Screenshots themselves are stored in your site's
> htdocs/media/uploaded/images/ directory. They're referenced in the database
> but not stored there.
> There's no way to archive review requests from the database. I honestly
> don't know how we'd do that cleanly with Django's framework without breaking
> things. What takes up the most space is the stored diffs, not the review
> requests, but again there's no method of archiving these. After 1.0, I'm
> thinking of introducing compression for stored diffs in the database, and
> providing a script to go through and compress all these, which might help a
> little.
> Our database at VMware is pretty huge at this point, and we're not hitting
> any issues in the database. Are you just hoping for a space savings?
> I recommend using mysqlhotcopy nightly (or whenever) to do a backup of your
> database to a location on the server and ten archiving that. The advantage
> is that you end up with a snapshot of the database without additional writes
> happening during copy. You also want to back up your full site directory
> that you installed into.
> Christian
> --
> Christian Hammond -
> Review Board -
> VMware, Inc. -
> On Tue, Mar 17, 2009 at 7:34 AM, Raghu <> wrote:
> > First of all let me thank all developers and contributors for this
> > wonderful project. I have been using Reviewboard for the past couple
> > of months in my organization and found this extremely useful. This is
> > a great improvement over an internal tool that we had that helped in
> > generating pretty html diffs, but nothing more.
> > By the way I had few questions on the storage side.
> > 1. Are the screenshots stored in DB?
> > 2. How can I archive old review requests from the DB? Obviously after
> > few months my DB will grow and I may want to archive old review
> > requests from the DB and restore them later. Is there a way to do
> > this?
> > Thanks,
> > Raghu
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To post to this group, send email to
To unsubscribe from this group, send email to
For more options, visit this group at

Reply via email to