Monday 15 December 2008
Diary: 15th December 2009
21:18 | 
Posted by
Rock
Database Woes
I logged into my opensim grid on Saturday, and was dismayed to find lots of my palace build missing. I tried restarting the opensim server software, and then the server platform itself, but the missing prims were definitely gone. 'No problem', I bet you're thinking, 'Rock makes regular backups, doesn't he?' Ermm, well, I used to, but I have been so busy of late, the last one I had was 20 days ago, and we have done lots of building and creating shoes and clothing since then. It was time to think of a recovery strategy.
All of the prims that were missing were in the backup. However, if I loaded the backup I would lose all the builds and objects created during the last 20 days. So, what to do?
I decided to take into inventory all the builds and objects created during the last 20 days, then go to a void region and rezz them all there. I then did a save-oar on that region. (Unfortunately, drag-selecting and Taking does not work in opensim yet as it does in SL. In SL you get a single, coalesced object. In opensim you get all the objects individually, so every one would have to be repositioned).
I then wondered if I needed to delete my existing opensim database, then create a new, empty one, and then populate the new one with the backup sql file. As it would be no loss, I decided to see what would happen if I restored the backup over the existing database. Would it clear then write; would it overwrite some, but not all; or would it append? The answer was that it appeared to clear then write.
I then logged in to find all the missing prims back. I now needed to get back the builds and objects created during the last 20 days, and so I did a load-oar into the void region. On going there I saw all the objects where I had left them, and I took them into inventory. Then it was back to the main regions to put them back where they belonged.
I am now looking at scripts that will do a daily unattended backup for me.
Clearing the Clouds
Do you like the white cloud that represents avatars nowadays, when their shape or clothing has not fully downloaded yet, or do you prefer to see the avatar, even if they are Ruthed and/or grey?
If you prefer to see the avatar, rather than the cloud, you can. Here's how:
In the viewer go to the Advanced part of the menu (Control-Alt-D will bring it up if it is not already there). Then go to Debug Settings, and in the text box, type: RenderUnloadedAvatar, and in the lower drop-down box select TRUE, then close Debug Settings.
That's it.
I logged into my opensim grid on Saturday, and was dismayed to find lots of my palace build missing. I tried restarting the opensim server software, and then the server platform itself, but the missing prims were definitely gone. 'No problem', I bet you're thinking, 'Rock makes regular backups, doesn't he?' Ermm, well, I used to, but I have been so busy of late, the last one I had was 20 days ago, and we have done lots of building and creating shoes and clothing since then. It was time to think of a recovery strategy.
All of the prims that were missing were in the backup. However, if I loaded the backup I would lose all the builds and objects created during the last 20 days. So, what to do?
I decided to take into inventory all the builds and objects created during the last 20 days, then go to a void region and rezz them all there. I then did a save-oar on that region. (Unfortunately, drag-selecting and Taking does not work in opensim yet as it does in SL. In SL you get a single, coalesced object. In opensim you get all the objects individually, so every one would have to be repositioned).
I then wondered if I needed to delete my existing opensim database, then create a new, empty one, and then populate the new one with the backup sql file. As it would be no loss, I decided to see what would happen if I restored the backup over the existing database. Would it clear then write; would it overwrite some, but not all; or would it append? The answer was that it appeared to clear then write.
I then logged in to find all the missing prims back. I now needed to get back the builds and objects created during the last 20 days, and so I did a load-oar into the void region. On going there I saw all the objects where I had left them, and I took them into inventory. Then it was back to the main regions to put them back where they belonged.
I am now looking at scripts that will do a daily unattended backup for me.
Clearing the Clouds
Do you like the white cloud that represents avatars nowadays, when their shape or clothing has not fully downloaded yet, or do you prefer to see the avatar, even if they are Ruthed and/or grey?
If you prefer to see the avatar, rather than the cloud, you can. Here's how:
In the viewer go to the Advanced part of the menu (Control-Alt-D will bring it up if it is not already there). Then go to Debug Settings, and in the text box, type: RenderUnloadedAvatar, and in the lower drop-down box select TRUE, then close Debug Settings.
That's it.