Subsonic Forum

Hi @ll!

Is there a way I can export the settings (inluding users, ....) and import them on another computer / subsonic installation?

Ok.. found some solution..

On db.view i can get the Users (select * from user) and User Settings (select * from user_settings)

Where are the Internet Radio Stations saved? Are there other database tables to save for this?

Plz anyone help me with this..

Get all tables from the database:

Code: Select all

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES

CUSTOM_AVATAR
INTERNET_RADIO
MUSIC_FILE_INFO
MUSIC_FOLDER
PLAYER
PLAYER_TRANSCODING
PODCAST_CHANNEL
PODCAST_EPISODE
ROLE
SYSTEM_AVATAR
TRANSCODING
USER
USER_RATING
USER_ROLE
USER_SETTINGS
VERSION

at least the program is good.. if there is no community for it.

I was wondering if anyone runs into the same issue.

I need to move the database to another server as I've outgrown my old one.

Whats the best process to move? I'm not familiar with this data structure.

Anyone know or at least point me to the right direction?

Thanks



Tim

Looks like you just need to move the folder db, thumbs and playlists to the new server for everything to work.

Although the version I installed on the new server was 4.2 and not 4.1 on the old. I hope I don't break anything.

Anyone know if I missed anything else? other then these folders that is.

Hello

The command Select * from music_file_info worked fine, and I can see all the plays etc, but can I use a command to extract this from the original db and enter it in to the new db?

Alan.