MySQL Administrator and Query Browser
Saw this in the MySQL newsletter. New tools from MySQL to administer the server and databases:
Administrator - download
Query Browser - download
The Administrator contains a comprehensive list of server options, though I don't know how complete it is. Tasks like managing users and creating backups are much easier to do with this, particularly for folks who are neither DBAs nor documentation-tolerant but need to do it.
The Query Browser is great too. Although I haven't used it for very long, I find it's a lot more intuitive than phpMyAdmin which I've used until now. Being as it is not on a web interface, it's more responsive and doesn't suffer from forms issues.
They're both pretty GUIs that I expect will work well for most of the common tasks. As always, no substitute for good training and documentation, but it fills other voids.
The only disadvantage is probably that it's no good for web management. I'll still be using phpMyAdmin for that, but I think I can replace it with the Administrator and Query Browser for the local servers I manage.
openmind posted this at 22:03 — 9th December 2004.
He has: 945 posts
Joined: Aug 2001
I downloaded the new MySQL server and for the life of me could not get it going. I was getting all sorts of errors about the MySQL server being out of date when I tried to query it using phpMyAdmin.
Makes me very hesitant to upgrade the server but it may be something I did...
Renegade posted this at 03:42 — 10th December 2004.
He has: 3,022 posts
Joined: Oct 2002
I'm guessing it's password issue? The one where it says you need to upgrade the server or client? http://dev.mysql.com/doc/mysql/en/Old_client.html
openmind posted this at 09:39 — 10th December 2004.
He has: 945 posts
Joined: Aug 2001
Yeh that was the puppy! Thanks for the link and I'll give it another bash.
Is there any major changes apart from the admin and query browser? Is it faster for example?
The one we have running on our server is supporting about 50 DBs at the moment and copes fine but obviously the need for speed is paramount!
Abhishek Reddy posted this at 13:53 — 10th December 2004.
He has: 3,348 posts
Joined: Jul 2001
I don't know how much faster it is, though I expect it would be more efficient. Haven't encountered any stats. My experience is with small intranet DBs so the performance difference for me is not noticeable. It would be a good idea for you to give it a spin and test first.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.