Import Music Library using mySQL
#1
Hi all,

After being too busy for some time I've finally got around to installing eden and migrating my library over to it.

My existing setup is running Dharma 10.1 using mySQL on a WHS box and the new setup is running Eden RC2 on an unRAID box.

I have exported my video and music library on the WHS server to a single xml file. Using notepad++ I changed all instances of the old server IP to the new server IP for both the video and music library exports.

mySQL is up and running on the unRAID box and I have been able to successfully import the video library from the old setup. However I have not been able to import the music library. The system looks like it is doign some sort of import but the screen flashes though the library items very quickly and they are not getting written to the database (the video library import did take some time).

I've tried dropping the MyMusic18 database and reimporting but this is not working. Using Heidi SQL I can look at the mySQL DB and see the the Mymusic18 db is being created on starting XBMC but it is not getting populated. Its only 22kB in size.

I've seen a few posts here with similar issues but no resolutions other than scan the library again rather than use the import.

Debug log from an import here
Extract from the music library export here

By the way - Eden looks great. Thanks to all.
Openelec on ASRock ION 330 / Kodi on Win 7 PC
Reply
#2
For music you must rescan as XBMC gets the information from your music files. You may disable the scraping portion (settings->music->library) though, as you can then import that information from your XML export.
Always read the XBMC online-manual, FAQ and search the forum before posting.
Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules.
For troubleshooting and bug reporting please make sure you read this first.


Image
Reply
#3
Cheers Jonathon, That makes sense. I was hoping to avoid the tag scrape as well. I'll add something to the wiki to explain this a bit better.
Openelec on ASRock ION 330 / Kodi on Win 7 PC
Reply
#4
mysql database is not being populated with my music and movies.
| Cooler Master MasterCase Maker 5 | Gigabyte Aorus X299 Ultra Gaming Motherboard | Intel Core i7 [email protected] | Corsair Vengence 16GB x 2 Ram | Samsung SSD 960 PRO 512GB M.2 |
| Western Digital 1TB HDD | HGST Ultrastar 4TB HDD | Gigabyte GeForce GTX 950 Extreme | Ubuntu 20.04 x86_64 | Windows 10 Pro 1909 |
Reply

Logout Mark Read Team Forum Stats Members Help
Import Music Library using mySQL0