Backing up users

[bruhja]

Can anyone explain how to back up subsonic user logins?

I want to move my Server over to a dedicated Linux machine, however I don't want to lose any logins.

What would I need to thumb drive over to the new machine to maintain user logins.

[PieterB]

I just moved my installation from my desktop to a dedicated netbook with a tiny XP on the 4Gb solid state drive. First I made a copy of the \subsonic directory. Then I installed Subsonic anew on the netbook. The installation created the new \subsonic (where - among other important files - the database resides in \subsonic\db). This new directory was deleted and replaced by the copy of the old installation. Works like a breeze. All users, modding & transcoding settings are present.

I suppose the installation on a Linux box will not differ a great deal. Hope this works for you.

[bruhja]

I'll give it a whirl. Worst case scenario would be "sudo apt-get remove subsonic"
Lol.

[trickydick]

Subsonic creates a script file automatically....that stores all user information in it (includsed an encrypted password). it can be found where the database is labeled: subsonic.script

If you uninstall subsonic, delete all files except that (keep it in the db folder) and reinstall subsonic it will add it all back to the database.

You can also modify user part of the script, it looks a lot like this:

Code: Select all

INSERT INTO USER VALUES('admin','enc:44756e632346132',844363647,0,0,FALSE,NULL)
INSERT INTO USER_ROLE VALUES('admin',1)
INSERT INTO USER_ROLE VALUES('admin',2)
INSERT INTO USER_ROLE VALUES('admin',3)
INSERT INTO USER_ROLE VALUES('admin',4)
INSERT INTO USER_ROLE VALUES('admin',5)
INSERT INTO USER_ROLE VALUES('admin',6)
INSERT INTO USER_ROLE VALUES('admin',7)
INSERT INTO USER_ROLE VALUES('admin',8)
INSERT INTO USER_ROLE VALUES('admin',9)
INSERT INTO USER_ROLE VALUES('admin',10)
INSERT INTO USER_ROLE VALUES('admin',11)
INSERT INTO USER_SETTINGS VALUES('admin',NULL,NULL,TRUE,FALSE,35,TRUE,TRUE,FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,FALSE,35,FALSE,TRUE,TRUE,FALSE,TRUE,TRUE,TRUE,TRUE,TRUE,FALSE,NULL,NULL,'OFF',TRUE,-1,FALSE,TRUE,FALSE,'NONE',NULL,'2013-12-28 01:02:48.983000000',TRUE)



[bruhja]

Subsonic creates a script file automatically....that stores all user information in it (includsed an encrypted password). it can be found where the database is labeled: subsonic.script

That's exactly what I was looking for!!!!!

Cheers!