Copy Table To Different Host

[Mike Rushton]

When i try to copy a table to a different host i get the following error

Error no 1129

Host 'localhost:localdomain' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'

I am using Enterprise V5.22.

If i use a previous version of sqlyog it works fine.

I am copying between 2 remote hosts so dont see how localhost should be involved

Mike

[peterlaursen]

” When i try to copy a table to a different host i get the following error …”

does that only happen when 'copy to other ..” and else not?

“If i use a previous version of sqlyog it works fine.”

Please tell exact what version works!

Let me guess that you are tunnelling  to one or both servers?

If so you connect to MySQL from 'localhost' (form the webserver or SSH-daemon)

Another possibily is that you use SSH-tunnel and SSH-host is different from MySQL host.

If SSH-forwarding fails then it might try to connect to 'localhost' (the SSH-host).

If this is what you do please try 5.23 beta1.  We fixed an issue with forwarded SSH connection and 'copy to other'.

Please describe your connection setup in detail (screenshots are good, but 'fake' the details!)

Actually all connection code is more or less rewritten in 5.23 beta1 – and better I think. So please try it.

 

Actually you can log on as 'root' from 'localhost' (there is always one connection saved for him!) and FLUSH HOSTS.

Also a SQLyog tunnelled connection should work for this (as – again – you connect to MySQL from 'localhost' with a tunnelled connection)

[Mike Rushton]

peterlaursen wrote on Jan 24 2007, 01:35 PM:

” When i try to copy a table to a different host i get the following error …”

does that only happen when 'copy to other ..” and else not?

“If i use a previous version of sqlyog it works fine.”

Please tell exact what version works!

Let me guess that you are tunnelling to one or both servers?

If so you connect to MySQL from 'localhost' (form the webserver or SSH-daemon)

Another possibily is that you use SSH-tunnel and SSH-host is different from MySQL host.

If SSH-forwarding fails then it might try to connect to 'localhost' (the SSH-host).

If this is what you do please try 5.23 beta1. We fixed an issue with forwarded SSH connection and 'copy to other'.

Please describe your connection setup in detail (screenshots are good, but 'fake' the details!)

Actually all connection code is more or less rewritten in 5.23 beta1 – and better I think. So please try it.

Actually you can log on as 'root' from 'localhost' (there is always one connection saved for him!) and FLUSH HOSTS.

Also a SQLyog tunnelled connection should work for this (as – again – you connect to MySQL from 'localhost' with a tunnelled connection)

You are correct, I am using SSH tunnelling on both sites.

I have tried 5.23 beta1 and can confirm all is now working OK

Thanks

[Author]

Posts