With a normal installation SQLyog will (since version 6.06) not write its configuration file ('SQLyog.ini') as well as the 'favorites' folder and the local SQLite databases used for some advanced client-side fetures (auto-complete, column-width persistense in GRIDs etc.) to the installation folder, but to user's 'AppData' folder. This is required when running on Windows Vista and higher if the Windows UAC ('User Account Control') feature is turned on. With this feature turned on even an 'administrator' user will normally not be allowed to write to the 'Program Files' folder tree. Instead Windows will - in case of changes to the files - 'virtualize' - ie. write to a special 'virtualized' folder. This will cause mismatch and confusion as multiple and different copies of the same file would exist on the system - and the most visible ones would not be used.
Since version 8.13 SQLyog supports a -dir parameter. The -dir parameter tells where SQLyog will look for and create files that are not read-only. This option can be used to specify the path where SQLyog will create these files.
You simply need to specify the filepath (addressed absolutely or relatively to the SQLyog executable) after the -dir parameter. Like
SQLyog -dir"path"
.. to specify the path where SQLyog writable files are stored.
In the particular case where you run SQLyog from a removable drive you will probably not be able to to know in advance the drive-letter of the removable drive. So here you should use relative file paths. If there is \SQLyog folder on the removeble drive and a \SQLyog\Files folder where the files should be, the command to start SQLyog would be simply
SQLyog -dir"Files"
(using relative addressing and assumed that you already cd'ed to the installation folder)
If you don't want to use command syntax but start SQLyog from a program icon then after normal installation (using the installer) you may copy and right-click a program icon/shortcut (on desktop or in start menu) and edit the command from the 'properties' menu.
The -dir switch can also be used if you want to save all SQLyog-related files to an encrypted driver or folder - or if you for any reason want another file position than the default. But note that if you are using Vista or higher and have UAC turned on you should not specify a folder in the 'Program Files' folder tree (or 'Program Files (x86)' on 64 bit Windows).
Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
1 user online | 1 Guest and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (463063 views)
- Error no. 2003: Can't connect... (378721 views)
- SQLyog Version History (231863 views)
- Error no. 1045: "Connection denied..." (192754 views)
- Error No. 2005: Unknown MySQL server host... (174853 views)
- Error no. 1251: "Client does not support authentication..." (163333 views)
- Can I use SQLyog with the WINE Windows emulator ... (155024 views)
- What is HTTP-tunneling? (129780 views)
- What Is SSH and SSH-tunneling? (101240 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (99168 views)
Latest FAQs
- SQLyog Version History (2014-06-08 10:22)
- I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
- About CHUNKs and BULKs (2014-01-09 11:53)
- SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
- Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)
Sticky FAQs
ID #1185
How can I run SQLyog from a portable drive.
Categories for this entry
Tags: -
Related entries:
- SQLyog Version History
- Where can I download old program versions?
- Can I use SQLyog with the WINE Windows emulator on LINUX.
- Does SQLyog GUI understand the meaning of special MySQL KEYWORDS.
- Introduction to the 'SQLyog Job Agent' (SJA)
You can comment this FAQ