working with remote hosts …

[peterlaursen]

I notice when working on two remote hosts (or just two DB's on the same remote host) from a third computer running SQLyog (my local machine) commands like “copy table…” or the SJA uses my local machine as some kind of “relay” for the data transfers.

Could it be possible to have some sort of daemon running at the “source”-server that connects to the “target”server so that the computer running SQLyog will only control the daemon but not take part in data transfer. At least I believe it could be implemented with PHP (would then require PHP-support). But maybe there are other options.

When working over Asymmetric DSL (with slow connection in one direction) and fast servers that would be a real improvement!

I know it is a long-tern request!

[CalEvans]

By definition, SQLYog is a client. Therefore the behavior you describe is normal. In moving database between 2 servers using a client, the client has to bring all the data down to itself and then send it to the target server.

Yes, it would be possible to create some kind of server piece that would do this but since we already have one (mysqldump) it would seem to be impractical to create another. Also, as someone who manages web servers for a living, I would not allow it to be installed on any servers. Too much of a security risk.

The easiest way to do what you are talking about is to ssh into one of the boxes and issue the proper mysqldump command.

Ok, now that I've thought it through, if SQLYog knew your ssh credentials (which it does in the case of a tunnel) this would be possible without having to install a server piece. (which means it's must more likely to be doable) the same code that builds the tunnel could also simply issue a mysqldump over ssh. Assuming perfect conditions (and the stars are aligned) this would work.

IMHO,

=C=

[peterlaursen]

1) I'm not allowed to use ssh with one of the servers involved.

2) I want to work with a GUI-client – thats why I use SQLyog.

I perfectly know that SQLyog is a client. What I imagine is ANOTHER client running in the server environment and which can be CONTROLLED or at least INITIATED by Sqlyog

[peterlaursen]

BTW – then SQLyog HTTP-tunnelling file is probably a “client” too then ??

The two servers involved are the one at my DNS-provider (that offers med 10 MB diskspce totally (for webdocuments, mail and DB's) and a supplementary hosting provider that ofers me 300 MB. With NEITHER of them I'm allowed to connect to the MySQl-port.

So I don't see how I can use your suggestions !? I have the choice of PHPmyAdmin or SQLyog (or some few other clients offering more primitive tunnelling possibilities then YOG does)

And especially when copying one table from one DB to another DB at the SAME server it seems somewhat ridiculous to generate a lot of traffic on the internet. But it works perfectly!

[Shadow]

MS and the creators of Total Commander were able to create such feature, so it is absolutely not impossible. In fact it is a good idea, but in tunneled environment a rather tough job to accomplish. I would start by modifying SQLyog's tunneling PHP script…

[Author]

Posts