RE: Revision cleanup

[Michael Yin]

So, just to get specific,  I could delete the contents of the JOURNAL
table and change REVISION_ID in GLOBAL_REVISION to 0?

While making sure no one was connected to the DB.

-mike

> -----Original Message-----
> From: Guo Du [mailto:mrdu...@gmail.com]
> Sent: Monday, February 08, 2010 4:11 PM
> To: users@jackrabbit.apache.org
> Subject: Re: Revision cleanup
> 
> On Mon, Feb 8, 2010 at 8:26 PM, Michael Yin <m...@theladders.com>
> wrote:
> > I was thinking about exporting to XML then reimporting into a clean
> > repo, but there must be a better way than that.
> 
> Version history stored in separate table, I think you may simple run
> sql to delete all record in the version table after you stopped the
> repository instance.
> 
> Then delete the index before start the repository.
> 
> Never try this, take a safe backup before any action :)
> 
> -Guo