Forum Activity for @andrusito

alt=
@andrusito
13 Apr 2022 09:31:40AM
298 posts

2 databases


Installation and Configuration

thanks you guys, this was of great help!

what happened to Brian? I see he's not posting anymore...
alt=
@andrusito
12 Apr 2022 12:28:45PM
298 posts

2 databases


Installation and Configuration

thanks Douglas!

so what would be the best way to make sure which DB is not being used?
alt=
@andrusito
12 Apr 2022 09:12:09AM
298 posts

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: 12 Jul 2022 10:24:33PM
alt=
@andrusito
16 Jun 2021 06:00:59AM
298 posts

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!
alt=
@andrusito
15 Jun 2021 09:28:53AM
298 posts

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?
alt=
@andrusito
10 Jun 2021 07:52:21AM
298 posts

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.
alt=
@andrusito
08 Jun 2021 05:10:53AM
298 posts

jrAudio_1089_audio_file.mp3.original.mp3


Using Jamroom

thanks Michael!

In my case there are no wav files and no purchase options on my site :)

you say: "if I delete the .original. version the download still works and the player version still works" so in my case it would be safe to delete the ".original" file, right? Do you know about a mass way to do this?
alt=
@andrusito
07 Jun 2021 06:01:54AM
298 posts

jrAudio_1089_audio_file.mp3.original.mp3


Using Jamroom

Hi! I'm on JR Version: 6.1.7 and I need to free up space on my server.

I noticed I have 2 versions for the same song.

By searching here I found Brian recommends this: "Yes - don't delete the "original" files. Jamroom 5 works a little differently in this regards than JR4, as it always keeps the original file for selling, as well as for the ability to re-convert to new formats or bit rates if needed..." but that was 8 years ago.

The thing is I do not use the lo fi versions anymore so I would like to keep the original files. Is there a way to mass delete these duplicate files? will doing so break the site?
Screenshot (270).png Screenshot (270).png - 230KB

updated by @andrusito: 18 Sep 2021 01:56:04AM
alt=
@andrusito
24 Sep 2018 01:17:21PM
298 posts

ERROR: dbConnect() unable to connect to database server "localhost"


Installation and Configuration

thanks, Paul... I did not find /data/config/config.php so this is definitely JR4.

I went to https://archive.jamroom.net/Jamroom4_Change_MySQL_Password again

I do not have a "settings.zip" file but a "settings.tar.gz" file.

I took the steps but I get the same "ERROR: dbConnect() unable to connect to database server "localhost"..." when going to mysite.com/settings.php

changed permissions from 0644 to 777 but I get the same...

Is there any other way to change dB info?
alt=
@andrusito
21 Sep 2018 05:04:33AM
298 posts

Database Size almost 20GB!


Using Jamroom

Thanks! That did bring the data down.

is there a way to clean these?

jr_jrcore_cache (more than 600MB)
jr_jruser_session (about 1,5 GB)(You said "... Deleting this will cause any users logged in to be logged out... but on certain times there are no users logged in)
1