jamroom_chart_history

alt=
@andrusito
5 months ago
302 posts
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
updated by @andrusito: 02/29/24 01:16:00PM
michael
@michael
5 months ago
7,694 posts
That's not particularly large for a regularly used site. Images are more likely to take up space than the database.

They look like 2 different databases, one has the prefix 'jamroom_' the other 'jr_'. Best to figure out which you are using for your site, you can probably delete the other.

Deleting anything will loose something from your site. eg that jr_jrcomment_item_key is the comments people have made. it works in conjunction with the jr_jrcomment_item table, so those 2 need to be kept in sync.
alt=
@andrusito
5 months ago
302 posts
thanks, Michael. I installed JR back in 2004! Many updates since then... which is the correct prefix for JR 6.1.7?
michael
@michael
5 months ago
7,694 posts
Either could be as both are configurable but the jr_jrc..... one would be my guess as to the most recent one.

Tags