Softpedia >Mac >Internet Utilities >Navicat for MySQL >  Changelog

Navicat for MySQL Changelog

What's new in Navicat for MySQL 16.3.7

Apr 16, 2024
  • Bug-fixes:
  • Modified data types were not retained when switching to other tables in Import Wizard.
  • Incorrect json array index syntax was generated when transferring MySQL tables.
  • Unable to connect using ssh agent in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.6 (Feb 21, 2024)

  • Bug-fixes:
  • Crashed when presenting dashboard in some cases.
  • Unable to change data types when creating tables.
  • Focus moved to the upper level after deleting an object in Navigation Pane.
  • Some labels disappeared after adding the chart to the dashboard.
  • Unable to display proportion percentages in the chart axis.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.5 (Feb 21, 2024)

  • Bug-fixes:
  • Unable to load indexes in MariaDB Table Designer.
  • Crashed when closing Server Monitor.
  • The percentage values shown in the chart were incorrect.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.4 (Dec 12, 2023)

  • Bug-fixes:
  • Crashed when opening Navicat on older macOS versions.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.3 (Dec 12, 2023)

  • Bug-fixes:
  • Column widths were not retained when opening tables/views.
  • Crashed when scheduling batch jobs in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.2 (Nov 7, 2023)

  • Bug-fixes:
  • COMMAND-F shortcut did not work in the main window.
  • Refresh button did not work in Server Monitor.
  • Text in the Search box was hidden in some cases.
  • Advanced options in Structure Synchronization cannot be displayed.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.1 (Oct 30, 2023)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.0 (Oct 17, 2023)

  • Improvements:
  • Support setting MySQL descending primary key.
  • Bug-fixes:
  • Crashed when transferring large tables using SSH connection.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.9 (Sep 21, 2023)

  • Bug-fixes:
  • Crashed on macOS 14.
  • MariaDB Triggers were transferred multiple times during Data Transfer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.7 (Aug 29, 2023)

  • Bug-fixes:
  • Beautify SQL incorrectly added spaces between the function name and parentheses.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.6 (Aug 29, 2023)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.5 (Jul 14, 2023)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.3 (Jun 21, 2023)

  • Bug-fixes:
  • Copy and paste shortcuts did not work in Navigation pane.
  • The focus jumped to the top level after renaming an object in Navigation pane.
  • Table tree loading issue in Navigation Pane.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.2 (Jun 9, 2023)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.1 (Jun 9, 2023)

  • Main New Features:
  • Support sequence design for MariaDB.
  • Show fields, indexes and more under tables in Navigation Pane.
  • Minor bug fixes and improvements.
  • Navicat for Redis is released.

New in Navicat for MySQL 16.1.10 (May 31, 2023)

  • Bug-fixes:
  • High CPU usage when using SSH connection.
  • Unable to save the schedule changes.
  • TAB key did not work when adding field.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.9 (Apr 18, 2023)

  • Bug-fixes:
  • Crashed when opening Preferences in some cases.
  • Crashed when importing database to model in some cases.
  • Crashed when saving table after changing field comment.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.7 (Mar 2, 2023)

  • Bug-fixes:
  • Memory utilization issue.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.6 (Mar 2, 2023)

  • Bug-fixes:
  • Unable to backup if database folder did not exist.
  • Unable to load cloud connection info when opening data transfer profile.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.5 (Dec 12, 2022)

  • Bug-fixes:
  • Default value did not show when adding new records.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.3 (Sep 29, 2022)

  • Bug-fixes:
  • Unable to enter Enum values in MariaDB table designer.
  • Query Builder did not recognize the selected fields.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.2 (Aug 31, 2022)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.1 (Aug 21, 2022)

  • Bug-fixes:
  • Unable to open the objects in the "Find in Database" window.
  • Cannot show query errors when using HTTP tunnel.
  • Crashed when renaming a connection in a group.
  • Cannot show the new group unless Navicat was restarted.
  • Checks were not imported when using "Reverse Database to Model".
  • Unable to sort columns in table viewer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.0 (Jul 21, 2022)

  • Main New Features:
  • Support OceanBase Community Edition.
  • Support Trend Line for several chart types.
  • Support adding On-Prem Server with URI.
  • Allow skip preview of changes in data sync.
  • Enhanced responsiveness and performance.
  • Improved UI/UX.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.14 (Jun 15, 2022)

  • Bug-fixes:
  • Query parameters did not work in some cases.
  • Function group creation issue.
  • Hanged when updating records in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.13 (May 10, 2022)

  • Bug-fixes:
  • Chart title display issue.
  • Query listing issue when loading cloud queries.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.12 (Mar 28, 2022)

  • Bug-fixes:
  • Crashed when opening a table in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.11 (Mar 16, 2022)

  • Bug-fixes:
  • Add/Delete Foreign Key issue in ER diagram.
  • "Show bar labels" setting cannot be saved in Charts.
  • Crashed when moving a connection from Navicat Cloud to My Connections.
  • Crashed when running Automation in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.9 (Mar 1, 2022)

  • Bug-fixes:
  • Crashed when using table viewer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.8 (Mar 1, 2022)

  • Bug-fixes:
  • Auto completion did not work when inputting ENUM value in the table viewer.
  • Crashed when closing Navicat in some cases.
  • Hanged when designing table.
  • Unable to scroll through the fields with the mouse wheel in Query Builder.
  • Duplicate options in the user Plugin dropdown menu.
  • Connection coloring did not work on subtabs.
  • Crashed when importing invalid json files.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.7 (Jan 13, 2022)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.6 (Jan 3, 2022)

  • Bug-fixes:
  • Data Transfer failed when using HTTP tunnel.
  • Line numbers disappeared when scrolling in Query Editor.
  • Crashed when mapping MySQL and MariaDB fields in Data Synchronization.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.5 (Dec 15, 2021)

  • Bug-fixes:
  • Connection encoding issue in Navicat Cloud.
  • Crashed in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.3 (Nov 23, 2021)

  • Main New Features:
  • New Data Generation Tool
  • Enhanced Charts Feature
  • Support of Navicat On-Prem Server
  • Additional Features:
  • Connection Profiles
  • Field Information Pane
  • Query Execution Summary
  • Navicat On-Prem Server is released
  • Many other new features and improvements

