Hi all<div><br></div><div>I was trying to move a database copy a relstorage zodb and having some issues. The original zodb is mounted using a mount point /original_path If I restore the backup of the database and mount it using exactly the same mount point /original_path in the destination zope, all goes right. But what I want is to replicate the original database N times, so need to have /destination_pathN in the mount point. When I do that, the database seems empty (no object is shown in the mounted point). </div>
<div><br></div><div>Is there any way to fix this updating registers in SQL ? I know a way to solve it might be to export and import ZEXP, but the database is very big and I'm trying to avoid it I've tried these 2 queries but no effect obtained, these fields seems just informative:</div>
<div><br></div><div><meta http-equiv="content-type" content="text/html; charset=utf-8"><span class="Apple-style-span" style="font-family: Verdana; font-size: 13px; "><div style="margin-top: 0px; margin-bottom: 0px; ">update transaction set description=replace(description::text, 'helpdesk_src', 'redesistemas')::bytea;</div>
<div style="margin-top: 0px; margin-bottom: 0px; ">update transaction set username=replace(username::text, 'helpdesk_src', 'redesistemas')::bytea;</div></span><div><br></div><div>Where is stored the information about parent -> children objects ? Is the prev_tid field of object_state table ?</div>
<div><br></div><div>Thanks in advance<br>-- <br>Santi Camps <br>KMKey hacker (<a href="http://www.kmkey.com">http://www.kmkey.com</a>)<br>Earcon S.L. (<a href="http://www.earcon.com">http://www.earcon.com</a>)<br><br><br>
</div></div>