I've been using SQLyog for years now on my PC. When I switched to a Mac I had to install Parallels so I could boot up XP and use SQLyog because I can't stand PHPmyadmin.
So I tried installing SQLyog today and setting up my db connections. However, I ran into a problem when both of my connections required ssh tunneling. the first connection would work fine, but then when i closed the connection to the first db on one server, and then tried to connect to the db on another server, i got errors. i even tried switching connections, doing the second one first, and the first one second. it didn't seem to matter which one i connected to first, the second one always failed. my theory is that the program is getting confused and tries to log into the second server with the first server's credentials, therefore the passwords are incorrect. its almost as if their are 'session' like variables that aren't getting cleared.
anyways, i stumbled upon Navicat today looking for SQLyog help on Google. its great, i can even do transfers from one db to another db, even when they are on different servers. with webyog (or PC's) you couldn't do it because only one ssh connection is allowed at a time. in fact, while i am writing this i am transferring all my db from one to another with no problems.
It's a bit pricey, but i'm glad to finally found a mac solution to webyog, who has promised for a while to come out with a mac version but has not done so yet.
Link: Navicat for Mac OSX
2 comments:
unfortunately navicat for mac has weaknesses also. there are many of us lusting for a native Mac version of the webyog product.
yeah, i was hesitant to switch from webyog as well - i've been using it for years.
but, all the servers i was connecting to required ssh tunneling and whenver i tried to switch from one connection to another, webyog would give access errors - i think it was still trying to connect to the old connection i just logged off of using the new credentials.
i don't, it was getting too buggy for me - plus, i had to install parallels on my mac just for that application.
i haven't had any problems with navicat so far and find it much more powerful than webyog. especially when it comes to transferring data btn databases, even when they are on 2 different servers.
thanks for posting on my blog : )
Post a Comment