New in Navicat for MySQL 15.0.32 (Nov 14, 2021)

  • Bug-fixes:
  • Crashed when running scripts in some cases.
  • Crashed when copying records in some cases.
  • The TEXT pane did not retain when running queries.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.30 (Aug 20, 2021)

  • Bug-fixes:
  • Unable to show the cursor when editing TEXT data using Form View in Dark Mode.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.29 (Jun 29, 2021)

  • Bug-fixes:
  • Differences were incorrectly detected when synchronizing MySQL table structures.
  • Crashed when running query in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.28 (May 3, 2021)

  • Bug-fixes:
  • Unable to update data in some cases.
  • Crashed when using Data Transfer in some cases.
  • Exporting JSON field didn't handle NULL and integer values properly.
  • Cursor did not focus to the Search box after pressing CMD-F.
  • Crashed when selecting the "Group by Object Type" in Structure Synchronization.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.26 (Mar 8, 2021)

  • Bug-fixes:
  • Unable to read grid data in Dark mode.
  • Unable to sort the last column by clicking the column header in Table Viewer.
  • Duplicate entry error occurred when editing the pasted records.
  • Hanged when starting Navicat in some cases.
  • "Different primary key type" error occurred when synchronizing MySQL data.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.25 (Jan 15, 2021)

  • Bug-fixes:
  • 'Primary key needs to be integer' error occurred when synchronizing data.
  • Unable to show the ENUM items list in Table Viewer.
  • Unable to sort by clicking the column header in Table Viewer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.24 (Dec 16, 2020)

  • Improvements:
  • Set the values of a column to NULL.
  • Bug-fixes:
  • Crashed when saving MariaDB Views.
  • The modified dates of backup files were incorrect.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.22 (Oct 12, 2020)

  • Improvements:
  • Prompt to change the MariaDB password when it expired.
  • Bug-fixes:
  • Unable to show the granted privileges if the database name contained wildcard characters.
  • Only the last selected table was printed when printing multiple tables.
  • The SQL Editor was flickered and repainted when saving the query.
  • "Auto Increment" and "Unsigned" options were removed after adding another field.
  • Crashed when using Query Builder on Big Sur.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.21 (Sep 15, 2020)

  • Bug-fixes:
  • The "Set Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
  • The field size was incorrect in Form View.
  • Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
  • The "Encoding" setting was not stored when the connection was synchronized to Navicat Cloud.
  • "Dump SQL File" stopped running in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.20 (Aug 4, 2020)

  • Bug-fixes:
  • Unable to set the encoding of MariaDB connection.
  • Unable to connect MySQL server when using TLSv1.2.
  • Schedule did not trigger when using Navicat App Store version.
  • The "Close Database" option in the context menu was dimmed when a query tab was focused.
  • The entire connection tree was collapsed when searching.
  • Crashed when deleting a data source in Charts.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.18 (Jun 23, 2020)

  • Improvements:
  • Improvement on resizing Information pane.
  • Bug-fixes:
  • Negative default value displayed as "-" in MariaDB.
  • No records were imported in some cases when Import Wizard displayed "Finished Successfully".
  • Wrong SQL generated for CAST function when switching between Query Editor and Query Builder.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.17 (Jun 5, 2020)

  • Bug-fixes:
  • Unable to show full table names in the Data Synchronization window.
  • Field names in the Join dialog were truncated.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.16 (May 18, 2020)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.15 (May 6, 2020)

  • Bug-fixes:
  • Jumped to the first record when refreshing in Form View.
  • Unable to synchronize data to MySQL 8.0.19.
  • Unable to connect AnalyticDB.
  • The list of the reference tables for foreign key was empty in Model.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.14 (Apr 16, 2020)

  • Bug-fixes:
  • The state of the pane in model was not retained.
  • Field count was missing in Table Designer.
  • Crashed when opening Console.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.12 (Mar 23, 2020)

  • Bug-fixes:
  • "9015: Error Moving Error" error occurred when using Navicat Cloud.
  • Crashed when clicking the Next button without choosing a target database in Data Transfer.
  • Unable to show the whole Trial Reminder dialog.
  • Crashed when editing/composing new queries in some cases.
  • Invalid XML error occurred when importing connections.
  • Crashed when starting Data Transfer in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.11 (Feb 28, 2020)

  • Bug-fixes:
  • Console was missing in Standard eidtion.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.10 (Feb 28, 2020)

  • Bug-fixes:
  • Crashed when using Data Transfer in some cases.
  • Inserted records to the target server when transferring views.
  • CPU usage was high when using Query Builder.
  • Unable to open the main window when starting Navicat.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.8 (Jan 16, 2020)

  • Bug-fixes:
  • Crashed when starting Navicat.
  • Dates before 1900 were exported as numeric values when exporting to Excel.
  • The Search feature did not work properly in the Data Transfer window.
  • Icon and text were not aligned well in the Navigation pane
  • The unchecked "Includes anonymous system profile" option was reverted to check after restarting Navicat.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.7 (Jan 6, 2020)

  • Bug-fixes:
  • Crashed when starting Navicat.
  • Crashed when running Data Transfer in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.6 (Dec 24, 2019)

  • Bug-fixes:
  • Unable to run selected query in some cases.
  • Crashed when using Data Transfer.
  • Unable to show which database is active.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.4 (Dec 23, 2019)

  • Bug-fixes:
  • Data Synchronization options were unable to save in profile.
  • Auto Layout feature separated notes and labels from layers.
  • Unable to copy SQL query from Process List in Server Monitor.

New in Navicat for MySQL 15.0.3 (Nov 25, 2019)

  • New Charts
  • Advanced Data Transfer
  • Brand new Query Builder
  • Enhanced Data Modeling Tool
  • Dark theme UI and Diagram
  • Many other new features and improvements

