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)
How to export data (only data) from prod to qa mariadb
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: How to export data (only data) from prod to qa mariadb
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.
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.
Regards,
Suwandy
-----------------
Kisaran - Indonesia
Suwandy
-----------------
Kisaran - Indonesia
-
- Posts: 2431
- Joined: Mon Jul 02, 2012 12:24 am
- Location: Ulaanbaatar, Mongolia
Re: How to export data (only data) from prod to qa mariadb
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.
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.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: How to export data (only data) from prod to qa mariadb
Thank you Mark!