How to backup user logons?

[HighCast]

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.

[bushman4]

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,

[c0urier]

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(' ', ' ', ' ', ' ', ' ', ' ', ' ')