PLEASE NOTE: This is experimental and expects some technical knowledge. If you
aren't comfortable with using and modifying scripts, then this is not for you.
Furthermore, it probably will flatten your land, delete your scripts and color
all your prims in green-red stripes. Please backup your data before you try
this.

Usage:
======

You can do two things:
- Migrate one region-server (already in grid mode) from SQLite to MySQL.
- Convert a standalone setting with SQLite to a (local) grid with MySQL.


Migration of one region-server
------------------------------

Copy your old opensim/bin folder into a new folder. Change the DB settings in
the OpenSim.ini to MySQL. Remember DB-name, user and password.

In MySQL, create a fresh database with the DB-name you've used in OpenSim.ini.
Create the user with the password, and grant the necessary rights on the DB.

Put the values for user,password and database into db.pl.

Start the region-server. If everything will be ok, it will start, and create
all the tables in the database. Shutdown the region-server again.

Execute the following command:
  transferRegion <path_to_your_OpenSim.db>

Start your region and log in.


Migration from standalone to gridmode
-------------------------------------

Copy your old opensim/bin folder into a new folder. Change the DB settings in
the OpenSim.ini to MySQL. Remember DB-name, user and password.
Change the *_Config.xml files, too and make sure you have gridmode = true and
asset_database = "grid" in your OpenSim.ini.

In MySQL, create a fresh database with the DB-name you've used in OpenSim.ini.
Create the user with the password, too, and grant the necessary rights on the
DB.

If you have used a different database for your gridservers (UGAIM), you have to
create this database, too.

Put the values for user,password and databases into db.pl.


Start your grid. If everything will be ok, it will start, and create all the
tables in the database. Shutdown the grid again.

Execute the following command:
  transferUser <path_to_your_userprofile.db>
  transferAssets <path_to_your_assetStorage.db>
  transferInventory <path_to_your_inventoryStore.db>
  transferRegion <path_to_your_OpenSim.db>

Start your grid and log in.