SSH dropping out

[Edward Ludlow <eludlow at btinternet dot com>]

I have data on a remote mySQL server that to edit, I have to SSH port 
forward to.

On Windows boxes, I use Cygwin to achieve this, by running:

ssh -L 3306:mysqlserver:3306 -N user@server.com

Obviously then prompted for a password.

This works fine, except that once connected, if there's no communication 
with the mysql server for a certain period of time (sometimes < 5 
minutes, other times > 20 mins) the connection drops.

Is there a way, from within the same batch script used to make the SSH 
connection, to send a packet of data, or something similar, every minute 
so that the connection will be kept alive?

This can be infuriating if writing a long query or entering data!

Many thanks,
Ed Ludlow

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/