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
