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

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

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

Post by 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
Posts: 183
Joined: Fri Nov 06, 2015 5:07 am
Location: Indonesia

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

Post by 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.
Regards,

Suwandy
-----------------
Kisaran - Indonesia
customaware
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

Post by 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.
Cheers,
Mark
_________________
AwareIM 6.0, 8.7, 8.8, 9.0 , MariaDB, Windows 10, Ubuntu Linux. Theme: Default, Browser: Arc
Upcloud, Obsidian....
Image
swiftinitpvtltd
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

Post by swiftinitpvtltd »

Thank you Mark!
Post Reply