Meanwhile i have copied the databases from two servers (my home sim and the hyperbase) into one on the new server. This means i have all the user accounts with their inventories, all the regions and prims.
It works, but i have to fix some minor issues: the "ServiceURLs" field in the UserAccounts table contains the full qualified domain names, so if i use different names (as i do while testing) ppl cant log in.
And now i have two Neo Cortex users with different UUID's, one being the creator and owner of the hyperbase, the other owner of my home sim. Of course with two different inventories ^^
Are there any mysql experts with some ready made statements like "update ownership of a whole region" or "merge this part of my avatar1 inventory to that part of my avatar2"?
Well, who said this would be a smooth ride? ;-)
At least my experiments so far show everything is running much faster on the new server.
still tinkering,
Neo
Hi Neo,
ReplyDeleteownership of the region can be made with a simple oar save and reload. Save the old region as an oar, then change the owner (in the land table, OwnerUUID) and load the old oar again. All objects will now show the new owner as both creator and owner.
Merging inventory items is a bit tricky, as it can take some time. Basically, it's a search & replace in the inventoryitems table, avatarID column, where you need to replace the UUID of one of the Neo Cortexes (Cortices?) with the one of the other.
Of course, backups first. Never know what might happen.
Good luck.
V