[Hijinxx]

Hi there,

Ive just setup a new SQL DB on a Synology NAS. I Still have the old SQL DB and want to export just the watched list from one to the other. Anyone know how to do this?

Thanks ; )

[zerocool_ie]

you can dump the whole database down and then push it back up to your new server

(Assuming Kodi Helix RC running on Windows)

Run on the source mysql server:

Code:

mysql\bin\mysqldump -h source-db-ip-address -u xbmc -pxbmc myvideos90 > "D:\xbmcbackups\myvideos90.sql"
mysql\bin\mysqldump -h source-db-ip-address -u xbmc -pxbmc mymusic48 > "D:\xbmcbackups\mymusic48.sql"

then:

Code:

mysql\bin\mysql -h synology-ip-address -u xbmc -pxbmc MyVideos90 < "D:\xbmcbackups\myvideos90.sql"
mysql\bin\mysql -h synology-ip-address -u xbmc -pxbmc MyMusic48 < "D:\xbmcbackups\mymusic48.sql"

This will restore an exact copy of your database to the NAS.

If you want to keep the watched status only, have a look at the trakt addon.