Madsonic DB Utilites

readme.md

Madsonic DB Utilites

Madsonic 5.1 to 6.3 Database transfer guide

ToC

• about
• FAQ
• dependencies
• usage
• example

about

This tool can help migrate data from exiting Madsonic 5.1 database to a fresh Madsonic 6.3 installation.

<Madsonic_5.1>       <Madsonic_6.3> 
<HSQLDB_2.3.2>  -->  <HSQLDB_2.4.0>

FAQ

How does it work?

This is an offline migration tool, which transfer your data directly to the new database.

What can be transferd?

• Useraccounts
• Usersettings
• Starred Media for each User

What can not be transferd? (not implemented yet)

• comments
• playlists
• play counts

dependencies

• Java JRE =< 1.8.0_131
• Madsonic 5.1 Build =< 5280
• Madsonic 6.3 Build =< 9580

configuration

Edit madsonic-util.properties to specify the location of existing databases.

windows example

#Madsonic-util preferences.  
MadsonicDBV5=C\:\\Madsonic51\\db\\madsonic
MadsonicDBV6=C\:\\Madsonic63\\db\\madsonic

linux example

#Madsonic-util preferences.  
MadsonicDBV5=\\var\\madsonic5\\db\\madsonic
MadsonicDBV6=\\var\\madsonic6\\db\\madsonic

syntax

java -cp madsonic-utils.jar <method> <argument>

examples

java -cp madsonic-utils.jar org.madsonic.TablesStatisticV5
java -cp madsonic-utils.jar org.madsonic.TablesStatisticV6
java -cp madsonic-utils.jar org.madsonic.ShowStarredMedia admin
java -cp madsonic-utils.jar org.madsonic.TransferUser
java -cp madsonic-utils.jar org.madsonic.TransferStarredMedia admin
java -cp madsonic-utils.jar org.madsonic.TransferStarredMedia bob