Cultivate Web Design Melbourne – Development Blog

LOAD DATA LOCAL INFILE '/home/chris/members.csv' INTO TABLE members_new FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (lastname, firstname, dob);

Trust needs to be setup between two servers using public/private keys for this to work.

mysqldump -p click_mail_com | ssh chris@server2.com   mysql click_mail_com