Update Rpi2(OpenElec v6) to Rpi3(LibreElec v7) with mysql database ?

TRaSH · May 1, 2016 at 8:59 AM

I wonder if this is possible,
I got a RPi2 running OpenElec v6 using shared mysql,
Just bought a RPi3 and installed LibreElec v7 on it and setup everything except the mysql setting.
If I would copy over the advancedsettings.xml then do a reboot so it would update the database.
Would this work ?

**lrusak** · May 1, 2016 at 9:19 AM Official Post

Yes, however I believer there would be an issue with the addon table within the database. We were only able to work around this for the standard sqlite database. So you may have a problem installing new add-ons from the LibreELEC repo

**nickr** · May 1, 2016 at 10:08 AM Official Post

No problem with that here (generic build)

TRaSH · May 1, 2016 at 11:01 AM

Quote from lrusak

Yes, however I believer there would be an issue with the addon table within the database. We were only able to work around this for the standard sqlite database. So you may have a problem installing new add-ons from the LibreELEC repo

wouldn't this be solved by deleting the AddonsXX.db ?

**lrusak** · May 1, 2016 at 6:19 PM Official Post

Quote from TRaSH

wouldn't this be solved by deleting the AddonsXX.db ?

Mysql uses a single database with individual tables. Dropping the table would break it because the table will not be recreated.

**CvH** · May 1, 2016 at 6:39 PM Official Post

Quote from lrusak

Dropping the table would break it because the table will not be recreated.

- dropping the data from the addon table would work - but you have to reactivate your addons (make backups)

- search for old entries *openelec.tv and remove them would also work

- or translate this into mysql

Code

sqlite3 $ADDONSDB "DELETE FROM addon WHERE id IN (SELECT idAddon FROM addonlinkrepo a JOIN repo b ON (a.idRepo = b.id) WHERE b.addonID in (repository.openelec.tv))"
sqlite3 $ADDONSDB "DELETE FROM addonextra WHERE id IN (SELECT idAddon FROM addonlinkrepo a JOIN repo b ON (a.idRepo = b.id) WHERE b.addonID in (repository.openelec.tv))"
sqlite3 $ADDONSDB "DELETE FROM dependencies WHERE id IN (SELECT idAddon FROM addonlinkrepo a JOIN repo b ON (a.idRepo = b.id) WHERE b.addonID in (repository.openelec.tv))"
sqlite3 $ADDONSDB "DELETE FROM addonlinkrepo WHERE idRepo in (SELECT id FROM repo WHERE addonID IN (repository.openelec.tv))"
sqlite3 $ADDONSDB "DELETE FROM repo WHERE addonID IN (repository.openelec.tv)"

TRaSH · May 1, 2016 at 6:41 PM

So easiest would be to take out the sdcard from my RPi2 running OpenElec v6.
Put it in my new RPi3 boot up,
Copy the update file (LibreElec v7) in to the update folder.
Reboot and wait till the update is done.
When done,
Take out the old sdcard and replace it with the new one that has a fresh copy of LibreElec v7 ?

**nickr** · May 2, 2016 at 1:04 AM Official Post

I thought the addons database was separate to the videos database and the music database and did not use mysql?

TRaSH · May 3, 2016 at 9:40 PM

Little update,
I did the update by copying the advancedsettings.xml with the mysql info.
Did a reboot and everything went without any issues.
Upgraded a RPi1 to a RPi2 from OpenElec v6 to LibreElec v7.(separate mysql for my kid)
Upgraded a RPi2 to a RPi3 from OpenElec v6 to LibreElec v7.
And my main HTPC using the mysql database of the RPi3.
Also tried to add some add-ons and that also worked without any issues.
Thnx for all the info.

trogggy · May 3, 2016 at 10:36 PM

Quote from nickr

I thought the addons database was separate to the videos database and the music database and did not use mysql?

Me too. You can't share an addons database between machines - it would make no sense.

TRaSH · May 4, 2016 at 12:43 AM

I checked my mysql database,
I couldn't find any references to the add-on database.
So I think that nickr is right.