Hello.


mysqldump connects to the local host by default  though the Unix socket..

Add -h127.0.0.1 to its options.





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

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to