[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Catastrophic database recovery with db log files

From: Max Bowsher <maxb_at_ukf.net>
Date: 2004-03-23 17:05:18 CET

Ben Collins-Sussman wrote:
> On Tue, 2004-03-23 at 09:12, Matthias Saou wrote:
>
>> I don't have a backup of the very latest content, but I do have all the
>> logfiles created ever since the repository was started, so I'd be really
>> interested in being able to "replay" all of those. Can anyone point me to
>> an explanation on how to do it?
>
> 1. Copy your whole repository, play with the copy.
>
> 2. Delete the 7 tables: nodes, revisions, representations, changes,
> strings, transactions, uuids

Ben: Why not copies as well?

> 3. run 'db_recover -c -h /path/to/repos/db'
>
> (The -c is for 'catastrophic' recovery.)

Matthias:
If the logs are intact, the above should work.
But, if it doesn't, it should be possible to write some code to rebuild the
copies table from data in the other tables. If it turns out to be necessary,
I'll have a go.

Max.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Tue Mar 23 17:06:33 2004

This is an archived mail posted to the Subversion Users mailing list.