DB Names in Copy DB dialog

[damonp]

Using 4.0B5 trying to copy db to another host/db. Pulldown appears to list db by dbname – user@host.

When using ssh tunnel with root@localhost can't tell tables with the same name on different hosts cannot be distinguished.

ie:

Code:

tablename – root@localhost
tablename2 – root@localhost
…

I tried changing one of the connections to use the true hostname, host.domain.com but the pulldowns still show root@localhost.

1. Can the pulldown be changed somehow to show more info?

2. Can the display be fixed so they show the true connection string instead of all showing root@localhost ?

Thanks a bunch

damonp

[peterlaursen]

I'm sorry but I'm very confused about your writing.

Please answer to questions:

Q1:

1) do you want to copy from one remote server to another

or 2) from localhost to a remote server ?

“true connection” as far as I'm concerned is “localhost” on “localhost” …

Q2

1) do you use the DB … copu Database to different host/DB

or 2) Tools .. database syncronization wizard ?

… if 1) where do you get the ssh tunnelling function from

… if 2) don't you get dialogues like these pics

[peterlaursen]

and this one

[damonp]

I'm not using the sync wizard. Right click on db name in the explorer pane, say copy db to different host/db. The pulldown in the middle of that box is what I am referring to.

Yes most times it should techincally be localhost to localhost (if using ssh tunnel), but in that pulldown, that doesn't give you enough info pick the correct host and db if db names are the same on different hosts.

Changing one ssh tunnel setting to use the FQDN doesn't get updated in the pulldown, still shows localhost. That itself should be a bug shouldn't it? The other is a feature change that would make the system more usable.

damonp

[peterlaursen]

yes I thought so too .. just wanted to be quite sure that I'd got it right!

attached pict. is what I get for m the pull-down-box

Actually in this case the DB accessed from localhosted andd over the web fron URL deepeter.dyndns.dk is the very same database … Still I can copy a DB from localhost to deepeter.dyndns.dk successfully! Maybe it travels round the globe 🙂

Are you are logged on to both servers ?

You write “When using ssh tunnel with root@localhost” . Why tunnel on localhost? You have direct access to localhost.

And how do you do that, actually ? the ssh tunnnneling function is not in the “copy DB” functionality.

“Tunnelling” means accessing the phpadmin program on a Mysql server, so you won't have to have direct connection to the mySQL server itself.

[peterlaursen]

And one point more.

You can copy a DB anywhere you want and to any webserver. But that DB won't work with MySQL on that server (it will just be a set of files! and there a not even beautiful to lo at like pictures 🙂 )

You must either (if you want to use sqlyog)

1) use the database syncronisation wizard and connect to an existing DB recognized by a running MySQL server

2) or export the DB as an SQL-script and run that script locally on the server using PHPAdmin or equally functioning program

If that was a trivial fact for you, I apologize!

It's goodnight here now!

have a nice weekend

Peter

[damonp]

I'm tunnelling to two different _remote_ servers.

When using ssh tunnel, I set _my_ ssh user/pass in the ssh portion of the tunnelling.

I set one mysql connection to root@localhost and the other to root@FQDN. (two _different_ remote hosts but I have root permissions setup to work both ways for this test)

My pulldown shows _all_ connections to be root@localhost.

1. Why?

2. Shouldn't the pulldown be able to show some distinctions between connections. If you ssh tunnel 2 hosts with root@localhost MySQL login _and_ they have the same db names, how do you tell the databases apart.

[damonp]

peterlaursen wrote on Oct 22 2004, 10:28 PM:

You can copy a DB anywhere you want and to any webserver. But that DB won't work with MySQL on that server (it will just be a set of files! and there a not even beautiful to lo at like pictures 🙂 )

Now I'm confused. 🙂

So the copy command I am using is working at the file level and not through MySQL?

Thanks for the comments

damonp

[peterlaursen]

correction: “webserver” should be “datadir belonging to a MySQLserver” of course. But we are just so used to thinking of MySQL as something powering a webserver. But it could be a corporate database or anything …

[peterlaursen]

Better think it over now .. i'm getting tired!!

I'm not quite sure about copying .. it might work if you have the privileges.

