Google

Friday, April 13, 2007

Navicat - MySQL Web GUI interface


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