New in Navicat for MySQL 12.1.27 (Oct 16, 2019)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.26 (Oct 9, 2019)

  • Bug-fixes:
  • Unable to change the Settings Location path of Navicat Cloud connections.
  • A red exclamation mark was incorrectly displayed on the Navicat Cloud query icon.
  • "Add Object Privileges" UI issue when using Dark Mode.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.25 (Sep 17, 2019)

  • Bug-fixes:
  • Unable to search in menu bar / Help.
  • Unable to show the database list when there was more then 255 databases.
  • Data Transfer process was stopped in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.24 (Jul 24, 2019)

  • Bug-fixes:
  • Unable to list users for MariaDB 10.4.
  • List View was not retained in the main window after restarting Navicat.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.23 (Jun 12, 2019)

  • Unable to transfer views from MySQL to MariaDB.
  • Crashed when running query in some cases.
  • Unable to use the Add Privilege button.
  • Connections moved out of the group after editing.
  • Crashed when editing model in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.22 (May 24, 2019)

  • Bug-fixes:
  • Empty tables were created when importing .accdb file.
  • Run Selected option did not run all highlighted text when using shortcut to select the SQL.
  • SSH connection dropped issue.
  • Unable to retain selected columns in Foreign Key Selection window.
  • Data Synchronization data grid UI issue in Dark Mode.
  • Data Synchronization inserted values into Generated Columns.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.20 (Apr 18, 2019)

  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.19 (Apr 17, 2019)

  • Bug-fixes:
  • Error occurred when connecting to MySQL 4.0.
  • Missing "Tools" menu when running an infinite loop in Console.
  • Crashed when comparing databases in Structure Synchronization.
  • Crashed when saving models.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.18 (Mar 21, 2019)

  • Bug-fixes:
  • Grid View and Form View menu options were flipped.
  • "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
  • The row height of the object list did not match the font size.
  • Column order was incorrect when importing database to model.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.16 (Feb 26, 2019)

  • Improvements:
  • Enter the datetime value directly in the Filter.
  • Bug-fixes:
  • Crashed when opening a database in some case.
  • If the filter value box was opened, Navicat window disappeared when switching to another App.
  • Crashed when using Find feature after updating the data.
  • Crashed when code completion was triggered in large query.
  • Freeze when entering/exiting Full Screen.
  • Selected connection, database and schema names were missing in Data Transfer window.
  • 1146 error occurred when duplicating MySQL 8.0 functions.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.15 (Feb 26, 2019)

  • Bug-fixes:
  • Unable to search the grouped queries unless the group was selected.
  • Crashed when using Find in Database/Schema if the connection was not opened.
  • Field comment font color issue when using Dark Mode.
  • SSH key file reselect issue when opening connection in App Store version.
  • Crashed when creating a project.
  • Beautify SQL feature wrongly split text which started with numbers.
  • Row highlight issue when using Dark Mode.
  • Crashed when opening Datetime picker window in Table Viewer.
  • Unable to show line number in SQL Editor on macOS 10.14.
  • Code Folding did not work properly in SQL Editor on macOS 10.14.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.13 (Feb 26, 2019)

  • Bug-fixes:
  • Crashed when opening Navicat if logged in Navicat Cloud.
  • Unable to connect using SSH private key in some cases.
  • Hanged when saving Procedure/Function.
  • Crashed when clicking Views in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.12 (Nov 22, 2018)

  • Bug-fixes:
  • Mojave's Dark Mode did not display properly.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.11 (Nov 22, 2018)

  • Bug-fixes:
  • Stored procedures was not exported properly when using Data Transfer.
  • Import Wizard was slow in some cases.
  • "Connection is in use" message prompted when restarting Navicat if connection password was not stored.
  • Crashed after Navicat was opened in a few minutes.
  • Crashed when showing Navicat Cloud Agreement.
  • Crashed when synchronizing data in MariaDB System Versioned Tables.
  • Unable to copy data from Table Viewer.
  • Code Completion did not work properly in some cases.
  • Inputted text was not displayed when renaming objects on Navigation Pane in Mojave's Dark Mode.
  • Unable to list the batch jobs in some cases.
  • Connection/Database did not open when dragging tables into it.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.10 (Nov 22, 2018)

  • Bug-fixes:
  • "" tag was repeated twice when exporting HTML file.
  • Definition was missing when dumping Views and Functions.
  • Crashed when starting Navicat in some cases.
  • Foreign key data selection did not work.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.9 (Nov 22, 2018)

  • Bug-fixes:
  • HTML export did not specify charset.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.8 (Nov 22, 2018)

  • Bug-fixes:
  • Available Jobs list did not sort alphabetically in Automation.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.7 (Aug 29, 2018)

  • Bug fixes:
  • Crash occurred when adding export profile to a batch job in some cases.
  • Navicat got hanged when viewing SQL Preview in new function.
  • Crash occurred when saving new function.
  • Sync User Name with Navicat Cloud option in SSH tab did not work properly.
  • Unable to scroll horizontally in the comparison step of Data Synchronization.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.6 (Aug 23, 2018)

  • Bug fixes:
  • COMMAND-N new object shortcut did not work.
  • Not Null checkbox state was wrong in Table Designer.
  • Crashed when creating new connection in some cases.
  • Import Target and Field Mapping changed after changing the source file in profile.
  • Syntax error occurred when transferring MySQL ARCHIVE engine tables.
  • Crashed when closing window in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.4 (Aug 3, 2018)

  • Bug fixes:
  • Unable to map fields in Import Wizard.
  • New Query shortcut and menu item did not work.
  • Crashed when clicking New Query button in some cases.
  • Crashed when typing in Query Editor in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.3 (Jul 26, 2018)

  • Support Roles for MySQL 8
  • Support Roles for MariaDB 10
  • Brand new Filter Wizard
  • UI and UX Improvement
  • MongoDB is added in Navicat Premium
  • Navicat for MongoDB is released

New in Navicat for MySQL 12.0.28 (Jul 13, 2018)

  • Bug fixes:
  • Unable to rename table with double-click in some cases.
  • Sorting Rows column on the Objects tab did not work properly.
  • Command-W shortcut did not close the active window in some cases.
  • Some menu items were missing in Table Designer.
  • Export Wizard did not add a leading zero to pad days and months to two digits.

New in Navicat for MySQL 12.0.27 (Jun 7, 2018)

  • Improvements:
  • Ability to copy comparison results of Model.
  • Added thousand separators to the row count on the table objects list.
  • Bug Fixes:
  • Crashed when opening Navicat if invalid characters were used for the paths in Preferences.
  • The generated CREATE PROCEDURE statement was incorrect when dumping database to SQL file.
  • Unable to execute Navicat commands using Automator.

New in Navicat for MySQL 12.0.26 (May 10, 2018)

  • Improvements:
  • Supported to connect MySQL 8 using SHA2 connection.
  • Supported coloring the Objects tab when a colored connection is selected.
  • Improved table mapping in Import Wizard.
  • Improved keyboard navigation with tab key in Import Wizard.
  • Bug Fixes:
  • Left single quotation mark was wrong style when inputting in Form View.
  • Extra "(" was added to INSERT statements when deploying scripts in Data Synchronization.
  • Objects list loading was slow in some cases.
  • Zero decimal place digits were not displayed in Table Viewer.

New in Navicat for MySQL 12.0.25 (Apr 24, 2018)

  • Bug Fixes:
  • Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
  • Crashed when starting Navicat.
  • Unable to edit query results when tables had alias.
  • Exported files were not attached to the notification email.
  • Procedure Parameters was missing when synchronizing structure.
  • Unable to filter connections in the Navigation Pane.
  • Profile icons did not have indicator after adding attachments in Batch Job.

New in Navicat for MySQL 12.0.24 (Mar 29, 2018)

  • Bug Fixes:
  • Unable to copy error messages in Query.
  • Database name was added to the query when using Query Builder.
  • XML file data was not imported to JSON fields completely.
  • Unable to edit data in Query result set in some cases.
  • Adjusting the height of split screen in Table Designer was not allowed.
  • Crashed when selecting or editing Procedure SQL in Query Editor.
  • Incorrect SQL was generated when changing Primary Key name in Table Designer.
  • Query column width reset after restarting Navicat.
  • Memory leak issue.
  • "Fields" and "Referenced Fields" values were vanished after saving and moving cursor to another Foreign Key.
  • Field properties were not shown when adding a field in Table Designer.
  • Incorrect field name were shown when moving a field in Table Designer.
  • UI issue in Full Screen mode.
  • Exported Excel files were corrupted in some cases.

New in Navicat for MySQL 12.0.23 (Feb 25, 2018)

  • Improvements:
  • Supported Microsoft Azure Database for MySQL.
  • Bug Fixes:
  • Unable to open Console if a non-tabbed window was opened in font.
  • Navicat hanged when refreshing table grid after changing field names.
  • Navicat process was unable to terminate.

New in Navicat for MySQL 12.0.22 (Jan 22, 2018)

  • Bug Fixes:
  • Error occurred when synchronizing structure in some cases.
  • Exported Excel files were corrupted in some cases.

New in Navicat for MySQL 12.0.21 (Jan 15, 2018)

  • Bug Fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.0.20 (Jan 11, 2018)

  • Bug Fixes:
  • Unable to open a table twice.
  • Running multi-statement SQLs with delimiters issue.
  • Crashed when adding default value in Table Designer.
  • Crashed when clicking the Server Privileges tab in User Designer.
  • Find feature in Table Viewer was not function correctly.
  • Target object name was garbled when copying object named with non-ascii characters.
  • Crashed when executing SQL to insert emoji to table.
  • Crashed when performing Data Transfer in some cases.
  • Navicat hanged when executing scripts in Data Synchronization.
  • Unable to hide the Information pane permanently in Query.
  • Preferences settings reset when Navicat started.
  • Unable to stop query when using SSL connection.

