No subject

Sat Apr 19 01:53:27 UTC 2014

strategy?  In particular, what happens if someone changes an SQLite
or MySQL schema from one revision to the next? I tried METHOD 2
last night when going from r7320 to r7605, and it failed. Not sure why
yet...I ended up just creating new regions from scratch.

If someone can suggest a more efficient approach, that would
be great. Once it is down, we can put it in the wiki. It could go
under:

http://opensimulator.org/wiki/Configuration

Actually, just a couple of days ago I started a rough wiki page for this.

http://opensimulator.org/wiki/Upgrading

It has the standalone info but not really the grid stuff.  Also, your bulle=
t point format is much clearer.

METHOD 1: If Using SQLite in StandAlone Mode

1. Build the latest version from source (or download the binaries)
2. Put this new installation in a new folder
3. Copy the following files from the old \bin to the new \bin
   3a. All *.db files
   3b. The opensim.ini file
   3c. The \bin\regions XML files
4. Launch the new opensim.exe

METHOD 2: If Using MySQL in StandAlone Mode

1. Build the latest version from source (or download the binaries)
2. Put this new installation in a new folder
3. Copy the following files from the old \bin to the new \bin
   3a. The opensim.ini file
   3b. The \bin\regions XML files
4. Launch the new opensim.exe

METHOD 3: If Using MySQL in Grid Mode

1. Build the latest version from source (or download the binaries)
2. Put this new installation in a new folder
3. Copy the following files from the old \bin to the new \bin
   3a. The opensim.ini file
   3b. The \bin\regions XML files
   3c. The 5 XML config files
4. Launch services in the following order: UGAIM + R where
   "R" designates the region server (OpenSim)

--
justincc
Justin Clark-Casey
http://justincc.wordpress.com
_______________________________________________
Opensim-users mailing list
Opensim-users at lists.berlios.de
https://lists.berlios.de/mailman/listinfo/opensim-users

--_000_63FAD4F222230A4EA79DE9E8BE66473502E9382Cwinxbeus19excha_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Helvetica;
	panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
	{font-family:-webkit-sans-serif;
	panose-1:0 0 0 0 0 0 0 0 0 0;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:purple;
	text-decoration:underline;}
span.apple-style-span
	{mso-style-name:apple-style-span;}
