What DB Administration tools do you guys use/recommend? Personally im a fan of SQLYog, however i have used the Mysql.com Admin Tools in the past, but they are a little weak.

I however, definately havent used SQLYog to its full capacity and it is still far better than the Mysql.com Tools.

I use the tools from MySQL.com - they 'just work' for me, I've not needed to go and look for anything more. :)

I use SQLYog too, extremely powerful software. I did once look at the default MySQL tools, but I wasn't too impressed with them either (that was years ago though, so who knows where they have come since then).

Salathe, i'd recommend trying SQLYog, especially if you havent before, its mountains better than the mysql tools, offers much more flexability.

http://www.webyog.com/en/ They have a trial :)

Maybe I'm just being blind but I couldn't find an OS X version, bluesaga. :(

I prefer PHPMyAdmin - Crap and ugly looking but it always happens to do the job.

__________________

Ah im not too sure about OS X :( Sorry.

PHPMyAdmin offers nothing that SQLYog can, simply put.

Wow, Never knew of SQLYog. WildHoney told me about SQLYog website but I installed Monitor instead of the GUI to manage the database. Lol, silly me. :(

The program I always use is: Navicat.

It's definiately worth trying it out!

http://www.navicat.com/

I use Ross when ever possible and there are several great tools out there for mysql database administration however, I too love Navicat.

It has 3 very important features that I use all the time.

1. Data import tools for excel, cab, XML and other formats.
I never know how or where my data is going to come from when working with a flint but Nsvicat's tools give me enough options to know I'll be able to get the job done.

2. Visual sql query builder - similar to what you find in M$ Access or OOo Base.
I'm very confident with my Sql skills, but a visual query builder is just a nice tool for prototyping a complicated query quickly. You can run the query for performance testing and switch to edit the SQL code, and back,to fine tune things at any time.

3. Data Transformation Services (DTS) with option for scheduling.
When you have multiple databases DTS is a life save, pushing and pulling datasets across servers at reqular intervals if you so desire. If you've never had to do this, when you do, you'll wish you had tools like this ...

Its one of the few prices of software I happily pay for and really enjoy using.

Brad

Never heard of Navicat before but it looks quite nice. Is it a powerful tool? I use SQLYog which I wouldn't put in a corner for anything else, but it's still worth asking about Navicat!

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

It definiately is. It can do all the things you want to do with a database. You should try it yourself. Once you go Navicat, I think you'll never go back to other administration tools. :)

I use PHPMyAdmin too. As localhost mentioned, it just works. Also, its linked in my hosts control panel, so its the most convenient.

Trouble with phpMyAdmin is that it's just too messy :( Everything about it is yuk. Don't get me wrong, I used to use it, then I discovered stand-alone applications such as SQLYog that, well, just work, too :) !

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

Yeah I hear ya. It is rather messy and ugly. It does load kind of slowly for me sometimes too, so maybe I'll check out some stand alone ones like SQLYog. :)

Only trouble with stand-alone applications like SQLYog is that you first have to enable your host to connect. Typically they're just configured to allow localhost to connect by default - which means phpMyAdmin.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

Oh well my host doesn't use localhost. They have their own address, so would it already work?

It's a tough one. Probably not. They've probably only allowed their hosts to connect. Your host would be more than happy to add another host to the allowed list - or if you have an administrator area, such as CPanel, then you can do it from in there.

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

Great. Thanks for the info! :)

Gurnk - If you use cpanel, before you click "view phpmyadmin" there should be something there for "hosts" normally it just has "localhost", if you add "%" it works as a wildcard and allows any ip address to remotely access your database (with the correct credentials).

Or you could simply allow only your own IP to access it by entering that instead of "%"