Import MySQL table from a textfile to a remote host with compression I can import data.sql onto my foreign host with this command:

mysql -u username -p -h foreign-host.example.org -A DATA-BASE-NAME &lt; data.sql


Which works fine for small export files, but I cannot find an explanation how to import a large file, so the transfer will be compressed.
Use the --compress flag.

mysql --compress -u username ...



  --compress, -C
  
  Compress all information sent between the client and the server if both support compression.
  
  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_compress


Virtually any MySQL client and server will support compression.