New in Navicat for MySQL 12.0.19 (Dec 1, 2017)

  • Bug Fixes:
  • Result tab was focused when explaining query.
  • Query Plan result column was too narrow in Query.
  • "t" character was appended to the end of the row when copying data to text / Excel file.
  • Unable to map fields in Import Wizard.
  • Dump SQL File process was slow.
  • Create new table wrongly when importing to existing table in some cases.
  • Use old user to connect after changing new user name in Connection window.
  • Unable to import decimal values when data has thousand separator.
  • Crashed when searching on different pages in Table Viewer.

New in Navicat for MySQL 12.0.18 (Nov 13, 2017)

  • Bug Fixes:
  • The database/schema combo-box did not work in Query.
  • Manual refresh did not work in Server Monitor when auto-refresh was enabled.

New in Navicat for MySQL 12.0.16 (Oct 17, 2017)

  • Bug Fixes:
  • Syntax error occurred when creating MariaDB triggers in Table Designer.
  • Unable to commit the same query twice.
  • Unable to create the second filter by using context menu.
  • Unable to reload or reopen tables after connection was timeout.
  • Navicat hanged when opening large BLOB data in Hex Editor.

New in Navicat for MySQL 12.0.15 (Oct 11, 2017)

  • Bug Fixes:
  • Save dialog prompted even no changes made in Table Designer.
  • Query Builder loading was slow.
  • Unable to execute query in some cases.
  • Data synchronization crashed when HTTP connection was used.
  • Unable to export views on High Sierra.

New in Navicat for MySQL 12.0.14 (Sep 26, 2017)

  • Bug Fixes:
  • Error occurred when creating virtual columns in MariaDB Table Designer.
  • Table Designer UI improvements.
  • Font settings in Preferences reset to default after restarting Navicat.
  • SQL Formatting was missing in the Triggers tab of Table Designer.
  • Unable to delete fields in Table Designer.
  • View Builder button was missing in View Designer.
  • SSH connection hangs issue.
  • Objects list loading was slow.
  • Automation did not work when the profile name contained spaces.
  • Syntax error occurred when filtering with ' character in Table Viewer.
  • Unable to run DELIMITER $$ statements in Query.
  • Navicat hanged when using normal OS user account.
  • Duplicate Entry error occurred when importing with Append/Update mode.
  • Sync Username to Navicat Cloud option was missing in Connection form.
  • Navicat hanged when connection was cut off.

New in Navicat for MySQL 12.0.13 (Sep 11, 2017)

  • Bug fixes:
  • Auto increment field was ignored when importing
  • Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
  • Error occurred when connecting to MariaDB in some cases.
  • Navicat hanged when running a query export profile in some cases.
  • Crashed when viewing or editing Functions.
  • Code completion displayed unrelated items.

New in Navicat for MySQL 12.0.12 (Aug 25, 2017)

  • Bug Fixes:
  • Replace All did not work in Table Viewer.
  • Wrong row was inserted to when selecting foreign key value in Table Viewer.
  • Memory error occurred when transferring tables.
  • Suggested wrong table columns in code completion list.
  • Context menu UI issue in some cases.
  • Tables displayed as NEW in Import Wizard even it is already existed.
  • Slow issue occurred when using code completion.
  • Server name was missing in the window title bar of Console.
  • Unable to add tables/views to Query Builder.

New in Navicat for MySQL 12.0.11 (Aug 8, 2017)

  • Bug Fixes:
  • Crashed when executing query in some cases.
  • Failed to sort by Modified Time, Created Time or Data Length in Detail view.
  • Launching Import Wizard was slow.
  • The month and day values were transposed when importing Date fields.
  • Copy/Paste context menu was missing in Table Viewer.
  • Crashed when creating new query without selecting a connection in Navigation pane.
  • Unable to stop multiple processes in Server Monitor.
  • Number of running processes was missing in Server Monitor.
  • Table mapping was not in alphabetic order in Data Synchronization.
  • Crashed when adding records in Table Viewer.
  • Exported file name did not add timestamp when using Automation.
  • Wrong SQL was generated for function in Structure Synchronization.
  • In-App Purchases did not stay activated after restart the app.

New in Navicat for MySQL 12.0.10 (Jul 26, 2017)

  • Crashed when exporting query result in some cases.
  • Unable to show time values in Timestamp fields in Table Viewer.
  • Lost focus when inputting auto increment value in Table Designer.
  • Incorrect values displayed in MySQL "Data Length" column in Detail View.
  • Table list was not sorted in Export Wizard.
  • Backup object list in the Objects tab was not refreshed after finishing backup.
  • Progress bar did not update when importing.

New in Navicat for MySQL 12.0.9 (Jul 15, 2017)

  • Bug Fixes:
  • Unable to copy SQL in the bottom navigation bar of Table Viewer.
  • Crashed when pasting SQL in Query Editor.
  • Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting.
  • End Process item in the context menu was disabled in Server Monitor.
  • Syntax error occurred when transferring MySQL data.
  • Incorrect field names were shown in code completion suggestion list.

New in Navicat for MySQL 12.0.7 (Jul 4, 2017)

  • Bug Fixes:
  • Unable to restore in some cases.
  • Query Table shortcut was missing in Table Viewer.
  • Foreign Key's reference database was not changed after transferring to other database.
  • Crashed when launching the application.
  • Unable to set range in Schedule Setup.
  • SSH password was not imported when upgrading to Navicat 12.
  • Memory leak issue in SQL Editor.
  • Current active server/database was not selected when using CMD-Y shortcut to open New Query window.
  • Syntax error occurred in Data Transfer.
  • Sorting by modified/create date did not work for details view in main window.
  • Unable to copy and paste data in Table Viewer.

New in Navicat for MySQL 12.0.6 (Jun 27, 2017)

  • Bug Fixes:
  • Shift-Option-Arrow did not work for selecting a word in SQL Editor.
  • Command-R did not refresh the list when database was selected.
  • Unable to resize window in some cases.
  • Unable to type some characters in editor when using international keyboard.
  • Unable to sort the object list in the main window.
  • Unable to log in Oracle server using lower case username.
  • Exporting data with commas to CSV file issue.

New in Navicat for MySQL 12.0.5 (Jun 16, 2017)

  • Bug Fixes:
  • Crashed when exporting large query results.
  • Connection name was missing on the tab of Table Viewer.
  • Crashed when exporting query results to CSV file.
  • Query prompted for inputting the same parameter for every occurrence.
  • Unable to accept Terms and Conditions when first login Navicat Cloud.

New in Navicat for MySQL 12.0.2 (Jun 6, 2017)

  • New Features:
  • New UI/UX.
  • On Startup: open favorite tabs automatically when Navicat launches.
  • Code Snippet.
  • Advanced Code Completion with better suggestions.
  • Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
  • Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
  • New Automation: easy to find desired profiles and create automated batch jobs.
  • Responsiveness and performance improved.
  • Many other new features and improvements.

New in Navicat for MySQL 11.2.18 (May 5, 2017)

  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.17 (Mar 1, 2017)

  • Bug fixes:
  • Failed to move procedures to a virtual group.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.16 (Dec 19, 2016)

  • Bug Fixes:
  • Unable to show errors when running query in some cases.
  • Failed to import JSON files in some cases.
  • Query Editor window has disappeared when it lost focus.
  • Some options were wrongly displayed in Essentials Edition.
  • Settings Location was wrongly copied when duplicating connection.

New in Navicat for MySQL 11.2.15 (Oct 24, 2016)

  • Bug Fixes:
  • The default date time format and delimiter of Export Wizard did not follow Import Wizard.

