Kodi Community Forum
Importing libraries into MySQL with single file - Printable Version

Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: Windows (https://forum.kodi.tv/forumdisplay.php?fid=59)
---- Thread: Importing libraries into MySQL with single file (/showthread.php?tid=308007)



Importing libraries into MySQL with single file - jalcaid001 - 2017-02-24

Hi,

I don't like creating new .nfo files, so I did export from Kodi with local database and then import with Kodi with MySQL database. It seemed to worked fine. Should I expect any problems?

I read the discussion about single file problems (http://kodi.wiki/view/Why_multiple_files#Why_.22multiple_files.22_and_not_single-file_export.3F), but I don't understand it.
In the export folder, I see thumbnails names like 'C:\temp\xbmc_videodb_2017-02-24\actors\Aaron_Abrams.jpg'. I don't see this filename on my %Appdata%/Kodi/userdata/Thumbnails

Also, "C:\temp\xbmc_videodb_2017-02-24\videodb.xml' seems to contain only http references. So I don't understand the explanation about references to local files. For instance:


<movie>
<title>Deathgasm</title>
<originaltitle>Deathgasm</originaltitle>
<rating>6.500000</rating>
<userrating>0</userrating>
<epbookmark>0.000000</epbookmark>
<year>2015</year>
<top250>0</top250>
<votes>49</votes>
<outline></outline>
<plot>Two teenage boys unwittingly summon an ancient evil entity known as The Blind One by delving into black magic while trying to escape their mundane lives.</plot>
<tagline>Evil is coming...</tagline>
<runtime>86</runtime>
<thumb aspect="poster" preview="http://image.tmdb.org/t/p/w500/690lTkTztwK2HLhO9vovXJGeIcQ.jpg">http://image.tmdb.org/t/p/original/690lTkTztwK2HLhO9vovXJGeIcQ.jpg</thumb>
<thumb aspect="poster" preview="http://image.tmdb.org/t/p/w500/yz3L43i3G6OxnXGLYJKepIX9FbM.jpg">http://image.tmdb.org/t/p/original/yz3L43i3G6OxnXGLYJKepIX9FbM.jpg</thumb>
<thumb aspect="poster" preview="http://image.tmdb.org/t/p/w500/5KfAPlBIFjDdqnqN7XkVbkjrEAR.jpg">http://image.tmdb.org/t/p/original/5KfAPlBIFjDdqnqN7XkVbkjrEAR.jpg</thumb>
<thumb aspect="poster" preview="http://image.tmdb.org/t/p/w500/oS8MVUPaTPv9ScTxIqJM5T7fqNv.jpg">http://image.tmdb.org/t/p/original/oS8MVUPaTPv9ScTxIqJM5T7fqNv.jpg</thumb>
<thumb aspect="poster" preview="http://image.tmdb.org/t/p/w500/8i1HbdJXad5kdXQguNRlV8msvgo.jpg">http://image.tmdb.org/t/p/original/8i1HbdJXad5kdXQguNRlV8msvgo.jpg</thumb>
<fanart>
<thumb preview="http://image.tmdb.org/t/p/w780/iZ1Iyh6pe0Igt3n95DxkJWBfwOD.jpg">http://image.tmdb.org/t/p/original/iZ1Iyh6pe0Igt3n95DxkJWBfwOD.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/v8C2vMJ5ZhGnqQNjmAIXHkq7Ulh.jpg">http://image.tmdb.org/t/p/original/v8C2vMJ5ZhGnqQNjmAIXHkq7Ulh.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/dk0g1ds1R1Pnx887DsKFBsPclnc.jpg">http://image.tmdb.org/t/p/original/dk0g1ds1R1Pnx887DsKFBsPclnc.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/uFHSeShAHJuWnAC1wS6aFAH7JvP.jpg">http://image.tmdb.org/t/p/original/uFHSeShAHJuWnAC1wS6aFAH7JvP.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/1HwmOoT5VGvACHqzDZjUnszTmW1.jpg">http://image.tmdb.org/t/p/original/1HwmOoT5VGvACHqzDZjUnszTmW1.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/8rXHJJdCermThuyYxvpll1rS1WV.jpg">http://image.tmdb.org/t/p/original/8rXHJJdCermThuyYxvpll1rS1WV.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/8ycuOXsPu7gN7Q5bdl5KEvpBpr0.jpg">http://image.tmdb.org/t/p/original/8ycuOXsPu7gN7Q5bdl5KEvpBpr0.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/aX3Tj1iZ6RELtPEgk48QEpiz6sg.jpg">http://image.tmdb.org/t/p/original/aX3Tj1iZ6RELtPEgk48QEpiz6sg.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/1WBewO95FCwAhh4XOfKwMstRTpO.jpg">http://image.tmdb.org/t/p/original/1WBewO95FCwAhh4XOfKwMstRTpO.jpg</thumb>
<thumb preview="http://image.tmdb.org/t/p/w780/u7GSYEvjx0bIzoloDqj6Ea3xD1.jpg">http://image.tmdb.org/t/p/original/u7GSYEvjx0bIzoloDqj6Ea3xD1.jpg</thumb>
</fanart>
<mpaa>Rated NR</mpaa>
<playcount>1</playcount>
<lastplayed>2016-04-24</lastplayed>
<file></file>
<path>smb://192.168.1.6/EXT1_SHARE1/MMovies/</path>
<filenameandpath>smb://192.168.1.6/EXT1_SHARE1/MMovies/Deathgasm.2015.1080p.BluRay.x264-MZABI.mp4</filenameandpath>
<basepath>smb://192.168.1.6/EXT1_SHARE1/MMovies/Deathgasm.2015.1080p.BluRay.x264-MZABI.mp4</basepath>
<id>tt3705412</id>
<genre>Comedy</genre>
<genre>Horror</genre>
<country>New Zealand</country>
<credits>Jason Lei Howden</credits>
<director>Jason Lei Howden</director>
<premiered></premiered>
<status></status>
<code></code>
<aired></aired>
<studio>The New Zealand Film Commission</studio>
<trailer>plugin://plugin.video.youtube/?action=play_video&amp;videoid=4m6BIvN3ggM</trailer>
<fileinfo>
<streamdetails>
<video>
<codec>avc1</codec>
<aspect>2.352941</aspect>
<width>1920</width>
<height>816</height>
<durationinseconds>5165</durationinseconds>
<stereomode></stereomode>
</video>
<audio>
<codec>aac</codec>
<language>und</language>
<channels>2</channels>
</audio>
<subtitle>
<language>eng</language>
</subtitle>
</streamdetails>
</fileinfo>
<actor>
<name>Milo Cawthorne</name>
<role>Brodie</role>
<order>1</order>
<thumb>http://image.tmdb.org/t/p/original/7mn0C5OMD3wDQW5WAAOGCLK7meE.jpg</thumb>
</actor>
<actor>
<name>Kimberley Crossman</name>
<role>Medina</role>
<order>3</order>
<thumb>http://image.tmdb.org/t/p/original/eQYEU84VjXJ8lhQRSfH4y5x4FeC.jpg</thumb>
</actor>
<actor>
<name>Sam Berkley</name>
<role>Dion</role>
<order>4</order>
<thumb>http://image.tmdb.org/t/p/original/hnBTy62dxv9Bq5tMiFQXd9RXOGq.jpg</thumb>
</actor>
<actor>
<name>Delaney Tabron</name>
<role>Shanna</role>
<order>5</order>
<thumb>http://image.tmdb.org/t/p/original/omc7uEYP0FW1UdNRiBiY7IFA7Dp.jpg</thumb>
</actor>
<actor>
<name>James Blake</name>
<role>Zakk</role>
<order>6</order>
<thumb></thumb>
</actor>
<actor>
<name>Daniel Cresswell</name>
<role>Giles</role>
<order>7</order>
<thumb></thumb>
</actor>
<actor>
<name>Stephen Ure</name>
<role>Rikki Daggers</role>
<order>8</order>
<thumb>http://ia.media-imdb.com/images/M/[email protected]@._V1_SX1024_SY1024_.jpg</thumb>
</actor>
<actor>
<name>Colin Moy</name>
<role>Uncle Albert</role>
<order>9</order>
<thumb>http://image.tmdb.org/t/p/original/2EjNqj5dzcHX0prekGpkObg0noN.jpg</thumb>
</actor>
<actor>
<name>Jodie Rimmer</name>
<role>Aunt Mary</role>
<order>10</order>
<thumb>http://image.tmdb.org/t/p/original/6x4hcxb05NNdkmG3JIN9n6SISzl.jpg</thumb>
</actor>
<actor>
<name>Nick Hoskins-Smith</name>
<role>David</role>
<order>11</order>
<thumb></thumb>
</actor>
<actor>
<name>Erroll Shand</name>
<role>Byron</role>
<order>12</order>
<thumb>http://ia.media-imdb.com/images/M/[email protected]@._V1_SX1024_SY1024_.jpg</thumb>
</actor>
<actor>
<name>Kate Elliott</name>
<role>Abigail</role>
<order>13</order>
<thumb>http://image.tmdb.org/t/p/original/52Eskx4ybyTY61GLotxCFT4VhSn.jpg</thumb>
</actor>
<actor>
<name>Aaron McGregor</name>
<role>Terry</role>
<order>14</order>
<thumb></thumb>
</actor>
<actor>
<name>Andrew Laing</name>
<role>Aeon</role>
<order>15</order>
<thumb></thumb>
</actor>
<actor>
<name>Tim Foley</name>
<role>Vadin</role>
<order>16</order>
<thumb></thumb>
</actor>
<actor>
<name>Cameron Rhodes</name>
<role>Mr. Capenhurst</role>
<order>17</order>
<thumb>http://image.tmdb.org/t/p/original/58diJ0mAP4EzwsVXumz0YqcfwcD.jpg</thumb>
</actor>
<resume>
<position>0.000000</position>
<total>0.000000</total>
</resume>
<dateadded>2016-04-17 01:14:40</dateadded>
<art>
<fanart>http://image.tmdb.org/t/p/original/iZ1Iyh6pe0Igt3n95DxkJWBfwOD.jpg</fanart>
<poster>http://image.tmdb.org/t/p/original/690lTkTztwK2HLhO9vovXJGeIcQ.jpg</poster>
</art>
</movie>[/u]


This forum uses Lukasz Tkacz MyBB addons.