Quote:
Originally Posted by Macphisto Angelus  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? |
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.