Why and How

1. I must use WINE to install SQLyog CE 64 bit
2. I have a 64 OS
3. I want to use wine64-development apt install wine64-development
4. I don’t want to install al lot of packages related to 32 bit architecture (wine32)

Download Unpack and Run

Visit https://github.com/webyog/sqlyog-community/wiki/Downloads and download the latest version.

In my case: SQLyog-13.1.7-0.x64Community.exe

check the file metadata information

file SQLyog-13.1.7-0.x64Community.exe

# SQLyog-13.1.7-0.x64Community.exe: PE32 executable (GUI) 
# Intel 80386, for MS Windows, Nullsoft Installer 
# self-extracting archive

Notice that this is a PE32 32bit executable (application/x-ms-dos-executable)
, but I do not have wine with 32 architecture installed.

The PE32 format stands for Portable Executable 32-bit, while PE32+ is Portable Executable 64-bit format.

But in this case the file is a self-extracting archive.

So? …easy unpack with 7zip and see… apt install 7zip-full

7z e SQLyog-13.1.7-0.x64Community.exe

you will get a lof of file… lets' check the executable ones.

file *.exe

# SQLyogCommunity.exe:  PE32+ executable (GUI) 
# x86-64, for MS Windows

Bingo! It’s PE32+ executable

now just run it with wine 64bit

wine64-development SQLyogCommunity.exe