Blog - Akbarsait.com

Navicat MySQL Database Editor

Dec 30, 2009 15668 Views Tools & Utilities , MySQL Comments (13)

I tried and used some database administration tools for MySQL but I feel like something was missing in its features. Recently I started using Navicat for MySQL database management which is really awesome and having many features which can be used to solve and manage your database with a very minimal amount of time.

Some of the key features of Navicat I have enjoyed using are transferring data between local and remote databases, visual editor, form viewer, schedule task, data and object dump features and many more. Also using Navicat you can connect to multiple databases like MySQL, Oracle and PostgreSQL simultaneously. There is a free Non-Commercial Navicat Lite version is available for download with some limited features. So what editors are you using for your MySQL databases management? For me Navicat is an excellent utility which makes my database management and administration easier.

Related Entries

MySQL Backup and FTP: An Easy and Handy MySQL Backup Utility (Jan 20, 2012)

Comments

1. Gary Funk on Dec 30, 2009 at 9:00 PM

I've been using SQLyog for MySQL for as long as I can remember. It servers me well and has helped me solve many a problem.

I'll take a look at Navicat as I'm always looking for new tools.

2. Akbarsait on Dec 30, 2009 at 11:01 PM

@Gary I’m sure you will like Navicat over SQLyog!

3. Nick Sophinos on Dec 30, 2009 at 11:56 PM

Yeah, I have been using Navicat on my Mac since 2006 and it is smooth.

4. Raul Riera on Dec 31, 2009 at 6:41 AM

I switched from navicat lite to http://www.sequelpro.com/ it's pretty good! lots of features not included in navicat and it is open source (and very "cute" ui)

5. Charlie Griefer on Dec 31, 2009 at 4:14 PM

I've been a happy Sequel Pro user as well. Altho recently Todd Sharp turned me on to mySQL Workbench (http://wb.mysql.com/). I've downloaded it, but haven't taken it for a test drive yet. Looking forward to doing so, as it sounds very impressive.

6. Jeff Pierson on Dec 31, 2009 at 5:54 PM

I have also been using Navicat for about 2 years now. It has served me well and met my needs so far.

7. Akbarsait on Dec 31, 2009 at 6:08 PM

@Nick Sophinos Thats really Awesome!

@Raul Riera Let me give it a try and thanks for pointing!

@Charlie Griefer Please blog about once you tried.

@Jeff Pierson Sounds Great!

8. Gary Funk on Dec 31, 2009 at 9:01 PM

@Charlie: I've been using MySQL Workbench since it was first in beta. It's really nice.

@Akbarsait: I tried Navicat and while it's nice, SQLyog has so many more features and is the most powerful MySQL tool I have found.

9. Rick Mason on Jan 1, 2010 at 5:17 PM

I actually had to use Navicat at my last job and really prefer SQLYog. My only beef with them is that they have yet to introduce a version for the Mac where I am spending more of my time these days.

10. Website Design Ltd on Jan 27, 2010 at 8:52 AM

I have just started to use Navicat, it looks real good so far; do you have any useful Navicat resources (espically on implementing many to many relationships using multiple foreign keys as a primary key?)

11. TheOddOne on Mar 26, 2010 at 6:30 PM

When it comes down to database editing and data editing (not running, backup etc) MySQL Workbench is a pile of crap. (Try edit a blob ("Text" rather) in table edit mode)

SQLyog is better.

Navicat is the betterest!
(If it supported MS-SQL I would use it at work)

12. jorjes on Jun 29, 2013 at 1:13 AM

Not so far I have found new cool tool to work with mySQL - Valentina Studio. Its free edition can do things more than many commercial tools!!
I very recommend check it. http://www.valentina-db.com/en/valentina-studio-ov...

13. Joesph on Jul 17, 2013 at 5:43 AM

My only beef with them is that they need nonetheless to introduce a version for the mack where i am spending a lot of of my time currently I actually had to use Navicat at my last job and extremely like SQLYog.