[RPi4] Shared kodi database not working with LE12

Hello everyone!
First of all my configuration:
3 x86 PCs with LE11
1 fire stick with latest version of kodi for android
1 rasp Pi4 with tvhat and LE12
1 HP 24/7 server with updated ubuntu server, mysql, tv tuner, 8 hdd, ip:192.168.1.xxx

In the HP server there is the kodi library based on mysql and shared between the various kodi machines.
So, I edited the advancedsettings.xml file

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.xxx</host>
<port>3306</port>
<user>xxxx</user>
<pass>xxxx</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.xxx</host>
<port>3306</port>
<user>xxxx</user>
<pass>xxxx</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>

The three x86 machines with LE11 work perfectly with the shared library.
Instead rasp pi4 and android kodi do not work or rather they see the old library from a year ago and do not synchronize the resume points and the watched states with the other PCs.
If I update the three PCs to LE12 the shared library no longer works but if I put LE11 back then they start working correctly again.

I wonder if the problem is on the latest version of kodi or on mysql. Is there any particular setting to set on mysql?
Thanks for your patience.

Quote from chewitt

I'd guess you test-updated to LE12 in the past which resulted in one of the devices migrating the K20 SQL DB tables to the K21 DB version. You haven't used K21 since so the data is stale, but it exists so (correctly) no migration takes place, and when you run the RPi4 it sees the K21 DB tables and uses them.

Hi, no, I have never tried an update before. I simply switched from LE9 to LE10 years ago without any problems and it immediately synchronized the database correctly.
I am trying to follow your instructions now. Thanks for the instructions.

Hi. I connected the shared database via RazorSQL program and I see appearing:
MyMusic72
MyMusic82
MyMusic83
MyVideos116
MyVideos119
MyVideos121
MyVideos131
information_schema
mysql
performance_schema
sys

So, if I understood correctly, I have to delete everything and keep only MyMusic83 and MyVideos131, is that correct?
Obviously I first made a backup of the current database via kodi.
Thanks

ok, after reading various guides on mysql and not being able to understand what to do I let kodi update the database on its own and after 1 hour of work everything was back up and running as before. in fact with version 12 it seems to me that the tv has been reborn because it looks better than before. so now I have 5 machines synchronized with each other.

thanks