Maxx Monde

Hey there, finally got a guide to installing MySQL server and configuring it for use with OpenSim posted.

OpenSim - MySQL Install Guide « OpenSim Easy User Guide

Enjoy!

Macphisto Angelus

Maxx, as always... Thank You for making the most easy to follow set up instructions for a OpenSim noob.

Couple questions if you have time:

I am trying to set up MySQL since Joshua indicated in another thread that it is easier to back up to and you indicate the performance is better. Soooo with that said, being the noob I am I went to my favorite source of showing me how to make stuff work.. your blog.

I would respond there but figured it would be easier for you here. If you would rather use the blog for this.. just say so.

I followed the bouncing ball.. things were coming together nicely. Then.. as John says:

I am on XP. But a solution was offered by Mark:

Yay.. but. Noobness set in. I tried to figure out what he meant here. I was able to "CREATE DATABASE opensim;" This is where I need a "for dummies" explaination.

Now, after getting this working I am wondering..
1. Do I do backups or do the backups happen in real time as things are created right to the Mysql database?

2. If I have another situation where my OpenSim locks up with errors and I have to begin again, how do I get the assets from Mysql to OpenSim?

Don't you just love pesky noobs?

__________________
If life is just a joke, why aren't we laughing?

Joshua Nightshade

Okay so I kindof disagree with your instructions upon reading them further.

At setup instead of "Typical" choose Custom. You can leave the options as is, but it gives you a different setup menu.

When you get to the part about setting up the server, DON'T choose standard actually.

Pick detailed.

First option should be developer machine.

Next should be Multifunctional Database.

Leave the InnoDB Tablespace settings as is and hit next.

Manual settings for the next window, concurrent connections should be 15.

Enable TCP/IP Networking and UNCHECK Enable Strict Mode.

Best support for multilingualism.

Install as a service, uncheck the Bin directory one.

Then hit execute.

Instead of Toad, at least on windows, I suggest people use the MySQL GUI tools here:

MySQL :: MySQL GUI Tools Downloads

Administrator and Query Browser will be much easier.

Once you've got those installed fire up Query Browser and right click in the "folder" listing and hit create schema, name it opensim or whatever.

Use the same instructions for changing the ini file.

Joshua Nightshade

You would have to run backups yourself. MySQL Administrator lets you backup and restore, and there's an option there for scheduled backups. Toad might as well but I've never used it so I know noffink.

To explain the database it's kindof like thinking of OpenSim and directories. Before you setup MySQL, OpenSim stored everything in one limited directory by default. Now that you're in MySQL you're storing everything into another directory. Updating OpenSim doesn't really have much effect most of the time on the database (there are some bugs but generally speaking no) so if OpenSim won't open that doesn't affect your database.

However one of the developers, JustinCC, recently released a very fucking kickass tool that lets you archive entire sim states. All the scripts, textures, prims, etc that exist in-sim.

To use that go to the console and type save-oar (if you're running multiple regions type change-region "Region Name" first to archive the correct one) and it will save it to a default name in the bin directory. Load-oar (again, change-region first) will restore the same default file. Obviously putting a name after either of those commands will allow you to save your own filename.

This offloads everything into a single file for easy transport and I highly recommend it. Unfortunately it won't copy inventory and so on but anything rez'd in world can easily be copied.

Macphisto Angelus

Oh, Joshua...once again you are my hero!

I am going to go and try this out now. I will use the tool you mention and am extremely stoked about that tool JustinCC has made.

On importing the sim state back on a fresh install, what would be the command?

Joshua Nightshade

Same thing, load-oar.

Joshua Nightshade

Obviously you want to make sure the archived files are in the bin directory first though. The default name is scene_oar.tar.gz

Macphisto Angelus

Awesome!! Thanks again.

Joshua Nightshade

Tease!

Macphisto Angelus

Now.. now. Nothing wrong with a peck on the cheek. It's not like I used a BJ emoticon.