Topic: Maintaining mySQL

MoroccoIT    -- 04-06-2010 @ 3:17 PM
  I am new to mySQL, I'd like to know if there are utilities I can use to maintain mySQL database.

I've been using SQL/Server, once I open SQL/Server “Enterprise Manager” I can dive in into any table by using SQL Query Analyzer and do anything I want to maintain my database. However, I am being forced to use mySQL since one our CF websites uses mySQL db. Since I am new to mySQL, I’d like to know there are tools similar to “SQL Query Analyzer” I can use with mySQL to maintain my database.

I’d appreciate any input. Thank you.

nmiller    -- 04-06-2010 @ 3:40 PM
  I use mssql for most everything, but sometimes use MySQL.  
The best one I've used is navicat:

Not free, but there's a free trial

Nathan Miller
NM Consulting

This message was edited by nmiller on 4-6-10 @ 3:40 PM

megan    -- 04-15-2010 @ 11:24 AM
  Navicat is wonderful but you might want to try out HeidiSQL - I just started playing with it and so far like it a lot

hth ~megan

"The chief cause of failure & unhappiness is trading what you want most for what you want now." ~Zig Ziglar

andruserj    -- 06-08-2013 @ 2:33 AM
You can check free tool Valentina Studio  
which I think is far superior to other GUI tools.

SergeiK    -- 07-26-2013 @ 12:57 AM
  Need really a professional tool with intuitive graphical
user interface and lot of usefull features? Try dbForge
Studio for MySQl! All the necessary features for database  
management and administration in one product! Read here:
Trial available! Try it!

EasyCFM.COM ColdFusion Forums :