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
select into outfile ... fields terminated by '\t' will save rows (not table schema) to file (TSV or whatever you decide)
mysqldump should save schemas + data for the specific table if you use this syntax: mysqldump -u... -p... mydb t1 > mydb_tables.sql
Keep in mind you would need enough disk on master agg to run these commands. No - it doesn’t save local to each leaf, like any other query it is run and returns all results/saves on the aggregator from which you run the query.