NOTE: I'm in the UK, Prod server is in Australia.
OS: CentOS 5.6
Table targeted content: 1.446.810 rows
SQL Query on local server into CSV: 2 min 6.96 sec - CSV file size: 631 MB
Zip CSV file: 40 secs - zipped file size: 16 MB
File transfer: 40 secs
File extraction: 10 secs
RELOAD SPEED TEST:
Reload via SQL query: More than 20 min
Reload using the CSV file: 1min 30secs
CSV transfer method: TOTAL=4m 7secs !!!
SQL LOAD : more than 20 min
WINNER: CSV transfer