[Opensim-users] Database cleanup

[LaeMing]

Hmmm. When I was in the DB manually editing all my regions' ground textures 
and so (36 region megaregion, this was far quicker than doing it in-sim), I 
noticed a lot of old regiondata from earlier iterations of my OpenSim 
experiments hanging about too. I was able to hand-delete all the unwanted 
regioninfo from the mySql tools, but the tools didn't want to let me enter 
edit mode for the binary blobs of region heightmaps, so I couldn't work out 
how to hand-delete those.

I imagine, like Karen, there is also a lot of dangling cruft built up in my 
inventory too. Since I am the only user for now, would it be fair to say 
anything in world or in my current inventory has been 'touched' last login, 
and assuming mySql does (or can) flag touch dates for entries, could I just 
find the method of deleting all entries untouched since my last login (after a 
full backup of course)?

Lae


On Tuesday December 22 2009 09:52:22 Karen Palen wrote:
> My OpenSim database now tops 1Gb with only a single region!
> 
> Looking at the database with MySql tools shows that there is a whole lot of
>  stuff that I have tried and discarded still in the database and that it
>  does not seem to be flagged for removal.
> 
> Is there some OpenSim database maintenance tool that I haven't found yet?
> 
> How DO people like OSGrid keep the database to a manageable size?
> 
> Karen
> 
> 
> 
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>