But one thing's for sure. if you are working with two remote servers NONE is localhost!

Connect to both using their URL …

[peterlaursen]

I'm messing things up – of course it works through MySQL. I've just been working with the Sync. agent recently and was in another world …

Try this:

1) Cancel the popupscreen when the program starts.

2) Then connect to the severs individualy from file .. connect (use tunnelling if you need/like).

3) you may cascade the windows belonging to each server …

4) And the you should be able to Copy or Sync and all the program offers …

If you want to use HTTP-tunneling the SQLyogTunnel.php – file (from sqlyog directory) should be copied to the server (THAT would be a web server) and it is the URL to that file that should be entered as the connection URL.

If have no experience with SSH-tunnelling – sorry

You ran into trouble because of your use of your subsstituion of a remote server with localhost. That made the program behave unpredictably. by the way: I there a MySQL server running on your local machine right now ?

[damonp]

Yes there is a MySQL daemon running on my local machine, but I'm not connecting to it. It has different db names so its easy to tell I'm not mucking that up.

My understanding of SSH tunnel, the only place requiring the _remote_ FQDN is in the SSH connection. Once on the box via SSH, that becomes my new frame of reference so I am technically conecting to user@localhost. Depending on your settings the FQDN or 127.0.0.1 might also work once you are on that box via SSH.

If I am wrong in this, please correct me, but thats the way I've understood SSH tunneling with other apps.

I did finally RTFM to find out if you were doing multiple SSH tunnels in a single session, specify a different local port number to keep them separate. That helped with my other problem (in a separate post).

I checked my old copy of the competition's app and they do host/db to host/db transactions by referencing the name of the connection in the connection dialog instead of the connection settings (user@host). That way if you name the connections something similar to the hostname, its a no brainer to keep them straight.

Using your pulldown screen cap above as an example, mine only shows half of the entries because all show root@localhost for the connection setting even though one is connection is root@localhost and one connectoin is [email protected]. The duplicates get dropped. I am 99% sure I am connected to two different boxes, because one has all 40 db's and the other only has the 8 I have successfully copied over at the moment.

Note: The only reason one was set to be root@FQDN (ie. [email protected]) was to try to get the pulldown to differientiate the hosts.

I hope I'm making more sense now.

What version are you using?

thanks

damonp

[peterlaursen]

If that was a question for me, I can tell that I use Mysql 4.1.6 locally. My webhotel operates a 4.0.of-some-kind right now I think .. My sqlyog version is 4.0 B5.

The picture that showed my “drop-down-box” was quite a tricky one. The Internet domain dyndns.dk is a domain where you can have a subdomain for free. Mine is deepeter.dyndns.dk, and it points to the ip of my local machine. Thus I was able to simulate a copy operation from localhost to a server, although it really was copying from localhost over the internet back to the samme MySQL-installation on my local machine. Tunneling of either kind was not active. And since you were using the term “localhost” I thought that was an illustration of a situation similar to yours. But I didn't imagine/realize that SSL could influence that. I've been using the “copy DB” quite extensively without tunnelling and also somewhat with HTTP-tunneling but didn't realize the difference to your “project”.

I was quite confused by your original question, so I might have spread this confusion to the forum and to you. Sorry for that.But since nobody else had answered your question for a couple of days I decided to ask the inital questions just in order to clarify the question. And don't ask me to correct anything about SSH-tunneling. I know practically nothing about it! And by the way – why do you (have to) use it ?

Is your dropdown-box OK (show DB's from both servers) if you do NOT use SSH-tunnelling ? It should be!

And I do think you have a point in that “by referencing the name of the connection” a lot of confusion could have been avoided in this case. With the transition from sqlyog from 3.x to 4.x maybe the “copy DB” should have a facelift. And there could be a drop-down-box showing active connections …

[Ritesh]

This is a bug with SQLyog.

While adding up server names in the drop-down combo, SQLyog does not consider SSH connections. It will be fixed in BETA 6.

[Ritesh]

The bug has been fixed in SQLyog Enterprise 4.0 BETA 6.

For more information check out: http://www.webyog.com/forums/index.php?act…&st=0#entry3840

[Author]

Posts