How to export data (only data) from prod to qa mariadb

swiftinitpvtltd

I want to export data (only data) from prod to qa mariadb/aware im.
I see there is export options in heidisql, is it possible to just do export of data (I can select master tables) and then dump it into QA?
I do not want to overwrite any tables schmea, just plain master data(there is no BO relationships)

cishpix

Yes, it's possible.
I always use HeidiSQL to export/import data from one DB/server to other DB/server. You just need to set what you want to export.

customaware

This is the best tool I have ever found.....

https://www.dbsofts.com/

Much better than Navicat and others.

I now use it exclusively for moving data around either locally or to/from production servers and test database.

Awesome.

swiftinitpvtltd

Thank you Mark!