Posts: 62
Joined: Sep 2013
Reputation:
0
Hello,
one short question -
i have running a xbmc installation with an mysql-db on a synology-nas
Where can i find the databases for video and music?
And how can i see the databased with putty? (would like to check how large the database is and what the last modified date ist)
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
ssh in to your synology.
run mysql as the user and password you set up when following the wiki instructions.
The database is called MyVideosxx where xx depends on kodi version number.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 90
Joined: Oct 2006
Reputation:
5
You can also install phpMyAdmin from the Package Center on the Synology, then you will be able to view/maintain the database via the browser, and check size, overhead etc and drop old databases.
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
2015-02-27, 20:34
(This post was last modified: 2015-02-27, 20:34 by nickr.)
mysql -h 192.168.0.13 -u xbmc -p
show databases
connect elternvideoXX
Now run your SQL commands.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 62
Joined: Sep 2013
Reputation:
0
when i try the first line on the Diskstation> prompt i get:
-sh: mysql: not found
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
Bugger, so it has the server, but not the client. Oh well, run from a computer that does have mysql client on it. Simple on a Linux machine.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 62
Joined: Sep 2013
Reputation:
0
i have found on the synology in the following path:
@database\mysql
the databases:
elternvideo75
elternvideo78
why are these 2 different numbern in the database?
Posts: 19,982
Joined: May 2009
Reputation:
451
nickr
Retired Team-Kodi Member
Posts: 19,982
Because different versions of xbmc/kodi use different db versions. When you run a new version of xbmc/kodi it updates the db and leaves the old behind. The wiki lists what version goes with which database.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Posts: 62
Joined: Sep 2013
Reputation:
0
Yes this works well - many thanks!