OpenSimWorld is the directory of 3D Virtual Worlds based on OpenSimulator and connected through the HyperGrid. Learn More
New Members
May88betsite, Jun88tax, HGHopto, 123bLand, MrZorg, EtienneL, Kubet11app, Red88online, Zotheca, LeelandvanVeen, Anamoulin, Secondlifesux, Taralonestar, JenniferZeminoba, TimTungsten, Enardo, ShugarBuns, Sakshamhsol, Geneshsol, VishalhsolLikes
Region going offline UTC Thursday 6 June 2024 between 3am to UTC 6am.
Simulator will be none accessible during this time.
System to do it's annual PURGE of database removing all assets not used within 1 year to reclaim disk space and defragment databases.
Simulator will be none accessible during this time.
System to do it's annual PURGE of database removing all assets not used within 1 year to reclaim disk space and defragment databases.
Liked by: 
Comments
I would love to know how to clean up the database. I heard that once you upload or acquire an asset it remains in the DB even if you delete it from your inventory and your regions.
I figured the only way would be to save all your regions as OAR's then tidy up your inventory and save as an IAR. Then delete the database, and set up the grid from scratch with a new database using the saved OAR's and IAR's. Only piratical for small grids and sounds like a real pain in the bum. This would also mean making a new avatar too, not great.
I then found this site from 2013 https://grimore.org/opensim/database/asset_cleaner
It seems to take all the OAR's and IAR's and scans them, then removes anything in the database that is not found in the OAR's/IAR's.
This sounds great, however its from 2013 and I have no idea if the script will work properly today. I'm not smart enough to even try running it. I found setting up the grid hard enough, and I would have no clue how to fix things if this script messed everything up.
It would be nice to have a way to clean up the database build into open simulator.
like(2)
I figured the only way would be to save all your regions as OAR's then tidy up your inventory and save as an IAR. Then delete the database, and set up the grid from scratch with a new database using the saved OAR's and IAR's. Only piratical for small grids and sounds like a real pain in the bum. This would also mean making a new avatar too, not great.
I then found this site from 2013 https://grimore.org/opensim/database/asset_cleaner
It seems to take all the OAR's and IAR's and scans them, then removes anything in the database that is not found in the OAR's/IAR's.
This sounds great, however its from 2013 and I have no idea if the script will work properly today. I'm not smart enough to even try running it. I found setting up the grid hard enough, and I would have no clue how to fix things if this script messed everything up.
It would be nice to have a way to clean up the database build into open simulator.
At my very small level when I wanted to make dangerous changes to my sims, I copied the entire opensim directory and the sql into another one, that way I would find it all unchanged if things went wrong. But obviously it doesn't purge the database... having the tutorial would surely be useful for many people, if it is not easily found on the net...
(it would be good too to have an "undo" sometimes for very small deletions or unwanted movements ;)
like(1)
(it would be good too to have an "undo" sometimes for very small deletions or unwanted movements ;)
If you have HDD space shutdown mysql then execute: rsync -avzh /var/lib/mysql/ DESTINATION PATH assuming that's the location of your mysql databases.
or you could compress with TAR which will take a long time using following command.
tar zpcf $BackupDestPath/mysql_backup.tar.gz -C /var/lib/mysql which includes sub folders and permissions and to restore execute: note that -C is not DRIVE letter the / on end tells to restore to root path which restores to original path with permissions.
tar mysql_backup.tar.gz -C /
Mysql does not reclaim disk space when you delete databases. Unless you already configured mysql to use separate file for each database in configuration which isn't set by default on installation.
That will copy the mysql dbases to destination which includes ALL path and owner permissions.
So if you screw up the dbase. Make sure to shutdown mysqlf before moving backup back. Then restart mysql.
Always shutdown mysql when manually copying or restoring it.
like(1)
or you could compress with TAR which will take a long time using following command.
tar zpcf $BackupDestPath/mysql_backup.tar.gz -C /var/lib/mysql which includes sub folders and permissions and to restore execute: note that -C is not DRIVE letter the / on end tells to restore to root path which restores to original path with permissions.
tar mysql_backup.tar.gz -C /
Mysql does not reclaim disk space when you delete databases. Unless you already configured mysql to use separate file for each database in configuration which isn't set by default on installation.
That will copy the mysql dbases to destination which includes ALL path and owner permissions.
So if you screw up the dbase. Make sure to shutdown mysqlf before moving backup back. Then restart mysql.
Always shutdown mysql when manually copying or restoring it.
If you don't have a large grid with many users I'll show you a step by step way to clean things up. This is for linux not windows. I'm busy today and will put something together later this week and post.
like(0)