Import dump Sql in Wappler Docker

[Marzio]

With Wappler I set up and configured some Docker / Hetzner sites configured with mySql database.
I would like to transfer some tables with their contents to the new database by taking them from the mySql database of the old site
I cannot use Navicat, as the old database server does not allow a direct connection, but I can export a * .sql file
How do I go about importing it?
And do I have to import it into the local development database or the production target database?
Is there a tutorial for this?
Thanks

[George]

See:

Clone (update latest changes) in new remote DB in DB Manager on new remote Docker

Well if you have all the changes from the beginning it should really work. Everything is kept. Otherwise you can do a docker db backup ( from the toolbar) and copy the generated sql from the .wappler/targets/your_dev_target/init_db To .wappler/targets/your_live_target/init_db And then clean and redeploy the live servers Maybe we can find a better way to do full db structure synchronization in the future, when not all changes are available and you just want exactly the same structure to depl…

[Marzio]

There aren’t many tables that I have to import.
To simplify the operation, I could easily add (in the Wappler / Docker database) the new desired tables with the fields exactly the same as the tables to be imported.
At this point I would have a perfect but empty database, and the need would be to be able to populate the tables with files exported from the old database, in one of the available formats.
Is this a possible operation with Wappler?

[revjrblack]

Any resolution on your attempt to import sql to populate db using the database manager?

[Marzio]

I imported the database with Navicat and therefore manageable by Wappler Database Manager