[Opensim-users] Database cleanup

[Karen Palen]

I use the same set-up (MySql Admin/Ubuntu). Works nicely, but I have to believe that the job would be cleaner and safer with the usage and cross reference knowledge in the OpenSim app!

I am very cautious about fiddling witht he contents of databases directly there are too many subtle things that can get screwed up!

Karen
--- On Mon, 12/21/09, William Magee <billmagee at gmail.com> wrote:

> From: William Magee <billmagee at gmail.com>
> Subject: Re: [Opensim-users] Database cleanup
> To: opensim-users at lists.berlios.de
> Date: Monday, December 21, 2009, 11:32 PM
> I use phpmyadmin to fiddle around in
> MySQL. It provides a gui for your
> databases. I use Ubuntu; not sure what you might use with
> some other
> operating system, but I am sure there are options.
> 
> On Tue, Dec 22, 2009 at 2:07 PM, Karen Palen <karen_palen at yahoo.com>
> wrote:
> > That is one way to solve the problem, although I don't
> know MySQL well enough to figure out how!
> >
> > I was actually hoping that OpenSim had some built in
> utility that would do this in a more intelligent way though.
> Essentially the knowledge about what is deleted or not is
> fairly high level information within OpenSim itself. A
> "touch" would at best be an emulation of this.
> >
> > Ideally this would run regularly and keep down the
> "cruft" build-up.
> >
> > Next best would be to dump each region to an OAR file,
> each avatar's inventory to an IAR file then build a new
> database from that! It would work, but could take several
> days of effort to make sure that it was done right. My next
> thought is to use Second Inventory to do the same thing, but
> that could be even slower!
> >
> > Karen
> >
> > --- On Mon, 12/21/09, LaeMing <laeming at exemail.com.au>
> wrote:
> >
> >> From: LaeMing <laeming at exemail.com.au>
> >> Subject: Re: [Opensim-users] Database cleanup
> >> To: opensim-users at lists.berlios.de
> >> Date: Monday, December 21, 2009, 7:34 PM
> >> 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
> >> >
> >>
> >> _______________________________________________
> >> Opensim-users mailing list
> >> Opensim-users at lists.berlios.de
> >> https://lists.berlios.de/mailman/listinfo/opensim-users
> >>
> >
> >
> >
> > _______________________________________________
> > Opensim-users mailing list
> > Opensim-users at lists.berlios.de
> > https://lists.berlios.de/mailman/listinfo/opensim-users
> >
> 
> 
> 
> -- 
> William Magee, Ph.D.
> XVIth Congress of the IABS, Planning Committee Chair
> Dharma Drum Buddhist College
> Jinshan, Taiwan
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>