Best Database Management Tools

05/14/2012 16:44 shadowman123#1
Well i was searching about the most Efficient Database management Programs

and i found that Topic [Only registered and activated users can see links. Click Here To Register...]


So what i Ask Actulay is 2 Questions :-

1 - Have any1 tried PhpMyAdmin ?

2 - Which one will you go for ?
05/14/2012 16:50 Korvacs#2
Well that thread is 2 and a half years old and a completely retarded comparison as it depends entirely on what type of database you have.

For mysql i prefer phpmyadmin, for mssql i use microsofts sql management suite.
05/14/2012 18:22 bone-you#3
MySQL, [Only registered and activated users can see links. Click Here To Register...]

I personally use the older, discontinued ones myself though. [Only registered and activated users can see links. Click Here To Register...]

Workbench is the successor to them, but I find the older ones to do exactly what I need to and with a cleaner interface.
05/14/2012 19:46 © Haydz#4
Quote:
Originally Posted by bone-you View Post
I personally use the older, discontinued ones myself though. [Only registered and activated users can see links. Click Here To Register...]

Workbench is the successor to them, but I find the older ones to do exactly what I need to and with a cleaner interface.
+1 to that, I find that the old "MySQL Administrator" did the job perfectly, now the workbench application just feels like a mess.
05/14/2012 21:41 Kiyono#5
I mostly use Navicat, it does what I want it to do and has a relatively simple interface. I use phpmyadmin every now and then just because I can. I tried to use MySQL GUI tools before but I simply didn't like it.
05/14/2012 21:44 Korvacs#6
Workbench is just buggy and unreliable so keep well away from that, the older gui tools just seemed to take forever to execute large queries so i wouldnt suggest them either to be honest.
05/15/2012 00:20 tkblackbelt#7
I also use MySQL workbench and never had any problems with it.
05/15/2012 01:03 bone-you#8
GUI tools taking forever to execute a large query? A large query has nothing to do with the client. That'd be your server taking forever. I easily pull 20-100k rows regularly in mysql query browser. If it happens to be local, I'll get results within a second or two.

Workbench is fine when it comes to crossplatform though. When I happen to be on Linux I use it unless I can put WINE on Then I'll use query browser instead :)
05/15/2012 09:46 Korvacs#9
Im not talking about a lookup, when using GUI/Workbench they just take forever to execute large inserts, updates, table creations, etc. On the same server phpmyadmin does this in a couple of seconds.
05/15/2012 11:07 bone-you#10
Quote:
Originally Posted by Korvacs View Post
Im not talking about a lookup, when using GUI/Workbench they just take forever to execute large inserts, updates, table creations, etc. On the same server phpmyadmin does this in a couple of seconds.
I have never had that issue. I can restore an entire few hundred megabyte DB with hundreds of thousands of rows in over a hundred tables within seconds if the connection is local. Though ideally MySQL Administrator should be doing that action, and it does it even faster.
05/15/2012 11:17 Korvacs#11
/shrug just my experience of them, would prefer not to have to have a webserver running with phpmyadmin installed just to administer a mysql database, but based on those experiences i feel i need to, of course since then ive moved the database to a webhost anyway so i dont need to worry about that, its running phpmyadmin for me anyway.
05/15/2012 11:53 Mr_Hitch#12
iam using MySQL Community Server and its working fine for me
05/15/2012 13:03 Korvacs#13
Thats a server, not management tools for a server...
05/15/2012 19:12 Spirited#14
I use a few tools. Navicat is my editing tool. I use it to manage data in my tables because it's fast and easy.I sometimes edit the table structure using Navicat if it's a small change, but in general, I use Microsoft SQL Management Studio because of it's advanced options when creating a new table. Navicat just doesn't cut it sometimes, though it's great for small, quick changes or large imports from files. You should use what you're comfortable with. I use MsSql btw.
05/15/2012 21:18 Mr_Hitch#15
ah yeah well am usign navicat its working fine for me