I am currently trying to set up an SSH tunnel from one server to another and am having difficulty, never done this before. Anyway there are two servers one is a production web server and the other is a test server. The idea is to get hourly updates of the mysql database to the test server from the production server via replication. The test server will then be used for local backups and a few other things.
First things first I am trying to get the ssh tunnel working so I can test out mysql replication. From the test server i run:
ssh -fNg -L 4000:127.0.0.1:3306 email@example.com
and after asking for myuser's password it gives me:
bind: Address already in use
I really don't know what it's referring to. Any thoughts?