jamroom_chart_history
Using Jamroom
thanks, Michael. I installed JR back in 2004! Many updates since then... which is the correct prefix for JR 6.1.7?
Forum Activity for @andrusito
Using Jamroom
thanks, Michael. I installed JR back in 2004! Many updates since then... which is the correct prefix for JR 6.1.7?
jamroom_chart_history
Using Jamroom
Hi.
my JR database is almost 500MB.
I'm trying to save space.
are any of these safe to empty?
jamroom_chart_history 143.8 MB -
jamroom_vchart_history 58.6 MB -
jr_jrcomment_item_key 52.2 MB -
jr_jrcore_log 40.1 MB -
jr_jrsearch_fulltext 28.1 MB -
jamroom_scounter_archive 20.0 MB
moving from home to sub folder
Installation and Configuration
Hi! I found this HowTo: Change The Jamroom Directory Or Domain.
The thing is I want to do the opposite:
changed the directory location of my Jamroom install (for example - moving my Jamroom install from my main HTML directory into a sub directory.
How do I go about this?
updated by @andrusito: 07/28/23 06:10:40AM
2 databases
Installation and Configuration
thanks you guys, this was of great help!
what happened to Brian? I see he's not posting anymore...
2 databases
Installation and Configuration
thanks Douglas!
so what would be the best way to make sure which DB is not being used?
2 databases
Installation and Configuration
Hi guys.
I'm getting ready to migrate my JR installation to another server. From the migration dept. I was told this:
"We just checked your site's data and you have 2 databases with over 1GB which is 14.1GB for user_jam5 and 3.1GB for user_jamroom.
As on these we are not so sure what is data related. Although seems can be removed but it is best you reduce the size of this database to avoid errors. "
I lowered the size on one database (reinaa_jam5, I deleted content inside table jr_jruser_session)
but for reinaa_jamroom I still have these:
jamroom_cache_rank - 1.5 GB
jamroom_chart_history - 500 MB
jamroom_chart_cache - 494 MB
1. Are these safe to empty?
2. Does JR uses 2 databases or one of them is old and is safe to discard? (I'm using JR since 2003!
updated by @andrusito: 07/12/22 10:24:33PM
jrAudio_1089_audio_file.mp3.original.mp3
Using Jamroom
hey Michael, yes, you are right!
All the mp3s from that folder are bundled into a zip. And this without me having the shop enabled, terrible waste of space... so not only I have duplicate mp3 files, but another zip with more duplicate files
- This option was back from the 2000s, when we used to buy mp3s.Anyway, guess I will delete all those... thank your for wonderful help, man!
jrAudio_1089_audio_file.mp3.original.mp3
Using Jamroom
ok I guess Brian is not around... I also noticed .zip files inside every data/media/ folder, what are those? are they safe to delete?
jrAudio_1089_audio_file.mp3.original.mp3
Using Jamroom
Thanks, Michael! I understand what you are saying... Is there any chance Brian could see this? I see he's not been active here for a while... although I understand those original files are copies of what's been uploaded, but if I could get his input just to be sure.
