Getting Started

Requirements Installation Installation Errors Securing DbNinja

Using DbNinja

Upgrading Password Recovery Troubleshooting Uninstalling

Legal Information

Licensing Personal Use License Privacy and Security

Other

Changelog

DbNinja Changelog

Version 3.2.7 (2017-02-17)

New Features

Better compatibility with MariaDB

Bug Fixes

DATETIME columns support CURRENT_TIMESTAMP
Fix issues with incorrect arguments parsing in stored functions
Fix error definer related errors in procedure/view/event/trigger

Version 3.2.6 (2014-05-04) - Recommended upgrade

New Features

Added row numbering in query result
Allow to export query data prior to running the query
Added show/hide query log button to top menu

Bug Fixes

Stored procedures with enum arguments do not parse correctly
Table data import problems with files containing over a few tens of thousand records
Export to Script and Export Data sometimes failing if PHP has no multibyte extension installed
More informative error messages

Version 3.2.5 (2013-12-23)

New Features

View database object details: amount of rows in tables, table size, etc

Bug Fixes

Paging issues in multi result with multiple pages
Execution errors in scripts with certain stored routines
Bottom scrollbar in query editor not working after opening query log

Version 3.2.4 (2013-10-17)

Bug Fixes

Views with UNION don't show correctly in the editor
Execution of a script that's larger than 'max_allowed_packet' doesn't produce an error message
Request time out setting not affecting execution of scripts

Version 3.2.3 (2013-09-13)

New Features

Ability to set data values to SHA and MD5 from context menu

Bug Fixes

MySQL connectivity related errors not displayed when running queries
Unnecessarily displaying browser extension related exceptions

Version 3.2.2 (2013-09-01)

New Features

Added table dependencies viewer
Added ability to temporarily disable foreign keys when updating table's structure
Added ability to follow URLs contained in table data
Improved SQL script execution technique to ensure large scripts don't time out
Improved SQL formatting in Views
Ability to select how INSERTs will be performed when exporting a database to script
Automatic refresh of object browser after running a script

Bug Fixes

AUTO_INCREMENT value not showing correctly in table editor
Certain stored routines failing to open in editor
Script execution failing on certain files
Procedures with no parameters fail to open in editor
Query autorefresh "stop" button is unclickable in long running queries

Version 3.2.1 - Minor release (2013-06-20)

Bug fixes

Regression bug: "Export to Script" not exporting data correctly

Version 3.2.0 - Major release. Important to upgrade! (2013-06-18)

New Features / Bug fixes

Improved paging of query results with ability to jump to a certain page
Ability to specify the maximum query result size in MBs and limit the number of fetched records
Table data editor now supports sorting and multi-column filtering
Data editor tab is now available in View editor window
Many bug fixes and other improvements

Version 3.1.2 (2013-02-05)

Bug Fixes

Data export functionality not working
Popup windows not closing with the X button

Version 3.1.1 (2013-01-29)

New Features

Tabs can now be reordered by dragging
Duplicating a table now allows copying data in addition to structure (see Duplicate table dialog)
DbNinja is now capable of sending keep-alive packets to your host (can be turned on in Settings)
Choose if double clicking on a table should open schema or data editor (configurable in Settings)
Query log is now available and accessible through the top menu
Ability to remove multiple objects without the need to confirm every operation (see Drop Multiple Objects in database context menu)

Bug Fixes

Fixed numerous interface and connectivity related issues

Version 3.1.0 - Major release (2012-12-16)

New Features

New tool for comparing and synchronizing databases between servers.
Ability to export query results and table data into files. Supported formats: Text, Excel, SQL, JSON and PHP.
Ability to import data from text files

Other Improvements

Ability to choose the default action for double-clicking cells with binary data in query results
Allow connecting hosts with an "empty" password
Added the ability to sort data by certain column in query results
Ability to rename tab titles (use right click)
Better handling of copy-to-clipboard
Added ability to select the default database when executing script files
Other significant GUI improvements