Tag Archives: sqlyog

How to Export SQLyog Saved Connections Software & Sites 23 FEB 2013

I make heavy use of the fantastic SQLyog MySQL GUI tool for managing all of my MySQL databases. Of course, every time I change my primary work PC, it is a pain to have to recreate all of my Saved Connections all over again.

Luckily it turns out that there is technically a way to copy all these saved connections over to your new machine. First, you need to locate a file called sqlyog.ini on your system. Older versions used to store this file in the installation folder, but newer versions tend to have it in your user profile (‘AppData’) folder.

In my case, I found the file located in C:\Users\Craig Lotter\AppData\Roaming\SQLyog.

Grab this file and head over to your new machine. Locate its version of sqlyog.ini and replace it with the file you copied from your old machine. Fire up SQLyog and you should now have all of your Saved Connections available to you.

Nifty.

Download SQLyog Community Edition CodeUnit 11 MAY 2011

SQLyog is an exceptionally good GUI Management Tool for MySQL databases and is well worth the purchase price if you develop and maintain a large number of MySQL databases. It is developed by Webyog and comes in three main flavours, namely Professional, Enterprise and Ultimate. However, if you are a single developer working on your own and pretty much a shoestring budget, then you’ll be happy to know about the existence of the fourth, most importantly FREE flavour of the excellent SQLyog, the Community Edition.

Now no longer available (or even mentioned) on the main Webyog website any more, locating the free Community Edition download can be a little tough if you don’t know where to look, hence this blog post. A little while ago it was decided by Webyog to spin off the Community Edition as an open source Goo06gle Code project, located at http://code.google.com/p/sqlyog/.

This means that the installer download for SQLyog Community Edition is now located at http://code.google.com/p/sqlyog/downloads/list.

Grab it, take it for a test drive and you definitely won’t look back. Seriously, if you work on a Windows box, then kiss phpMyAdmin goodbye! :)

Related Link: http://code.google.com/p/sqlyog/downloads/list