April 22, 201511 yr Afternoon all, I currently have my unRAID server with MySQL running my Kodi database. I want to upgrade to V6, but am worried about the database and after searching cannot find anything about this. Please could someone advise me how i would best go about this. Cheers Ben
April 22, 201511 yr When I made the same jump, I was worried also. After reading about backing up, and restoring the backup, and everything else, I finally decided that the easiest method for me would be to simply tell Kodi to export the video / music database, overwriting all of the NFO files. Then I upgraded to the MariaDB docker, told Kodi to reimport my libraries. Definitely not the fastest way of doing things, but it does work.
April 23, 201511 yr Author Why not use the MySQL doscker? https://registry.hub.docker.com/_/mysql/ Can i then just point it to my existing database?
April 23, 201511 yr Why not use the MySQL doscker? https://registry.hub.docker.com/_/mysql/ Can i then just point it to my existing database? I can't tell you that all I know is that this docker exists.
April 23, 201511 yr If you've got phpmyadmin or other SQL admin program (HeidiSQL?), just pull down a backup of the DB and restore if required.
April 23, 201511 yr Author Hi guys thanks for the input. I have completed the upgrade now and I hope the following will help others... I went with the MySQL docker in the end and pointer the data dir to my existing MySQL database user share. As HellDiverUK said it is worth using HeidiSQL or alike to backup first just incase but thankfully i never needed this... it was really painless!
April 26, 201511 yr Afternoon all, I currently have my unRAID server with MySQL running my Kodi database. I want to upgrade to V6, but am worried about the database and after searching cannot find anything about this. Please could someone advise me how i would best go about this. Cheers Ben I have looked around but haven't found a guide to setting up a mysql server for Kodi on Unraid. Do you happen to have a link to a guide you used to set yours up? I am currently running unraid 6 15b, so I would be using mysql docker container. Thanks.
April 26, 201511 yr MariaDB is a direct MySQL replacement so you don't have to use MySQL. You shouldn't have any issues backing up your MySQL database and importing it into MariaDB. You also won't have any issues using MariaDB as a replacement for MySQL. Just saying.
April 26, 201511 yr Afternoon all, I currently have my unRAID server with MySQL running my Kodi database. I want to upgrade to V6, but am worried about the database and after searching cannot find anything about this. Please could someone advise me how i would best go about this. Cheers Ben I have looked around but haven't found a guide to setting up a mysql server for Kodi on Unraid. Do you happen to have a link to a guide you used to set yours up? I am currently running unraid 6 15b, so I would be using mysql docker container. Thanks. If you search, I believe that there's a couple of threads about this. I think however that the easiest way would be to install the MariaDB docker container, and then follow the guide on Kodi's website (but use MySQL Workbench from your desktop to connect to the database to enter in the SQL commands) - That's how I did it.
Archived
This topic is now archived and is closed to further replies.