New in Navicat for MySQL 11.2.14 (Aug 31, 2016)

  • Improvements:
  • Added some common keyboard shortcuts.
  • Bug Fixes:
  • Failed to transfer tables when enabled "Convert object name" in Data Transfer.
  • Crashed when opening Query view in some cases.
  • Crashed when running backup tasks in Batch Job.

New in Navicat for MySQL 11.2.13 (Aug 8, 2016)

  • Bug fixes:
  • Crashed after exporting in some cases.
  • Crashed when importing files with long field name.
  • Failed to run "LOAD DATA LOCAL INFILE" statement in Query Editor.
  • Column titles was unable to display properly in Form view when using large font size.
  • Crashed when deleting tables with relations in Diagram view.

New in Navicat for MySQL 11.2.12 (Jul 5, 2016)

  • Improvements:
  • Support utf8mb4 Character Set in MySQL and MariaDB connections.
  • Support smart quotes in Query Builder.
  • Bug Fixes:
  • Progress bar did not update in Data Transfer.
  • Unable to expand connection tree in some case if the corresponding tab was not selected.
  • Crashed while working with a profile in a virtual group.
  • Unable to perform data synchronization using command line.
  • Crashed when inserting record with RAW mode in Table Viewer.
  • Failed to move multiple objects into a virtual group by right-click menu in Navicat Cloud connections.

New in Navicat for MySQL 11.2.11 (Apr 29, 2016)

  • Bug fixes:
  • Crashed when opening or closing Navicat Cloud database in some cases.
  • Unable to beautify SQL keywords to upper case in Query Editor.

New in Navicat for MySQL 11.2.10 (Mar 30, 2016)

  • Bug fixes:
  • Fixed the column order issue when using Copy As Insert/Update in Table Viewer.
  • Unable to insert empty string to fields with date time types if import date is empty since MySQL 5.7.
  • Failed to close the parameter window after opening in Function Designer.
  • App Store Essentials version: Failed to keep the "Show Object List" state in Query.

New in Navicat for MySQL 11.2.9 (Mar 9, 2016)

  • Bug Fixes:
  • Functions were removed after editing the query in Query Builder.
  • Unable to remember the file path if the path contains space in Export Wizard.
  • Model History pane showed many changing color histories in some cases.

New in Navicat for MySQL 11.2.8 (Jan 28, 2016)

  • Bug Fixes:
  • Background color of keyword "SUM" did not change with non-white background in Query Editor.
  • Auto-completion did not work for 1 char alias in Query Editor.
  • Extra database name was added when drag and drop a table to Query Builder.
  • Crashed when creating backup in Cloud connections.
  • Unable to create MySQL Enum column in Table Designer.
  • Crashed when double-clicking the "Find in Database" result in some cases.
  • Queries with "JOIN" was not parsed correctly in some case in Query Editor.

New in Navicat for MySQL 11.2.7 (Jan 14, 2016)

  • Bug Fixes:
  • Wrongly added extra " char in the exported data when the data contained " char.
  • Unable to open the Find result in "Find in Database".
  • Unable to change the field order by dragging in the SELECT tab of View Builder.
  • "Show Result" setting of Query was not saved immediately.
  • Unable to disable the folding setting of Query Editor in Preferences.
  • Crashed when double-click to select the query and run selected.
  • User Name and Host were empty when duplicating a MySQL user.
  • Crashed when loading server preferences from preference.plist file on launching Navicat.
  • Unable to open the saved import profile.
  • The http tunneling script was using the mysql extension of PHP which did not work in PHP 7.
  • Unable to show [] with black background in Query Editor.
  • Shortcuts CTRL-A, CTRL-E were missing in Query Editor.

New in Navicat for MySQL 11.2.6 (Dec 28, 2015)

  • Bug Fixes:
  • Adding multiple relations issue in Model's Table Designer.
  • Unable to uncheck the "Limit records per page" box in Table Viewer.
  • Crashed when pasting SQL to Query Editor.
  • Error occurred when saving views after applying Beautify SQL.

New in Navicat for MySQL 11.2.5 (Dec 23, 2015)

  • Bug Fixes:
  • Unable to save the "Show Object List" option in Query.
  • There was no syntax highlight in the SQL Preview tab.
  • Unable to show the cursor in Query Editor with black background.
  • Failed to drag and drop connection in some cases.
  • Smart quote issue in Query Editor.
  • Font issue in Query Editor.
  • Find feature issue in Query Editor.
  • Unable to copy more than 30 rows in Table/Query Viewer.

New in Navicat for MySQL 11.2.2 (Dec 10, 2015)

  • MAJOR NEW FEATURES:
  • Navicat Cloud Collaboration:
  • Create/Modify/Delete projects.
  • Add members to project for sharing connection settings, queries and models.
  • View Project Activity Log.
  • Data Modeling Tool:
  • Support Model Conversion.
  • Support Views.
  • Enhanced Table Designer.
  • Others:
  • Enhanced Filter Wizard.
  • Enhanced Query Designer.

New in Navicat for MySQL 11.1.17 (Nov 18, 2015)

  • Bug fixes:
  • Failed to log in Navicat Cloud in some cases.
  • Crashed when running Structure Synchronization.

New in Navicat for MySQL 11.1.16 (Nov 3, 2015)

  • Bug Fixes:
  • Unable to copy backup files to another database by drag and drop method.
  • Crashed when running Data Transfer more than once on OS X 10.11.
  • Froze when operating Table Viewer with longtext data.
  • Crashed when running stored procedures on OS X 10.11.
  • Crashed when adding password using MD5 function in Table Viewer Raw mode.
  • Crash when running SQL multi times in Console.
  • Unable to set the default value of the bit type in Table Designer.

New in Navicat for MySQL 11.1.15 (Sep 16, 2015)

  • Showed wrong database in Connection Tree.
  • Execute SQL file did not output errors in some cases.
  • Lost local connections after Navicat crashed during synchronizing to Navicat Cloud.
  • App Store version: In-App Purchase did not work in Mac OS X 10.11.

New in Navicat for MySQL 11.1.14 (Aug 4, 2015)

  • Improvements:
  • Supported format strings in Schedule email body.
  • Bug Fixes:
  • Unable to send notification email in Schedule.
  • Created a new connection when previewing a view.
  • Unable to change the case of the backup file name.
  • Failed to synchronize Row Format when creating MySQL tables in Structure Synchronization.
  • Lost connections in some cases.

New in Navicat for MySQL 11.1.13 (May 21, 2015)

  • Bug Fixes:
  • Crashed when importing connections.
  • Crashed when reversing database to model.

New in Navicat for MySQL 11.1.12 (Apr 25, 2015)

  • Bug Fixes:
  • Object List tab did not change when selecting nodes from connection tree.
  • Unable to send email when running batch jobs using Command Line.
  • Failed to save the order of connections in Navicat Cloud.

New in Navicat for MySQL 11.1.11 (Mar 27, 2015)

  • Bug Fixes:
  • Unable to edit BLOB field's text data on TEXT editor.
  • Unable to use CMD-Y New Query shortcut after selected Tables, Views, etc nodes on Connection Tree.
  • Failed to create/edit users for MySQL 5.7.6.
  • Failed to run schedule for connections in Navicat Cloud.
  • Cursor did not focus on Query Editor when opening a query.

New in Navicat for MySQL 11.1.10 (Mar 13, 2015)

  • Bug Fixes:
  • Wrongly showed MySQL/MariaDB TEXT fields with collation xxx_bin as BLOB fields in Table Viewer.
  • Fixed import DBF file with empty datetime value issue.

