Recently I made a mistake and refreshed my movie database in Kodi 16.1, causing all my watched data, fixed titles, etc. to be lost.
To resolve this, I decided to store the MySQL database from a backup, which as far as I can see from the MySQL workbench, was successful. I can see all the movies names, etc. in the database. However, now I can no longer see any movies or shows in Kodi.
Here are the exact steps I have performed:
* Opened the .sql backup file of a few days ago and removed all restore jobs on other schemas, I only left xbmc_video99
* Used MySQL workbench to restore the file.
* Found the issue when I restarted OpenELEC, confirmed the issue on both Kodi on Mac and Android.
* Restricted access to MySQL for Kodi, ensuring that no changes can be performed during the restore and restored again. Same issue.
* Removed the Kodi directory in the Mac Library (ensuring all userdata folder, etc are gone), restored the backup again with access restricted.
* Started Kodi on Mac, stopped it so the kodi directory is recreated in the library, added my advancedsettings.xml and confirmed the issue was still * the same.
* Performed another restore after first dropping the xbmc_video99 schema completely.
I’ve uploaded a debug log to: http://pastebin.com/GCtSkC5s (usernames, password, hostnames changed)