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.
On Mar 17, 10:36 pm, Christian Hammond <chip...@chipx86.com> 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
> 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 Hammond - chip...@chipx86.com
> Review Board -http://www.review-board.org
> VMware, Inc. -http://www.vmware.com
> On Tue, Mar 17, 2009 at 7:34 AM, Raghu <raghu...@gmail.com> 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
To post to this group, send email to firstname.lastname@example.org
To unsubscribe from this group, send email to
For more options, visit this group at