That wouldn’t work, as @wbeard52 wrote the Kodi import/export is only for within Kodi.
phpmyadmin only could import data that is in database/table format.
Ok so how do i export/import the database into mariadb step by step would be good.
If you’ve already set up your advancedsettings.xml to point to your mariadb install, just go into Kodi and import, should be in the same place where you exported.
Outside of the initial MySQL/MariaDB database setup you do everything in the same way as if your using a normal Kodi install. As ActionA pointed out this Kodi import is what you want and there is a wiki for that…
thanks i have followed the gude from here [Wiki] Install and configure mysql server and clients - #27. but unable to see my libary in phpadmin
Well as I wrote in that thread getting root access depends on where you install phpmyadmin. Anyhow that should not impact your importing via Kodi. Suggest you upload your logs after trying to import your database via Kodi.