New in Navicat for MySQL 11.1.9 (Feb 6, 2015)

  • Improvements:
  • Added the ability to copy column name with data and copy records as Insert/Update statements in Query/View Result.
  • Bug Fixes:
  • Fixed the time interval setting issue in Schedule.
  • Fixed the multi-headers issue when exporting multi SELECT query to XML file.
  • Fixed the warning issue when renaming query.

New in Navicat for MySQL 11.1.8 (Feb 6, 2015)

  • Improvements:
  • Added the ability to copy column name with data in Table Viewer.
  • Bug Fixes:
  • Crashed in SSH re-connection.
  • Fixed the smart quotes/dashes issue in Query Builder.
  • Fixed the data type issue when importing xlsx in Import Wizard.
  • Fixed the creation of database/schema issue when no target database/schema name provided in Data Transfer.

New in Navicat for MySQL 11.1.7 (Dec 16, 2014)

  • Improvements:
  • Show popup message if errors occur during dumping tables/databases/schemas to SQL file.
  • Bug Fixes:
  • Crashed when using "Reverse Database to Model" feature.
  • Crashed when the connection between server and client is disconnected.
  • Unable to scroll on long query.
  • Unable to re-send Navicat Cloud verification email.
  • Result set scrolled to line 2 after executing the query in OS X 10.10 .

New in Navicat for MySQL 11.1.6 (Dec 2, 2014)

  • Improvements:
  • Supported copy data as INSERT/UPDATE statements in Table Viewer.
  • Bug Fixes:
  • Wrongly changed field type varchar(400) to BLOB for MySQL version 5.0.4 or above in Data Transfer.
  • Editing data was not allowed sometimes in Table Viewer TEXT editor for MySQL/MariaDB.
  • Failed to transfer MySQL tables with trigger in Data Transfer.
  • Error occurred when changing the case of the connection name.
  • Crashed when importing database/schema to Model.
  • Crashed when creating Navicat Cloud account.
  • Wrongly applied "Use smart quotes and dashes" setting in Console.

New in Navicat for MySQL 11.1.5 (Oct 21, 2014)

  • Bug Fixes:
  • Navicat Cloud login checking restriction.
  • The Select/Where/Group By/Having/Order By clasue bar disappeared in Query/View Builder.
  • Connections are moved out from virtual groups after upgrading from version 11.0.
  • Crashed when saving profiles.
  • Failed to import date time field and float number from DBF files..
  • Select fields panel in Table Designer did not update after the table was saved.
  • INT type values were rounded up when importing XLS files.
  • Table Designer view was not displayed corrently in HTTP connections.

New in Navicat for MySQL 11.1.4 (Sep 25, 2014)

  • Improvements:
  • Customized column width and column order in Table Design are saved.
  • Bug Fixes:
  • Failed to run Backup Server jobs for cloud connections in Schedule.
  • Generated wrong query for field name with "." in Filter Wizard.
  • Crashed when removing connection from a virtual group.
  • Unable to save the Word Wrap setting in Table Text Editor.
  • Crashed when creating a new virtual group in fresh installed Navicat.
  • Connection list did not refresh automatically after dragging connections between Navicat Cloud and My Connections.

New in Navicat for MySQL 11.1.00 (Aug 26, 2014)

  • Support to sync selected conntection settings, queries, model files and virtual group information to Navicat Cloud.

New in Navicat for MySQL 11.0.20 (Aug 1, 2014)

  • Bug Fixes:
  • Crashed when adding foreign key under Table Designer in Data Modeling Tool.
  • Crashed when running delimiter statement in Query Viewer.

New in Navicat for MySQL 11.0.19 (Jul 9, 2014)

  • Improvements:
  • Support length of SSH password/private key passphrase increased from 99 to 255.
  • Support to save name with "/" for Connection Save Path, Query, Import/Export/Backup profile, Backup, Schedule, Model, Data Transfer/Synchronization profile.
  • Support syntax "ON UPDATE CURRENT_TIMESTAMP" and default value "CURRENT_TIMESTAMP" for datetime type (since MySQL 5.6.5) in Table Designer.
  • Bug Fixes:
  • Crashed after opening Navicat for long time.
  • Crashed when prompted to input password for SSH connection in Data Transfer, Data/Structure Synchronization and Server Monitor.
  • Reduced the time needed to wait for connection timeout when disconnected to server.
  • Non-ASCII characters not able to show in Hex Editor under Table Viewer.
  • Some operations in main window did not popup error when error occurred.
  • Time in Schedule tab for existing event did not show in Event Designer.
  • When generated update query, identity column did not skip in Import Wizard.
  • Crashed when modifying an error view.
  • Website version: "SSH:Unknown Error!" error occured if doing any further action for SSH connection.

New in Navicat for MySQL 11.0.18 (May 26, 2014)

  • Bug Fixes:
  • Crashed when copied and pasted a new row and committed the changes by clicking the "tick" button in Table Viewer.
  • Export Wizard window did not show up for exporting query results.
  • The title in Console window did not update into newly changed connection name.
  • When typing single/double quote in Console, the quote would be changed into other char that did not recognized by server.

New in Navicat for MySQL 11.0.17 (May 12, 2014)

  • Improvements:
  • Allow drag to reorder field as default in Table Designer.
  • Bug Fixes:
  • Connection password was unable to be saved.
  • The database names were truncated and the right half of the list was completely empty under advanced connections list in Connection Properties.
  • The state of running in full screen was unable to be saved, so that Navicat only started up in window mode.
  • Error message occured while viewing table structure to show the file path.
  • Default value '''' turned into ''' in Table Designer.
  • Disabled the vertical elastic effect to avoid wrong colour drawing for row index < 0 in Table Viewer.
  • When previewed and enabled save queries to file, queries were not correctly written to the file in Data Synchronization.
  • The file and file size position in Model info view were wrong.
  • Crashed when right-clicked on an open area and seleted "Restore Backup".
  • The bookmark setting of saved path was incorrect in Backup schedule.

New in Navicat for MySQL 11.0.16 (Mar 7, 2014)

  • Improvements:
  • Now only column titles of the first result included when exporting multi dataset to the same file using Export Wizard.
  • Bug Fixes:
  • Tab was unable to be dragged and reordered in full screen mode.
  • Crashed when using Find function in Table Viewer.
  • Copy and Paste did not work on tables with auto-incremented columns while saving a record by clicking "tick" icon in the Table Viewer.
  • Crashed after changed the "Use advanced connections" and press "ok" button in Table Viewer.
  • Parameter list not able to show while including CHARACTER type in function parameters in Function Designer.
  • Crashed when selecting a suggested word that required quoting in Scintilla auto completion.
  • Crashed while scrolling table in Query Builder and exited Navicat.
  • int with "." as Thousand Separator did not import correctly in Import Wizard.
  • The datetime format showed in the export profile did not match the format used in the original table.
  • Date and time were exported incorrectly while using a EDT time zone.
  • Message Log was unable to save correctly for the Preview function in Data Synchronization.
  • Table dataset and collation info on CREATE TABLE queries not able to synchronize in Structure Synchronization.
  • When changing a relation's referencing schema, the relation remained in the table but the relation line in diagram was removed under Table Designer in Data Modeling Tool.
  • Crashed when double-clicking the connection tree under Synchronize to Database in Data Modeling Tool.
  • Schedele helper did not work although jobs still run in old version.
  • Website version: Typed in the export queries filepath directly would cause file creation error in Data Synchronization.
  • App Store Essentials version: Crashed when purchasing Code Completion feature without SQL Builder in View Designer.

