Showing posts with label MySQL setup. Show all posts
Showing posts with label MySQL setup. Show all posts

Friday, December 30, 2011

Migrating your Sim to MySQL

Ok, you followed the steps in the previous post to setup a sim, and all is up and running. If you don't plan to running more than 1 region, or have no urge to stuff 45000 prims on it, the SQL lite version OSG comes with will work & perform just fine. Apart from having better performance, running MySQL has a some other slight  advantages. Whenever you need to upgrade your OSG server software, you will have to make an OAR backup of your sim, and import that in the new installation.

With MySQL you have all your stuff stored in a database sever which runs seperate from OSG. This means that you only need to point the new installation to the database, and it will just load all, without you needing to import or export anything. Below the page break you will find a step by step instruction on how to install mySQL, and what to change in the gridcommon.ini file to point OSG towards the correct database.

As its still wise to make a backup OAR file every once and a while, you can read up on how to do that in the Wiki. Its well documented. Hence we will skip this part in the installation below. You DO want to read that wikipage. Many people that just follow shortcut guides and have no interest or clue of what their actually doing, will  run stuck in the long run. Don't let the technical terminology scare you. And mind there are no perfect guides. If you get the bigger picture, the small stuff will fall into place by itself.