Data Export and Import from One database to another Database


#1

Hi
wanted to understand what is the bes tway of exporting the data from one Database(one cluster) and import into another database (another) cluster.

I see there is mention about mysqldump utilities, is that the only option? I believe this utility will not come with MemSQL installation


#2

Do you mean moving from one MemSQL cluster to another? Or between two different databases?


#3

Hi

I am referring the movement from one cluster to another cluster. Say from QA cluster to Dev Cluster
looking for
–> exporting table(s) from source cluster/DB
–> importing table(s) to target Cluster/DB


#4

It really depends on your scenario. In addition to mysqldump, take a look at:

Replication:

SELECT INTO OUTFILE:

LOAD DATA:

MemSQL Pipelines:

And see this post about backup/restore:

https://www.memsql.com/forum/t/migrate-memsql-including-all-dbs-tables-views-users-from-one-cloud-to-another/214