My suggestion, if you just want to move data between the 2 servers, is to
mysqldump to a file, scp the file to the destination server and then mysql
filename to get it into the second server. You can't do it under
programmatic control but it will work and your data will remain secure in
MySQL servers??
Stefen
From: Cal Evans [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Stefen Lars [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: [PHP] Secure MySQL connections in PHP with 'stunnel'
Date: Mon, 29 Apr 2002 10:31:00 -0500
My suggestion, if you just want to move data between
You may also look at SSH port forwarding, this allows you to create an
encrypted tunnel between the two machines, then you connect to the local
port, the data gets encrypted sent across the wire and decrypted at the
destination.
Look at -L in your ssh man or search google for ssh tunneling
On Mon, 29 Apr 2002, Stefen Lars wrote:
However, I am interested in learning how to connect directly to the MySQL
port, as in a second step of the project I am working on, various data from
various servers will be handled. The 'dump to a file' approach, while fine
in my little example
At 11:48 AM -0400 29/4/02, SHEETS,JASON (Non-HP-Boise,ex1) wrote:
SERVERA (master)
/usr/local/sbin/stunnel -f -P/tmp/ -c -d 3308 -r SERVERA:3307
Shouldn't this end with -r SERVERB:3307
i.e. you listen on port local:3308 and forward to SERVERB:3307
SERVERB then listens to local:3307 and
5 matches
Mail list logo