Subsonic Forum

In case I'm in need to change the machine for the Subsonic, how do I backup the current settings and user data?
Loosing the statistics is not an issue, but re-entering all of the users for the system is really not an option.
So..how to move this information to a new server instance? Copypasting the (stopped server) installation file folder do not help.

The database information is stored in the Subsonic working directory in the "db" subfolder.

On Windows that is c:\Subsonic\db by default. Move that folder to your new installation and overwrite the files, and you should have your entire database moved over.

For a "quick and dirty" backup I often go to the db.view screen (http://your.server.ip.address:port/db.view) and type:

Code: Select all

Select * from user

I copy and paste the resultant table into excel and save it. Then, if I ever needed to use that data I could either build "INSERT" statements manually or with an excel text manipulation formula.

HTH,

If you could show how to restore the users, it would be awesome.

This would work I guess.
INSERT INTO user(USERNAME, PASSWORD, BYTES_STREAMED, BYTES_DOWNLOADED, BYTES_UPLOADED, LDAP_AUTHENTICATED, EMAIL) VALUES(' ', ' ', ' ', ' ', ' ', ' ', ' ')