opensim Where Exactly Are Things Stored?

[Noodles]

So, the topic is the question. Where exactly does OpenSIM store assets? Like the images uploaded. Or the prim based objects. Is there a folder? How much is in the database? I recently installed OpenSIM locally and loaded an OAR I keep all my junk in to it, but I found an old SQL file back up from a previous install and was wondering if I were to just load it to a database and point an OpenSIM instance to it, would anything load?

 

[Han Held]

It depends. I'm not exactly sure, but I believe that in standalone mode everything is in your region's mysql (or sqlite, I guess) database. In grid/robust mode all the assets (prims, mesh, textures) would largely be in the database as well, though I think some are cached in your bin folder -in assetcache, I think?

As far as your database goes? Is it mysql database? If so you could create a mysql user/password and load the sql file into that, then point opensim at it and see what happens. Unless you had the matching region and user info my guess would be "not much" -but the assets (textures, prims, meshes) would still be there and could be examined with some sort of mysql front end (phpmyadmin, I think?).

 

[Noodles]

It depends. I'm not exactly sure, but I believe that in standalone mode everything is in your region's mysql (or sqlite, I guess) database. In grid/robust mode all the assets (prims, mesh, textures) would largely be in the database as well, though I think some are cached in your bin folder -in assetcache, I think?

As far as your database goes? Is it mysql database? If so you could create a mysql user/password and load the sql file into that, then point opensim at it and see what happens. Unless you had the matching region and user info my guess would be "not much" -but the assets (textures, prims, meshes) would still be there and could be examined with some sort of mysql front end (phpmyadmin, I think?).

Hmmm, that's a good thought on loading it to a separate database and just changing the names. I may have to try that route. If it works, and it's anything worthwhile I can always dump it to an oar and load it I to the regular instance.

 

[Dianna Loxely]

When switching to fsasset (via Robust) it can import your old mysql blob-asset without the need of connecting the old database to your current simulator.
technically it "rips" out the blob data and writes files out of it (and links it to the new database)
FSAssets Service - OpenSimulator (scroll down to [Migration])
On huge assets (> 10 GB) this is much faster and memory friendly.

 

[Lady Darnk Juniorette]

In the cupboard, above the kitchen sink.

 

[Free]

In the cupboard, above the kitchen sink.

So you finally found the stash of cookies.

 

[Lady Darnk Juniorette]

So you finally found the stash of cookies.

Yes! And I don't appreciate you people holding out on me!!!!!!!