New in Navicat for MySQL 11.0.15 (Jan 7, 2014)

  • Improvements:
  • Improved connection tree behavior in main window.
  • Bug Fixes:
  • Database name was changed if failed to open it.
  • Popup menu was shown far away when clicking on Diagram View or Model Design in retina display.
  • Crashed when deleting active connection.
  • Crashed when typing single digit in hour/minute/second field and press OK in table viewer.
  • Unable to show error when getting database on open connection.
  • Wrongly transformed MySQL date value in exported file.
  • Crashed when closing the Export Wizard for exporting selected row in Table Viewer.

New in Navicat for MySQL 11.0.14 (Dec 20, 2013)

  • Improvements:
  • Disabled zooming by magic mouse in Query Editor.
  • Bug Fixes:
  • Failed to open table on Mac OS X 10.6.
  • Unable to add view's profile to the virtual group.
  • Unable to duplicate profiles.

New in Navicat for MySQL 11.0.13 (Dec 18, 2013)

  • Improvements:
  • Added shortcut keys for "Save" and "Save As" in Data Synchronization.
  • Enhanced Data Synchronization.
  • Allow to select tag to identify data when exporting table to JSON format.
  • Saved field selection window size in Table Designer.
  • Bug Fixes:
  • Failed to duplicate MariaDB tables with virtual columns.
  • Failed to copy Binary value in Table Viewer for MySQL 4.1.
  • Crashed when running Explain on Mac OS X 10.6.
  • Unable to close Server Monitor's popup dialog in Mac OS X 10.9.
  • Enabled Open button and Restore Backup menu item when no backup profile is selected.
  • Wrongly quoted the value in Export output file.
  • Failed to save connection order in main window.
  • Editor failed to show when first open the Table/View Viewer.
  • Unable to save the resultset's column width after re-run the query.
  • App Store version: Failed to list tables after connected.
  • Website version: Unable to send attachments in Schedule.

New in Navicat for MySQL 11.0.12 (Nov 8, 2013)

  • Bug Fixes:
  • Command-F unable to close the search function in main window.
  • Export Wizard wrongly to get Time Delimiter as Decimal Delimiter.
  • Crashed while printing diagram in Data Modeling Tool.
  • Data Synchronization dialog window stayed opened.

New in Navicat for MySQL 11.0.11 (Nov 6, 2013)

  • Improvements:
  • Compatible with Mac OS X 10.9 Mavericks.
  • Bug Fixes:
  • Crashed on tabbed window.
  • Failed to import JSON file.
  • App Store version: Error on export path during Export Wizard in Mac OS X 10.9.

New in Navicat for MySQL 11.0.10 (Sep 30, 2013)

  • Bug Fixes:
  • Failed to show definition/DDL for View.
  • Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  • Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.

New in Navicat for MySQL 11.0.9 (Sep 11, 2013)

  • Improvements:
  • New tab window control.
  • Bug Fixes:
  • Crash occurred while deleting tables with foreign keys on ER diagram.
  • Options missing in Export profile.
  • Fixed support "," in schedule time setup.
  • The text color in Text Editor did not follow the "Common" colour in Preferences.
  • Corrupt occurred after updating and showing binary type text in Table Viewer.
  • After selected a cell in Table Viewer, cmd + F not able to focus on the search field if search bar was already shown.
  • Failed to update setting controls immediately after guessing the field type from newly added field name in Table Designer.
  • Website version: Failed to show Navicat 10 Import file entries in Navicat 11.

New in Navicat for MySQL 11.0.8 (Aug 7, 2013)

  • Bug Fixes:
  • Default value of date, time, datetime, timestamp type was not quoted for Create SQL in Table Designer and Data Transfer.
  • Error not log during fetching rows in Data Transfer.

New in Navicat for MySQL 11.0.7 (Jul 29, 2013)

  • This version includes a number of bug fixes and some improvements

New in Navicat for MySQL 11.0.5 (Jul 12, 2013)

  • Improvements:
  • Updated libxl to 3.5.3.
  • Adjusted caret color same in Scintilla.
  • Support sorting items by name inside a virtual group.
  • Bug Fixes:
  • SSH connection random crashed.
  • Fixed number of virtual grouping issues.
  • Crashed in Query Viewer.
  • Select/Paste function did not work on the newly added rows in Table Viewer/Query Viewer.
  • Text/Blob Editor in Table Viewer was reallocated the data in selected cell after refreshed.
  • Values did not always change in Table Viewer if modified in Query Viewer.
  • Query not found error occured in Query Favorites feature.
  • Fixed scrolling issue in Store Procedure.
  • Export failed in query result.
  • Crashed in Structure Synchronization.
  • Create table did not work on different source and target version in Structure Synchronization.
  • Fixed auto increment value for create and alter SQL in Structure Synchronization.
  • "Commands out of sync; you can't run this command now" error occured while creating new user with table privileges.
  • App Store version: Error occured when adding images in Data Modeling Tool.

New in Navicat for MySQL 11.0.4 (Jun 11, 2013)

  • HTTP connection did not work properly.

New in Navicat for MySQL 11.0.3 (Jun 7, 2013)

  • Bug Fixes:
  • SSH Public key settings was unable to be saved in duplicate connection.
  • Crashed occurred when deleting objects from ER Diagram view.
  • Crashed occurred when applying filter during the data loading process.
  • Crashed occurred in Query Editor when running an empty query.
  • Progress indicator in Query viewer result kept spinning after rows inserted.
  • Infinite looping in Export Wizard while exporting selected rows.
  • Crashed occurred in Server Monitor while getting the process list.
  • Data model files not opened while they were not saved in default folder.

New in Navicat for MySQL 11.0.2 (May 27, 2013)

  • Bug Fixes:
  • SSH connection would keep asking for public key passphrase even the save passphrase/password was checked.
  • Crashed in ER Diagram when loading and showing diagrams simultaneously.
  • When exported dataset from and unsaved query, the export file name is now marked as "Untitled".
  • Duplicated queries were run when exporting result set in Query Viewer.
  • Crashed occured when closing the Export Wizard after exported the result set in Query Viewer.

New in Navicat for MySQL 11.0.1 (May 22, 2013)

  • Improvements:
  • Improved tab behavior in Navicat main.
  • Reduced memory usage when opening Table Viewer.
  • Support to print and export PDF files with paper size that not available for the printer in Data Modeling Tool.
  • Bug Fixes:
  • Crashed in Table Designer with HTTP connection established.
  • Sorting function did not work properly.
  • Find Next/Previous in Find and Replace function went wrong after drag and drop column.
  • The result range not highlighted in Find function.
  • Blank page appeared in Table Viewer while scrollling down to the end of the page and switching to the last page, when the table contained more than 1000 rows.
  • Links between join tables would lost in Query/View Builder.
  • Query was unable to parse the delimiter properly.
  • Duplicated queries were run when exporting result set in Query Viewer.

New in Navicat for MySQL 11.0.0 (Apr 30, 2013)

  • 64-Bit version
  • Brand New Design
  • Multi-Changes at Once
  • Connection enhancement
  • Stay up to date
  • Smart Find and Replace
  • Oracle Data Pump
  • SQL Server Backup
  • Search objects everywhere
  • Organize your work
  • More Import Formats
  • Enhanced Export Format

