It's my understanding that when you specify localhost, the mysql client
program will use the UNIX socket (ie, mysql.sock), and not look at port
information.
cheers,
jenni
Michael Williams wrote:
Hi all,
I'm trying to use "mysqldump" over SSH. I'm pretty familiar with port
forwarding in and of itself, so I doubt that's the issue. No matter
what port I forward (or to where for that matter), "mysqldump" still
connects to the local MySQL server and dumps local data. It's as if it
completely disregards my PORT option. Any ideas?
My commands are as follows:
%ssh -L 8080:localhost:3306 remote_server_ip
%mysqldump -u user_name --port=8080 --compact --quick --all-
databases > dumpfile
Depending on the "user_name" it either fails or dumps my local data.
It doesn't even use --port
Regards,
Michael
--
Jennifer Snyder
Database Administrator
Tribe Networks, Inc.
www.tribe.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
