webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.19k stars 322 forks source link

Exporting a saved connection leads to an invalid exported file #2320

Closed sibwy closed 9 months ago

sibwy commented 1 year ago

In a peculiar case (at the bottom), SQLyog writes an incorrect 'connection id' to the 'SQLyog.ini' file.

SQLyog reports an 'Invalid file' error on importing the file containing the saved connection with the corresponding incorrect connection id exported to a file from the 'Tools' menu.

Test Case to create an entry in the 'SQLyog.ini' file with incorrect 'connection id':

  1. Stop SQLyog. Rename the existing 'SQLyog.ini' file
  2. Start SQLyog
  3. Create a new connection
  4. It will display "New Connection" in the 'Name' field of the 'New Connection' dialog -> Click on the "OK" button.
  5. Now, click on the 'New Connection' in the drop-down combo box and rename the connection name in the combo box to empty (by pressing the 'delete' button).
  6. Click on the "Yes" button in the popup asking "Do you want to save changes?"

The user report can be found in SF: 00997295

sibwy commented 9 months ago

Fixed in SQLyog v13.2.1