New in Navicat for MySQL 10.1.3 (Feb 7, 2013)

  • Bug Fixes:
  • Connection kept opening even the form was closed.
  • Table names in ER Disgram view could not be renamed.
  • Font size in SQL Editors were too large in retina display.
  • Crashed while opening DBF import profile with Field Delimiter = "" in Import Wizard.
  • "Disable foreign key checks" option in Data Synchronization was ignored in Schedule.
  • Stored Procedure failed to catch the returned error message when saving an illegal statements.
  • Definition in Function Designer was unable to return correctly with COLLATE attribute.

New in Navicat for MySQL 10.1.2 (Dec 3, 2012)

  • Some minor bug fixes and improvements

New in Navicat for MySQL 10.1.0 (Jun 15, 2012)

  • Support Unsigned for Numeric Type.
  • Support Auto Increment for Integer Type.
  • Build model with multiple schemas.
  • New wizard "Import from Database".
  • New wizard "Synchronize to Database".
  • Align/Distribute diagram objects.

New in Navicat for MySQL 10.0.6 (Jan 24, 2012)

  • Fixed the bug of failure to print PDF in Model Design
  • Fixed the bug of DISTINCT clause disappeared in Query Editor after using Query Builder
  • Fixed the slow response when opening Execute SQL File window.
  • Fixed a crash issue when using Beautify SQL
  • Fixed the crash issue when quitting process in Server Monitor

New in Navicat for MySQL 10.0.3 (Nov 3, 2011)

  • Data Modeling
  • ER Diagram View
  • Connection Coloring
  • Database Wide Search
  • Many other improvements

New in Navicat for MySQL 9.1.4 (Jan 21, 2011)

  • Improvements:
  • Elapsed time is now shown for each query in Query Viewer.
  • The first level tag in XML file is now recognized as the record indicator during Import Wizard.
  • Bug Fixes:
  • Queries list in main window was not refreshed after transferring queries.
  • Crashed when refreshing tables after Record per Page setting had changed in Table Viewer.
  • After deleting a record, the next record is now selected instead of the final record in Table Viewer.
  • Improper ENUM fields default values were listed for selection in Table Designer.
  • Mode selections were ignored under "Advanced Settings" tab in Data Synchronization.

New in Navicat for MySQL 9.0.6 (Jun 11, 2010)

  • Improvements:
  • Show the host information under Connection Information view.
  • Bug Fixes:
  • Failed to transfer Foreign Key to target server if the target database name was different to the source database name.
  • Memory allocation problem which may cause Navicat to crash when transferring data using Data Transfer.
  • Incorrect values were synchronized during Data Synchronization.
  • Crashed easily when running queries in Query Viewer.

New in Navicat for MySQL 9.0.2 (Apr 26, 2010)

  • Import/Export connection.
  • Significant Improvements made in code/word completion.
  • Code Folding.
  • Matched Brace/Bracket Highlighting.
  • Parameter Tips.
  • Zoom In/Out for SQL editors.
  • SQL Beautifier.
  • Favorites.
  • Object Filter.
  • Individual database objects backup.
  • Unicode Character Report.
  • Auto save in Query, Function etc.
  • Custom sort in Tabler Viewer.
  • Significant Improvements made in editor and data grid searching.
  • Notification email supports SSL/TLS in Schedule.
  • History Log Viewer.

New in Navicat for MySQL 8.1.9 (Feb 15, 2010)

  • Improvements:
  • Improved the compatibility in MySQL SSL connection.
  • Improved the support of bigger data in each cell of Excel file during Export Wizard.
  • It now has no restriction on jointing the data type fields in Query Builder.
  • Bug Fixes:
  • Deadlock occured when opening new windows using SSH Connection.
  • Fixed crash problem during Import Wizard.
  • The "Run" button would be disabled in some cases even the SQL stopped running in Query Editor.

New in Navicat for MySQL 7.1.4 (Jul 30, 2008)

  • Timeout reconnection: With the new feature, Timeout reconnection, you can keep connection alive with the server by pinging it. Work more smoothly by enabling this option.
  • New Import Wizard: Newly added import data format - Excel file. With the new feature in Import Wizard, you can now enjoy more! Not only CSV, Text, XML and DBase files, but Excel as well!
  • Tabbed Window: One single window includes multiple tabs. Save your time and neatly arrange the tabs. Enable / Disable this new feature upon your own preference. Give you flexibility and increase readability at the same time. Experience the new Tabbed Window now!
  • Virtual Grouping: Virtual Grouping - introduced in both Navicat Mac & Navicat Windows. Now, Navicat provides you a way for better organization over objects. With the new Virtual Grouping feature, you can categorize objects into groups. It can be applied on Connection, Table, View, Stored Procedure, Event, Query, Report, Backup and Schedule. Just simply right-click the panel and select Manage Group from the popup menu.
  • Event Scheduler - introduced in both Navicat Mac & Navicat Windows. Newly added in MySQL 5.1.6. Now Navicat supports you to work on Event Scheduler. MySQL Events are tasks that run according to a schedule. Don't lag behind! See how the new feature works!

New in Navicat for MySQL 7.1.1 (Feb 2, 2008)

  • Tabbed Windows - support dragging tabs in and out of the tabbed windows.
  • SSH Connection - support public key authentication.
  • Structure Synchronization - support synchronizing foreign keys and triggers.

New in Navicat for MySQL 7.0.11 (Dec 11, 2007)

  • Major new features:
  • New Import Wizard - Supports Excel file; Improves performance, usability, and much more.
  • Tabbed Window - Performs multiple operations in a single window.
  • Virtual Grouping - Provides better categorization for objects.
  • Event Scheduler - New MySQL feature as of MySQL 5.1.
  • Other Enhancements:
  • Improved memory managment in Import Wizard
  • Keyboard shortcut (Control-Tab) to switch between tabs
  • Compatible with any MySQL server version up to 5.1.x.
  • Incremental Search, Hex Editor and more supports in Table View.
  • Usability enhancement in Table Design.
  • Many other improvements on features and user-friendliness.

New in Navicat for MySQL 7.0.8 (Oct 16, 2007)

  • Major new features:
  • New Import Wizard - Supports Excel file; Improves performance, usability, and much more.
  • Tabbed Window - Performs multiple operations in a single window.
  • Virtual Grouping - Provides better categorization for objects.
  • Event Scheduler - New MySQL feature as of MySQL 5.1.
  • Other Enhancements:
  • Compatible with any MySQL server version up to 5.1.x.
  • Incremental Search, Hex Editor and more supports in Table View.
  • Usability enhancement in Table Design.
  • Many other improvements on features and user-friendliness.

New in Navicat for MySQL 7.0.7 (Sep 19, 2007)

  • Major new features:
  • New Import Wizard - Supports Excel file; Improves performance, usability, and much more.
  • Tabbed Window - Performs multiple operations in a single window.
  • Virtual Grouping - Provides better categorization for objects.
  • Event Scheduler - New MySQL feature as of MySQL 5.1.
  • Other Enhancements:
  • Compatible with any MySQL server version up to 5.1.x.
  • Incremental Search, Hex Editor and more supports in Table View.
  • Usability enhancement in Table Design.
  • Many other improvements on features and user-friendliness.