v17 Migrate SQL DB from MariaDB to MySQL
#1
I organized my pool of Kodi installation referring to a common DB based on MariaDB, hosted by QNAP NAS.
Now I wish to migrate into a MySQL DB hosted by Windows 10 server.

Is there any detail I have to take care of ?

My intention is:
1) dump MyVideos107 schema from Maria DB. only data with no Function-Triggers-Events option.
2) start a Kodi instance connected to the new blank MySQL DB, in order to define schema and Tables structure.
3) import previous dump into new MySQL DB

For some reason kodi hangs when connect the MySQL DB.

Someone expert has any sudgestion ?
Reply
#2
Importing the dump, if made properly, will create the schema. So 2) shouldn't be necessary.
If I have helped you or increased your knowledge, click the 'thumbs up' button to give thanks :) (People with less than 20 posts won't see the "thumbs up" button.)
Reply
#3
Thanks nickr, I read better the WIKI and solved the issue:
I installed last version of MySQL server where 5.5.42 is required.

Now I successed to transfer DB from NAS to Windows.

Bye, Luca.
Reply

Logout Mark Read Team Forum Stats Members Help
Migrate SQL DB from MariaDB to MySQL0