For mySQL db\'s
If you are contemplating moving your Flotsam Groups to JOpenSim, you will want to follow these instructions for moving the information.
1) Back up all of your databases. I cannot stress this enough. If you have a backup, we can recover.
2) Use the following sql code to rename the tables within the Flotsam Groups db.
You can run the query from the prompt, or copy and paste it to your phpmyadmin query box on the osgroups db.
# be sure to make a backup before running this sql
#
# of course you need to change \"jos_\" if your joomla prefix is different
DROP TABLE IF EXISTS `jos_opensim_group`;
DROP TABLE IF EXISTS `jos_opensim_groupactive`;
DROP TABLE IF EXISTS `jos_opensim_groupinvite`;
DROP TABLE IF EXISTS `jos_opensim_groupmembership`;
DROP TABLE IF EXISTS `jos_opensim_groupnotice`;
DROP TABLE IF EXISTS `jos_opensim_grouprole`;
DROP TABLE IF EXISTS `jos_opensim_grouprolemembership`;
ALTER TABLE osgroup RENAME AS jos_opensim_group;
ALTER TABLE osagent RENAME AS jos_opensim_groupactive;
ALTER TABLE osgroupinvite RENAME AS jos_opensim_groupinvite;
ALTER TABLE osgroupmembership RENAME AS jos_opensim_groupmembership;
ALTER TABLE osgroupnotice RENAME AS jos_opensim_groupnotice;
ALTER TABLE osgrouprolemembership RENAME AS jos_opensim_grouprolemembership;
ALTER TABLE osrole RENAME AS jos_opensim_grouprole;
3) Export your altered Flotsam tables to file. This can be easily done with phpmyadmin if you are not skilled at the mysql prompt. Select the Flotsam osgroups db, click export at the top of phpmyadmin, make sure you export to sql, click go.
This will popup the file, either save it or open it. If you have your groups within the opensim db, be sure to select just the needed table rows and information.
4) Run the new sql file on the Joomla database. This is fairly simple with phpmyadmin as well if you don\'t want to run the query from the prompt. Just open the file, copy the query, select your Joomla database, and copy that code into a new query by selecting the query tab at the top of phpmyadmin. Once ran, you will be moving all of your groups and group information into the Joomla database.
After successfully renaming, copying, and moving, be sure to:
5) Change the OpenSim.ini to reflect your module under
[GROUPS]
GroupsServerURI = http://yourdomain/joomla/components/com_opensim/interface.php
6) Restart your OpenSim services, login, and test.
That should do it, if you have any issues, just post here and we will help.
