Actually I was hoping to find some neat script somewhere that just fixed the problem forever.
Well I can dream at least ... They say that a true programmer is someone who spends a week automating a 20 minute problem and feels good about the result :-) I suspect that I will have to end up with multiple databases though. An "experimental" one and a "build things" one. Probably isolated in dedicated virtual machines like I do with software tryouts. It is amazing how many Windows problems go away when an app is the ONLY one installed on a VM for example. That strategy has also served me well in isolating trojans and "backdoors" in commercial software. So far no major packages (like the infamous Turbo-Tax DRM that permanently crippled your machine a few years ago), but I use and beta test a wide range of stuff and it amazing what you find sometimes. Karen --- On Tue, 12/22/09, William Magee <[email protected]> wrote: > From: William Magee <[email protected]> > Subject: Re: [Opensim-users] Database cleanup > To: [email protected] > Date: Tuesday, December 22, 2009, 7:50 PM > 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 <[email protected]> > 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 <[email protected]> > wrote: > > > >> From: William Magee <[email protected]> > >> Subject: Re: [Opensim-users] Database cleanup > >> To: [email protected] > >> 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 > <[email protected]> > >> 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 <[email protected]> > >> wrote: > >> > > >> >> From: LaeMing <[email protected]> > >> >> Subject: Re: [Opensim-users] Database > cleanup > >> >> To: [email protected] > >> >> 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 > >> >> > [email protected] > >> >> > https://lists.berlios.de/mailman/listinfo/opensim-users > >> >> > > >> >> > >> >> > _______________________________________________ > >> >> Opensim-users mailing list > >> >> [email protected] > >> >> https://lists.berlios.de/mailman/listinfo/opensim-users > >> >> > >> > > >> > > >> > > >> > > _______________________________________________ > >> > Opensim-users mailing list > >> > [email protected] > >> > 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 > >> [email protected] > >> https://lists.berlios.de/mailman/listinfo/opensim-users > >> > > > > > > > > _______________________________________________ > > Opensim-users mailing list > > [email protected] > > 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 > [email protected] > https://lists.berlios.de/mailman/listinfo/opensim-users > _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
