[bryan11]

Thanks much for all your help, Shalmali!

I made a backup of my sqlyog.ini, removed Sqlyog from my system completely, and installed it again on the portable drive. After that, I placed a copy of the sqlyog.ini in the installation location.

I edited the shortcut to run Sqlyog to be this: “C:UsersbryanDocumentsPortableAppsSQLyogSQLyogCommunity.exe” -dir “C:UsersbryanDocumentsPortableAppsSQLyog”

One thing to note is that I had to shorten the installation path to only “SQLyog”. Without that, the path to the shortcut's target field was too long.

If you inatall things this way, Sqlyog runs perfectly with the Portableapps.com launcher and everything needed is in one directory.

[bryan11]

I think the space character was an issue. I also switched to Windows 7, so here's the command that works:

“C:Program Files (x86)SQLyog CommunitySQLyogCommunity.exe” -dir C:UsersbryanDocumentsPortableAppsSqlYogPortable

Note that the sqlyog.ini is normally in c:/users/bryan/appdata/Roaming/Sqlyog/.

I hope you do create a fully portable version of Sqlyog. where the application data and config files are all in one location.

Thanks much for your help with this.

Bryan

[bryan11]

No luck. It still runs and uses the sqlyog.ini from the Application Data directory.

I'm running Sqlyog by opening a DOS window at the location where Sqlyog is installed, then entering one of these commands:

C:Program FilesSQLyog Community>”C:Program FilesSQLyog CommunitySQLyogCommunity.exe” – dir C:Documents and SettingsbryanMy DocumentsPortableApps.comPortableAppsSqlYogPortable

C:Program FilesSQLyog Community>”C:Program FilesSQLyog CommunitySQLyogCommunity.exe” – dir “C:Documents and SettingsbwelchMy DocumentsPortableApps.comPortableAppsSqlYogPortable”

The quotes around the target directory don't seem to be needed or affect behavior of sqlyog, but those around the first part are needed or I get the error “'C:Program' is not recognized as an internal or external command,operable program or batch file.”

[bryan11]

When I run this: SQLyogCommunity.exe -C:Documents and SettingsbryanMy DocumentsPortableApps.comPortableAppsSqlYogPortable

it does create a new, blank sqlyog.ini in the PortableApps directory. However, it still uses the sqlyog.ini in C:Documents and SettingsbryanApplication DataSQLyog. To verify this, I added a new host in SqlYog and exited and only the sqlyog.ini in C:Documents and SettingsbryanApplication DataSQLyog was updated. If I delete the sqlyog.ini there, it creates a new, blank one at that location, also.

Next, I deleted the SQLYog executables from the portableapps directory and left only the files from the Application Data directory. Here's the command I used to run SQLYog from the normal, installed location and use the new sqlyog.ini file:

“C:Program FilesSQLyog CommunitySQLyogCommunity.exe” – “C:Documents and SettingsbryanMy DocumentsPortableApps.comPortableAppsSqlYogPortable”. Again, it used the sqlyog.ini from the Application Data directory instead of the one specified.

No matter what variation I try, it uses the sqlyog.ini in the Application Data directory. What's going wrong here?

[Author]

Posts