Only Network

If you use MySQL all the time, you’ll know that there’s some confusion out there about tools that can help you manage your databases. It’s not the same like Microsoft’s SQL Server, where graphical tools are available out of the box for you to use. With MySQL you need to dig around and find something suitable.

Enter Navicat. Navicat is a tool that lets you easily manage your MySQL databases and quickly develop code against them. It boasts a number of tools including a Visual Query Builder (to build your queries graphically), SSH and HTTP Tunnel for remote database connection, automatic database transfers, backups and import/export functions and perhaps my favourite: data and structure synchronisation.

Here’s the press release I came across, that has all the details you need to know:

Navicat MySQL GUI features an intuitive interface and provides a set of useful tool to manage, backup/ restore, import/ export data, synchronize database and connect to remote MySQL server, etc. Navicat MySQL GUI ver. 8 is the latest iteration of the database management tool that offers more than 100 improvements and some new powerful features.
Major new features of ver. 8.0.12 at a glance:

1.Code Completion – Speedup your sql writing.
2.Form View – Input record via form view.
3.New Profile System – Open profile on your desktop directly.
4.Virtual Grouping – Provides better categorization for objects.
5.Event Scheduler – New MySQL feature as of MySQL 5.1.
6.Report Export – Export report to pdf, html and more.
7.E-mail Notification – Send notification e-mail for schedule task.

Other major features:
- Visual Query Builder
- SSH/ HTTP Tunnel for remote database connection
- Database transfer from server to server
- Data and Structure Synchronization
- Data backup and restore
- Import/ Export of most popular data formats to and from MySQL
- Report Builder
- Tasks Scheduling and Easy-to-use wizards tool

See full release notes at http://www.navicat.com/release_notes.html

It can be quite valuable to have a tool like this in your arsenal. It can speed up the development of all your mySQL bits, and help you manage you code more effectively.

If you think this may be for you, Download Navicat trial version