SQLyog is a popular MySQL GUI client that can be very convenient for certain operations like quickly dumping a database, schema changes. For operations that are awkward via the command line, it is useful.
I’ve installed SQLyog on my Ubuntu (Hardy Heron) laptop. It was very easy using Wine.
To install SQLyog with Wine
Install Wine on your Ubuntu system using the Synaptic Package Manager. As of this writing, version 220.127.116.11 was current. the exact version of Wine is probably not important.
Download SQLyog from here. I use the community edition. It is not important where you download the installation (Windows EXE) to. Just save the program file someplace convenient that you can easily navigate to via bash in the Terminal.
Open a Terminal window and change to the directory where you stored the EXE installation file. Type:
This is the exact filename that I downloaded. You will probably need to change it to the filename you downloaded.
Follow through the installation process using the standard SQLyog installer. Accept defaults. The program will be installed under a directory in your home directory called .wine.
At the end of the installation, the dialog will allow you to run the program. Go ahead and run it for the thrill of seeing a Windows program run on Linux. Wine is great!
Create a shortcut to run SQLyog in Terminal
I like to run SQLyog from the command line. I could change to the program’s directory and start the program with wine SQLyog.exe. Like this:
cd ~/.wine/drive_c/Program\ Files/SQLyog\ Community wine SQLyog.exe
For convenience, I created a script to start SQLyog just by typing sqlyog. I created a text file called sqlyog with the above two lines and made it executable with chmod +x sqlyog. I have a directory in my $PATH for scripts like this, so I can fire SQLyog from anywhere.
Adding SQLyog to the Ubuntu Applications menu
On my installation of SQLyog, an entry was not made in the Applications menu to launch SQLyog. I added it to Applications | Wine by right-clicking on Applications and selecting Edit Menus. I added a new menu item with the New Menu button. The command to run SQLyog is:
env WINEPREFIX="/home/andrew/.wine" wine "C:\Program Files\SQLyog Community\SQLyog.exe"