HeidiSQL as an alternative to SQLYog

Yesterday, I transferred my Wordpress blog from my local computer to the web server. I encountered this error from SQLYog after exporting my database which says that "SQLYog is getting terminated." I'm not sure what causes this, but I'm sure it's because of the installation process since I made my portable version of SQLYog. Exporting other databases and using the root user result to the same error.

I used an alternative SQL GUI to export my database (and it worked successfully), although I could have done it using MySQL command-line. HeidiSQL has a clean interface, and it provides the basic features SQLYog has. It even has some search and replace feature, and is generally customizable.

Update (Jan 25, 2010): The error "SQLYog is getting terminated" shows due to my attempt in making the SQLYog portable. The SQLYog support answered me in the forum. The shortcut should contain the absolute path like: C:\SQLyog\SQLyogCommunity.exe -dir"C:\SQLyog\data" rather than just: C:\SQLyog\SQLyogCommunity.exe -dir "data"

This fix works, and I'm still using SQLYog, although I remember using HeidiSQL in recovering my database from pieces of binary files.