[SQL] Import a local SQL File To MySQL on a Remote Server Using SSH Tunnel

I have a connection between my localhost and a remote server using putty SSH tunnel.

Thats fine.

Now I need a command to get the sql file on my local machine i.e. c:\folder\test.sql and import it into mysql on the remote server

I thought maybe...

mysql -u prefix_username -p testpass -h localhost -P 3307 prefix_testdb


then do a command like

mysql -p testpass -u prefix_username prefix_testdb < c:\folder\test.sql


this command did not work.

How can I acheive this?

Continue reading...