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

[Justin Clark-Casey]

I don't think these approaches will work because the prims will end up with different ids.

You could still compare positions with something like

select name, PositionX, PositionY, PositionZ, GroupPositionX, GroupPositionY, GroupPositionZ

On 01/06/11 06:54, Karen Palen wrote:
> 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
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


-- 
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc