Export data from a table

Question

Hi,

I have a table with 45 millions from a mysql DB, i want to export those data in a .csv format, what is best way to do without affecting existing performance of other tables (when this operation is performed)?

Thanks.

Answer 1

Ok i figured it out,

to export ->select * into outfile 'c:/tmp/outfile.txt' fields terminated by ',' from tablename;

To Import

LOAD DATA LOCAL INFILE 'c:/tmp/outfile.txt' INTO TABLE newtablename FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';