[Opensim-users] Asset records for deleted inventory prims and prim groups

[Jeff Kelley]

At 1:08 AM +0200 3/1/14, George Anastassakis wrote:

>Still, I was (and am) mostly troubled by the notion of constant 
>expansion that is due to really useless assets, and my original 
>concern was to understand if there indeed is such a thing as a 
>really useless asset. But I get your point.

Every grid running for a long time had faced the problem. Cleaning 
the assets has been discussed here and appears to be a complex task, 
involving parsing serialized objects, wearables, notecards and 
scripts. Melanie outlined the process here:

https://lists.berlios.de/pipermail/opensim-users/2013-April/012038.html

Although nobody proved that was theoretically impossible, nobody came 
with a practical solution. Yet.


>So, I guess that what is implied here is that *regularly* backing-up 
>the Robust db by dumping sql is out of the question. What would you 
>suggest as an alternative?

Backing up by sqldump is not out of the question, you may keep a 
rolling set of snapshots for last day, week, mont, quarter... 
depending on you storage capacity.


-- Jeff