Upgrading
From OpenSimulator
m (Removed 'Template:' prefix from template includings and/or changed external-link into internal-link) |
m (Robot: Cosmetic changes) |
||
| Line 5: | Line 5: | ||
== Migrating between versions of OpenSim without changing database backends == | == Migrating between versions of OpenSim without changing database backends == | ||
| − | '''Unfortunately, this upgrading information is considerably out of date. | + | '''Unfortunately, this upgrading information is considerably out of date. We recommend that you do not attempt to copy over config files from previous versions of OpenSimulator but instead use the new files and make the changes by hand. However, it is possible to use previous version databases with new versions of OpenSim - on startup the data will automatically be migrated to the new formats (so it's best to make a database backup first in case this process goes wrong!).''' |
Upgrading OpenSim so that your data stays intact is not too difficult. If you’re using MySQL or MSSQL as a backend database with standalone OpenSim then all you should have to do is copy over your bin/Regions xml files (and maybe your OpenSim.ini if you don’t want to re-enter your settings manually) to the new OpenSim version and start it. | Upgrading OpenSim so that your data stays intact is not too difficult. If you’re using MySQL or MSSQL as a backend database with standalone OpenSim then all you should have to do is copy over your bin/Regions xml files (and maybe your OpenSim.ini if you don’t want to re-enter your settings manually) to the new OpenSim version and start it. | ||
| Line 17: | Line 17: | ||
Using sqlite (the default on disk database) is just a little more complicated. As well as copying bin/Regions and possibly OpenSim.ini, you also need to copy all the db files (AssetStorage.db, inventorystore.db, OpenSim.db and userprofile.db) to your new installation. | Using sqlite (the default on disk database) is just a little more complicated. As well as copying bin/Regions and possibly OpenSim.ini, you also need to copy all the db files (AssetStorage.db, inventorystore.db, OpenSim.db and userprofile.db) to your new installation. | ||
| − | This process should always work between the last numbered versions (e.g. going from 0.5.9 to 0.6.0). | + | This process should always work between the last numbered versions (e.g. going from 0.5.9 to 0.6.0). It may also work for older versions (e.g. 0.5.8 to 0.6.0) though this is not guaranteed. |
SEE Discussion at [[Talk:Upgrading]] for examples of How-To Back Up & Restore your system PRIOR to ANY Migration or Upgrade! | SEE Discussion at [[Talk:Upgrading]] for examples of How-To Back Up & Restore your system PRIOR to ANY Migration or Upgrade! | ||
| Line 67: | Line 67: | ||
== Migrating databases == | == Migrating databases == | ||
| − | Since SQLite is our default database, there often comes a time when people outgrow it and want to move on to another database backend (usually MySQL). | + | Since SQLite is our default database, there often comes a time when people outgrow it and want to move on to another database backend (usually MySQL). There is a script on the forge at [http://forge.opensimulator.org/gf/project/sqlite2mysql/] which should be able to do the conversion. If it's out of date then just give the author/s a nudge (or patch it!) |
| − | An alternative method is to change to each region (change-region) before backing up their contents to a separate OpenSim Region Archive (OAR) for each region. | + | An alternative method is to change to each region (change-region) before backing up their contents to a separate OpenSim Region Archive (OAR) for each region. Then change the database backend and then reload the OARs in each region separately. The disadvantage of this is that it's a little laborious if you have many regions. |
You can use the "command-script" feature of OpenSim.exe to semi-automate this. E.g., create a file in your "bin" directory, called something like "dobackup", which contains the necessary commands, for example: | You can use the "command-script" feature of OpenSim.exe to semi-automate this. E.g., create a file in your "bin" directory, called something like "dobackup", which contains the necessary commands, for example: | ||
Revision as of 20:17, 3 March 2012
Migrating between versions of OpenSim without changing database backends
Unfortunately, this upgrading information is considerably out of date. We recommend that you do not attempt to copy over config files from previous versions of OpenSimulator but instead use the new files and make the changes by hand. However, it is possible to use previous version databases with new versions of OpenSim - on startup the data will automatically be migrated to the new formats (so it's best to make a database backup first in case this process goes wrong!).
Upgrading OpenSim so that your data stays intact is not too difficult. If you’re using MySQL or MSSQL as a backend database with standalone OpenSim then all you should have to do is copy over your bin/Regions xml files (and maybe your OpenSim.ini if you don’t want to re-enter your settings manually) to the new OpenSim version and start it.
If you're using grid mode then you will also need to copy the 5 xml files in the bin directory that govern the configuration of the UGAIM servers.
Note that estate_settings.xml if present is used for default values for estates, but the saved setttings themselves are in the data base "estate_settings" tables (since r5525).
OpenSim contains code to automatically migrate all your data to conform to the newest formats. However, we would always suggest backing up your database beforehand in case something goes wrong during the conversion (e.g. you have a power cut).
Using sqlite (the default on disk database) is just a little more complicated. As well as copying bin/Regions and possibly OpenSim.ini, you also need to copy all the db files (AssetStorage.db, inventorystore.db, OpenSim.db and userprofile.db) to your new installation.
This process should always work between the last numbered versions (e.g. going from 0.5.9 to 0.6.0). It may also work for older versions (e.g. 0.5.8 to 0.6.0) though this is not guaranteed.
SEE Discussion at Talk:Upgrading for examples of How-To Back Up & Restore your system PRIOR to ANY Migration or Upgrade!
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 - All *.db files - The opensim.ini file - The \bin\regions XML files - The \bin\config-include INI files - estate_settings.xml (if it has been amended) 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 - The opensim.ini file - The \bin\regions XML files - The \bin\config-include INI files - estate_settings.xml (if it has been amended) 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 - The opensim.ini file - The \bin\regions XML files - The 5 XML config files - The \bin\config-include INI files - estate_settings.xml (if it has been amended) 4. Launch services in the following order: UGAIM + R where "R" designates the region server (Opensim)
Migrating databases
Since SQLite is our default database, there often comes a time when people outgrow it and want to move on to another database backend (usually MySQL). There is a script on the forge at [1] which should be able to do the conversion. If it's out of date then just give the author/s a nudge (or patch it!)
An alternative method is to change to each region (change-region) before backing up their contents to a separate OpenSim Region Archive (OAR) for each region. Then change the database backend and then reload the OARs in each region separately. The disadvantage of this is that it's a little laborious if you have many regions.
You can use the "command-script" feature of OpenSim.exe to semi-automate this. E.g., create a file in your "bin" directory, called something like "dobackup", which contains the necessary commands, for example:
change-region My Island 1 save-oar MI1 change-region My Island 2 save-oar MI2 change-region Another Region save-oar AR change-region root
This can be run from OpenSim.exe by typing "command-script" followed by the name you gave the script (eg "dobackup"). Note that this will overwrite the previous backup of the same name.
Note that using a save and reload via the OAR mechanism would not normally migrate your avatar inventories (you would need to rez everything out to the region, convert the data base, and then derez them again to your inventory).
