MySQL Database empty after upgrading to Omega

Hello,

unfortunally my MySQL Database won’t migrate to Omega.

I just installed the update from 20.5 and i’m not able to get the Database back.

Log show somthing like:

Old database found - updating from version 121 to 131
SQL: Can' t create database for copy: 'MyVideos121'(1007)
Unable to copy old database MyVideos121 to new version MyVideos131 

and got some more errors like:
2025-04-16 09:32:04.755 T:563 error <general>: Unable to open database: MyVideos123 [1049](Unknown database 'MyVideos123')
2025-04-16 09:32:04.743 T:563 error <general>: Unable to open database: MyVideos124 [1049](Unknown database 'MyVideos124')
2025-04-16 09:32:04.731 T:563 error <general>: Unable to open database: MyVideos125 [1049](Unknown database 'MyVideos125')
2025-04-16 09:32:04.718 T:563 error <general>: Unable to open database: MyVideos126 [1049](Unknown database 'MyVideos126')
2025-04-16 09:32:04.706 T:563 error <general>: Unable to open database: MyVideos 127 [1049](Unknown database 'MyVideos127')
2025-04-16 09:32:04.694 T:563 error <general>: Unable to open database: MyVideos 128
2025-04-16 09:32:04.682 T:563 error <general>: Unable to open database: MyVideos 129

I have just this OSMC device on that SQL server running.
When i recover to an older OSMC Version, the database is working fine again.

Someone can help me?

Tanks in advanced.

It’s possible that whatever MySQL user you are using doesn’t have enough permissions to create a database. It’s hard to tell with tiny long snippets though. Posting the entire log file will be much more useful.

Hi, thanks for your reply!

Well, the user is since ever identical. Didn’t change anything on the SQL Server.
And I did couple of release upgrades with no issues?!

Here is the relevant log:

2025-04-16 11:29:12.519 T:564      info <general>: Running database version Addons33
2025-04-16 11:29:12.520 T:564      info <general>: Running database version ViewModes6
2025-04-16 11:29:12.522 T:564      info <general>: Running database version Textures13
2025-04-16 11:29:12.541 T:564      info <general>: MYSQL: Connected to version 8.0.41-0ubuntu0.20.04.1
2025-04-16 11:29:12.549 T:564      info <general>: Attempting to update the database MyMusic83 from version 82 to 83
2025-04-16 11:29:12.562 T:564     error <general>: SQL: [MyMusic83] The table does not exist
                                                   Query: select count(idSong) as NumSongs from songview 
                                                   
2025-04-16 11:29:12.562 T:564     error <general>: GetSongsCount() failed
2025-04-16 11:29:12.563 T:564      info <general>: UpdateTables - updating tables
2025-04-16 11:29:12.565 T:564     error <general>: SQL: [MyMusic83] Undefined MySQL error: Code (1060)
                                                   Query: ALTER TABLE song ADD strVideoURL TEXT
                                                   
2025-04-16 11:29:12.565 T:564     error <general>: Exception updating database MyMusic83 from version 82 to 83
2025-04-16 11:29:12.565 T:564     error <general>: Error updating database MyMusic83 from version 82 to 83
2025-04-16 11:29:12.586 T:564      info <general>: Old database found - updating from version 82 to 83
2025-04-16 11:29:12.591 T:564     error <general>: SQL: Can't create database for copy: 'MyMusic82' (1007)
2025-04-16 11:29:12.591 T:564     error <general>: Unable to copy old database MyMusic82 to new version MyMusic83
2025-04-16 11:29:12.613 T:564      info <general>: Attempting to update the database MyVideos131 from version 121 to 131
2025-04-16 11:29:12.660 T:564     error <general>: SQL: [MyVideos131] Undefined MySQL error: Code (1050)
                                                   Query: CREATE TABLE videoversiontype (id INTEGER PRIMARY KEY auto_increment , name TEXT, owner INTEGER) CHARACTER SET utf8 COLLATE utf8_general_ci
                                                   
2025-04-16 11:29:12.660 T:564     error <general>: Exception updating database MyVideos131 from version 121 to 131
2025-04-16 11:29:12.660 T:564     error <general>: Error updating database MyVideos131 from version 121 to 131
2025-04-16 11:29:12.680 T:564     error <general>: Unable to open database: MyVideos130 [1049](Unknown database 'MyVideos130')
2025-04-16 11:29:12.698 T:564     error <general>: Unable to open database: MyVideos129 [1049](Unknown database 'MyVideos129')
2025-04-16 11:29:12.715 T:564     error <general>: Unable to open database: MyVideos128 [1049](Unknown database 'MyVideos128')
2025-04-16 11:29:12.734 T:564     error <general>: Unable to open database: MyVideos127 [1049](Unknown database 'MyVideos127')
2025-04-16 11:29:12.753 T:564     error <general>: Unable to open database: MyVideos126 [1049](Unknown database 'MyVideos126')
2025-04-16 11:29:12.773 T:564     error <general>: Unable to open database: MyVideos125 [1049](Unknown database 'MyVideos125')
2025-04-16 11:29:12.791 T:564     error <general>: Unable to open database: MyVideos124 [1049](Unknown database 'MyVideos124')
2025-04-16 11:29:12.808 T:564     error <general>: Unable to open database: MyVideos123 [1049](Unknown database 'MyVideos123')
2025-04-16 11:29:12.825 T:564     error <general>: Unable to open database: MyVideos122 [1049](Unknown database 'MyVideos122')
2025-04-16 11:29:12.849 T:564      info <general>: Old database found - updating from version 121 to 131
2025-04-16 11:29:12.854 T:564     error <general>: SQL: Can't create database for copy: 'MyVideos121' (1007)
2025-04-16 11:29:12.854 T:564     error <general>: Unable to copy old database MyVideos121 to new version MyVideos131
2025-04-16 11:29:12.859 T:564      info <general>: Running database version TV46
2025-04-16 11:29:12.862 T:564      info <general>: Running database version Epg16

I just droped the user for MySQL and create a new one like it is in MySQL/Setting up MySQL - Official Kodi Wiki mentioned.

Just the same error.

Which version other than Nexus did you had?
Generally your error is clearly a permission issue. KODI Database user need full permission not only on the current database but also to create new database and assign full rights (therefore I would normally run it on a dedicated MySQL server)

… I got it.

Just rolled back my SQL Server before OSMC Update,
then i droped the User in MySQL and create a new
(actually exact the same one, so i don’t have to redo the settings in OSMC)
as in MySQL/Setting up MySQL - Official Kodi Wiki described.

After a reboot on OSMC, the migration worked as expected!

Tanks for the help!