SLUniverse Forums - View Single Post - OpenSim - MySQL Install Guide
View Single Post
Old 07-31-2008, 06:49 PM   #2 (permalink)
Macphisto Angelus
Is a bastage!
 
Macphisto Angelus's Avatar
It puts the lotion on it's skin!!
 
Join Date: May 2008
Location: Cali
Posts: 3,066
My Mood:
SL Join Date: 10-21-2004
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:

Quote:
I could not get it to work. installed it fine no errors service started. Opened Toad and the Object Palette is grayed out I can’t click on it. When I open Toad it opens a connection screen there is my sql listed but it says it should display properties of the connection nothing there.
I removed the programs and reinstalled again same problem
any ideas. I am running Vista could that be the problem?
I am on XP. But a solution was offered by Mark:

Quote:
I had the same problem as John, brought up the Mysql DOS window and entered the command: “CREATE DATABASE opensim;”
and then reopened toad and set the connection window up to connect to opensim as root@localhost and gave it my password and told it to connect automatically then saved it. Now the Object Pallet is working.
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.

Quote:
and then reopened toad and set the connection window up to connect to opensim as root@localhost and gave it my password and told it to connect automatically then saved it.
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?



Macphisto Angelus is offline   Reply With Quote