Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Copy Table To Different Host

forums forums SQLyog SQLyog: Bugs / Feature Requests Copy Table To Different Host

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #23292
      peterlaursen
      Participant

      ” 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)

    • #23293
      Mike Rushton
      Member
      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

Viewing 1 reply thread
  • You must be logged in to reply to this topic.