[Opensim-users] Database cleanup

[William Magee]

Oh, Karen sorry I did not see that it was you when I mentioned
phpmyadmin. Of course I know you are an Ubuntu user.

Have you considered making a copy and running database experiments
safely on a cloned sim?

Cheers,
Bill

On Wed, Dec 23, 2009 at 8:24 AM, Karen Palen <karen_palen at yahoo.com> wrote:
> 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
>>
>
>
>
> _______________________________________________
> 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