How to rebuild the serviio database

Here is how to rebuild a servioo database.
Prerequisite : you need Squirrel (downloaded, installed, configured) and the Apache derby package.
Help : http://squirrel-sql.sourceforge.net/paper/GettingStartedusingtheSQuirreLSQLClient.pdf
If you do not understand the following, do not play with the database.
Snapshots show MY pathes, of course, you need to enter your own values...
As you can see, english is not my native language !

1 Stop Serviio server

2 Copy existing library

3 Remove serviio library sub folders but keep derby.properties file


4 Start Serviio server. This will re-create a database : 2.4 Mo only
You can check everything is empty / reset to default values (mediabrowser and console)

5 Stop Serviio server

6 Open Squirrel
If you get memory error problems, increase the memory allocated to Squirrel:
https://sourceforge.net/p/squirrel-sql/mailman/message/19660184/

7 Make a copy of the alias,

rename the alias ServiioOriginal, and edit it to modify the database path (URL)


8 Copy the config from ServiioOriginal (right clic -> Copy table)


9 Paste the config to serviio database, config (right clic -> Paste table)

10 Copy and paste REPOSITORY (see steps 8 and 9)

11 Copy and paste REPOSITORY_ACCESS_GROUP (see steps 8 and 9)

12 Close Squirrel and start the servvio server.
Browse the console shared folders page, clic Force Refresh .. and wait until no more files are added on the console welcome screen.

THE END