[Opensim-users] Any mySQL query to compare two sims in same db?

[Karen Palen]

My first thought is to do a sparate database backup of each database
using the MySQL database backup and do a file compare ("diff" on Linux,
sorry I forget the Win equivalent).

BTW You should be doing regular backups of the database anyway, there
have been problems in the past which caused the db structure to loose
its mind or just lose items (almost as bad).

Alternatively (and somewhat more sophisticated) would be to do an OAR
file of each build and diff the tow OAR files. If there are differences
this would be easier to analyze since the OARs are in XML format.

Karen
On 05/31/2011 05:21 PM, missyfitz wrote:
> Is there an easy way to compare what should be two identical copies of the
> same sim build, both in the same mySQL db?
> 
> I'm having extremely annoying persistence problems with my diva
> installation. Any time I shutdown and restart the server, random prims or
> linksets will either have their texture repeats and orientations reverted,
> the entire prim or linkset will be moved, or the entire prim or linkset will
> just be gone.. 
> 
> Right now I have a work copy of the sim, from which I saved an OAR file..
> loaded the OAR on the second sim, compared primcounts and they were
> identical.. shutdown the server.. restart the server... and the work copy of
> the sim now has 5 fewer prims than the one onto which the OAR was restored.
> 
> So its there any way to query/compare two sims in the database by sim UUID
> and just get a readout of which prims are missing from one or the other or
> both?
> 
> --
> View this message in context: http://opensim-users.2152040.n2.nabble.com/Any-mySQL-query-to-compare-two-sims-in-same-db-tp6425184p6425184.html
> Sent from the opensim-users mailing list archive at Nabble.com.
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users