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 username -p testpass -h localhost -P 3307 prefix_testdb
then do a command like
mysql -p -u username database_name < c:\folder\test.sql
this command did not work.
How can I acheive this?