Xbmc tv show library not updating
In order for Kodi to communicate effectively across your home network, we need to instruct it to use an external My SQL database.
Before we get to that step, however, you’ll need to make an executive decision: you can either back up your current library and restore it later (which can sometimes be finicky), or you can start fresh with a new library (which is easy but will require you to re-set the watched state on your shows, and possibly re-choose your artwork if you don’t store it locally).
When it’s finished, make sure “Launch the My SQL Instance Configuration Wizard” is checked, and click Finish.
Once you’ve backed up the library (or opted to not worry about it and start from scratch), you’re ready to point Kodi to your My SQL server. Regardless of whether you’re editing the existing one or create a new one, cut and paste the following text into the file (note: if there are already some entries in your file, leave those in place and put these values within the correct sections): Edit the above text to reflect the IP address of your server on your LAN and the username/password of your My SQL database (in our example, it was just kodi/kodi).
By default this file does not exist (although it is possible that, during the installation process, Kodi created one for you to deal with specific configuration issues). You’ll need to either import your library (from Settings Import Library), or rescan your sources to begin populating the My SQL database from scratch. When that’s done and your library is back in place, you can hop over to your My SQL command prompt and check to make sure Kodi created and populated the databases.
If the file exists, it will be in the following location, based on your OS: Check in that folder. At the my SQL comment prompt, run: (we’re not using a database for music in our example, so only our video database is appearing in the list).
By default, the Windows installer open the port automatically, but we’ve seen situations in which it didn’t.
The easiest way to open the port is with a Power Shell command.