span.EmailStyle18
	{mso-style-type:personal-reply;
	font-family:"Calibri","sans-serif";
	color:#1F497D;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:10.0pt;}
@page Section1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
	{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext=3D"edit">
  <o:idmap v:ext=3D"edit" data=3D"1" />
 </o:shapelayout></xml><![endif]-->
</head>

<body lang=3DEN-AU link=3Dblue vlink=3Dpurple style=3D'word-wrap: break-wor=
d;
-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'>

<div class=3DSection1>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>The problem with SQLite is that it’s very very slow by
comparison.<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>There’s a real noticeable difference between the speed=
 it takes
to perform operations, and that of say MySQL.<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>It’s also a little bit easier to corrupt – for i=
nstance you can’t
have two processes accessing the one sqlite DB at once.<o:p></o:p></span></=
p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'>Adam<o:p></o:p></span></p>

<p class=3DMsoNormal><span style=3D'font-size:11.0pt;font-family:"Calibri",=
"sans-serif";
color:#1F497D'><o:p> </o:p></span></p>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm =
4.0pt'>

<div>

<div style=3D'border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm =
0cm 0cm'>

<p class=3DMsoNormal><b><span lang=3DEN-US style=3D'font-size:10.0pt;font-f=
amily:
"Tahoma","sans-serif"'>From:</span></b><span lang=3DEN-US style=3D'font-siz=
e:10.0pt;
font-family:"Tahoma","sans-serif"'> opensim-users-bounces at lists.berlios.de
[mailto:opensim-users-bounces at lists.berlios.de] <b>On Behalf Of </b>Generic
Email<br>
<b>Sent:</b> Friday, 5 December 2008 8:10 AM<br>
<b>To:</b> opensim-users at lists.berlios.de<br>
<b>Subject:</b> Re: [Opensim-users] opensim migration strategy<o:p></o:p></=
span></p>

</div>

</div>

<p class=3DMsoNormal><o:p> </o:p></p>

<div>

<p class=3DMsoNormal>This is a bit of a soap box, so if your are easily off=
ended
or annoyed, just pass by, there is nothing to see here.<o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

I see in the OpenSim world the assertion that SQLite i=
s not
production worthy often. Most recently here:<o:p></o:p>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

<div>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><a href=3D"http://opensimulator.org/wiki/Upgrading">ht=
tp://opensimulator.org/wiki/Upgrading</a><o:p></o:p></p>

</blockquote>

</div>

<div>

SQLite (default - a lightweight
database that comes bundled with OpenSim and can be used without requiring =
any
extra configuration. It is mostly intended to get you up and running quickl=
y,
not for production use.)<o:p></o:p>

</div>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

<div>

<p class=3DMsoNormal><span class=3Dapple-style-span><span style=3D'font-siz=
e:10.0pt;
font-family:"-webkit-sans-serif","serif"'>I prefer to describe SQLite as:&n=
bsp;</span></span><o:p></o:p></p>

</div>

<div>

SQLite is a software library that
implements a self-contained, serverless, zero-configuration,
transactional SQL database engine. SQLite is the most widely
deployed SQL database engine in the world. The source code for SQLite =
is
in the public domain.<o:p></o:p>

</div>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

<div>

<p class=3DMsoNormal><span class=3Dapple-style-span><span style=3D'font-siz=
e:10.0pt;
font-family:"-webkit-sans-serif","serif"'>These companies believe SQLite is
production worthy/ready: </span></span><span class=3Dapple-style-span>=
<span
style=3D'font-size:9.0pt;font-family:"Helvetica","sans-serif"'><a
href=3D"http://www.sqlite.org/famous.html">http://www.sqlite.org/famous.htm=
l</a></span></span><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

<div>

<p class=3DMsoNormal>I am a huge fan of SQLite, and for what it does, I bel=
ieve
it does it very well.<o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

<div>

<p class=3DMsoNormal>Thanks for letting me get that out, and I hope I can
influence more of you to take a better look at SQLite.<o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><o:p> </o:p></p>

<div>

<div>

<p class=3DMsoNormal>On Dec 5, 2008, at 10:58 AM, Justin Clark-Casey wrote:=
<o:p></o:p></p>

</div>

<p class=3DMsoNormal><br>
<br>
<o:p></o:p></p>

<div>

<p class=3DMsoNormal>Paul Fishwick wrote:<br>
<br>
<o:p></o:p></p>

<p class=3DMsoNormal>From one version of opensim to the next, what is the
accepted migration<o:p></o:p></p>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

strategy?  In particular, what happens if someone
changes an SQLite<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

or MySQL schema from one revision to the next? I tried
METHOD 2<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

last night when going from r7320 to r7605, and it fail=
ed.
Not sure why<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>yet...I ended up just creating new regions from scratc=
h.<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>If someone can suggest a more efficient approach, that=
 would<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

be great. Once it is down, we can put it in the wiki. =
It
could go<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>under:<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><a href=3D"http://opensimulator.org/wiki/Configuration=
">http://opensimulator.org/wiki/Configuration</a><o:p></o:p></p>

</blockquote>

Actually, just a couple of days ago I started a rough wiki page for this.<b=
r>
 
<a href=3D"http://opensimulator.org/wiki/Upgrading">http://opensimulator.or=
g/wiki/Upgrading</a> 
 
It has the standalone info but not really the grid stuff.  Also, your
bullet point format is much clearer. 
 
 
<o:p></o:p>

<p class=3DMsoNormal><o:p> </o:p></p>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>METHOD 1: If Using SQLite in StandAlone Mode<o:p></o:p=
></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

1. Build the latest version from source (or download t=
he
binaries)<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>2. Put this new installation in a new folder<o:p></o:p=
></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

3. Copy the following files from the old \bin to the n=
ew \bin<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3a. All *.db files<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3b. The opensim.ini file<o:p></o:p><=
/p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3c. The \bin\regions XML files<o:p><=
/o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

4. Launch the new opensim.exe<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>METHOD 2: If Using MySQL in StandAlone Mode<o:p></o:p>=
</p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

1. Build the latest version from source (or download t=
he
binaries)<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>2. Put this new installation in a new folder<o:p></o:p=
></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

3. Copy the following files from the old \bin to the n=
ew
\bin<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3a. The opensim.ini file<o:p></o:p><=
/p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3b. The \bin\regions XML files<o:p><=
/o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

4. Launch the new opensim.exe<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>METHOD 3: If Using MySQL in Grid Mode<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

1. Build the latest version from source (or download t=
he
binaries)<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>2. Put this new installation in a new folder<o:p></o:p=
></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

3. Copy the following files from the old \bin to the n=
ew
\bin<o:p></o:p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3a. The opensim.ini file<o:p></o:p><=
/p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3b. The \bin\regions XML files<o:p><=
/o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   3c. The 5 XML config files<o:p></o:p=
></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>4. Launch services in the following order: UGAIM + R w=
here<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal>   "R" designates the region =
server
(OpenSim)<o:p></o:p></p>

</blockquote>

<blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt'>

<p class=3DMsoNormal><o:p> </o:p></p>

</blockquote>

<p class=3DMsoNormal><br>
<br>
-- <br>
justincc<br>
Justin Clark-Casey<br>
http://justincc.wordpress.com<br>
_______________________________________________<br>
Opensim-users mailing list<br>
Opensim-users at lists.berlios.de<br>
https://lists.berlios.de/mailman/listinfo/opensim-users<o:p></o:p></p>

</div>

</div>

<p class=3DMsoNormal><o:p> </o:p></p>

</div>

</div>

</div>

</body>

</html>

--_000_63FAD4F222230A4EA79DE9E8BE66473502E9382Cwinxbeus19excha_--