Change font size
It is currently Wed Mar 22, 2017 5:08 pm

Forum rules


As always, be well-behaved, respectful of others, and mind the topic - off topic posts may be deleted or moved to other forums.



Post a new topicPost a reply Page 1 of 1   [ 7 posts ]
Author Message
 Post subject: Automating Region Backups
PostPosted: Sun Nov 27, 2016 3:35 pm 

Joined: Tue Oct 18, 2016 8:48 pm
Posts: 6
I currently run a var region on a UBUNTU server and use a script that backs up my opensim mysql DB nightly.

I am now in the process of adding one or two new regions. I'd love to back up individual OAR files for each of the regions so that I won't have to restore my whole world if a problem develops on one of the regions. Are there any recommended ways of doing this in an automated fashion?


Top
 Profile  
 
 Post subject: Re: Automating Region Backups
PostPosted: Sun Nov 27, 2016 3:58 pm 
OSG Elite
User avatar

Joined: Thu Aug 06, 2009 7:07 am
Posts: 333
Location: B.C. Canada
I don't remember where I got this from, maybe in the forums someplace, but I have this at the end of my opensim.ini file to create an OAR every night.

[AutoBackupModule]
;; default is module is disabled at the top level
AutoBackupModuleEnabled = true
AutoBackup = true
AutoBackupInterval = 1320
AutoBackupNaming = "overwrite"
AutoBackupDir = "E:\OSGrid\autobackups\"


Top
 Profile  
 
 Post subject: Re: Automating Region Backups
PostPosted: Sun Nov 27, 2016 4:18 pm 

Joined: Tue Oct 18, 2016 8:48 pm
Posts: 6
Thank you for the VERY speedy reply!
What goes into your autobackups directory? a separate oar file for each region?
I don't suppose you know where I might find more info on the AutoBackupModule section? I'd be interested what the AutoBackupNaming options are. i.e. can I keep more than just last night's copy.


Top
 Profile  
 
 Post subject: Re: Automating Region Backups
PostPosted: Sun Nov 27, 2016 4:23 pm 

Joined: Tue Oct 18, 2016 8:48 pm
Posts: 6
Just found some documentation here: http://opensimulator.org/wiki/Feature_P ... AutoBackup


Top
 Profile  
 
 Post subject: Re: Automating Region Backups
PostPosted: Mon Nov 28, 2016 12:05 pm 
Furious Typer

Joined: Tue Jan 31, 2012 12:40 pm
Posts: 72
If you are using mysql you are really better off backing up the tables. It is incredibly fast, a lot easier to automate and uses a fraction of the space that an oar file uses. I use MySQL Workbench, a free windows app you can get from Oracle.

You don't even need to run the backup on the same machine that your opensim is running on: I run on a Ubuntu cloud server and back up to a local windows pc. A back-up of a 8x8 var with about 20K prims rezzed takes 5 minutes and uses around 13 mb.


Top
 Profile  
 
 Post subject: Re: Automating Region Backups
PostPosted: Mon Nov 28, 2016 5:07 pm 

Joined: Tue Oct 18, 2016 8:48 pm
Posts: 6
Thanks, Furious. I do run a nightly mysql backup that retains the last 10 days. My problem in a multi region environment is that I can't (at least I don't know how) to go back to yesterday on a region that has crashed without impacting the other regions. Is there a way of restoring the mysql database for specific regions?

BTW, I haven't had a chance to try the AutoBackup feature as yet because of unrelated technical issues, but I hope to be able to do so by next weekend.

Thank you for all the responses. What a great forum!


Top
 Profile  
 
 Post subject: Re: Automating Region Backups
PostPosted: Tue Dec 13, 2016 12:01 pm 

Joined: Tue Oct 18, 2016 8:48 pm
Posts: 6
The Auto region backup works beautifully. I now have SQL and oar backups = belt and suspenders!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post a new topicPost a reply Page 1 of 1   [ 7 posts ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
610nm Style by Daniel St. Jules of Gamexe.net