opensim Where Exactly Are Things Stored?

Noodles

Queen of Ramen
Sep 20, 2018
195
Illinois
SL Rez
2006
Joined SLU
04-28-2010
SLU Posts
6947
#1
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

I am the Queen of France, completely
VVO Supporter 🍦🎈👾❤
Sep 20, 2018
195
Anchorage
Joined SLU
September, 2010
SLU Posts
7705
#2
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

Queen of Ramen
Sep 20, 2018
195
Illinois
SL Rez
2006
Joined SLU
04-28-2010
SLU Posts
6947
#3
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.
 
Jan 16, 2019
3
SL Rez
2010
Joined SLU
2012
SLU Posts
76
#4
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.