What are your favorite MySQL tools?

Bullschmidt

I'm an ASP developer learning PHP.

What MySQL tools should I be using?

This is what I'm considering and maybe you can let me know if this is "the usual way" and/or if you have some other ideas:

On the development PC (Windows XP):
MySQL Control Center

On the shared Web host (Probably Linux):
phpMyAdmin and/or whatever the Web host allows

And what about tools should I consider to transfer data from the shared Web host to the development PC (so that I have a fairly recent copy of the data while I'm developing) or vice-versa?

Thanks in advance!

LordShryku

Personally, as tools are concerned, I like phpMyAdmin on Linux or Windows. It handles most of what I need to do on there.

Pellefant

I am downloading and printing the manual for...

EMS mySQL Manager

...right now, will let you know later on what I think about it.

Thanks

ahundiak

The command line program "mysql" and a text editor works great.

hkucsis

The command line is cool but when I select rows with many fields, the result is unreadable......

I prefer MySQL CC, it is a MySQL-version "Enterprise Manager"...

KoshNaranek

Maybe the MySQLCC will help

www.mysql.com

With myODBC you could use M$ Access to "compose" a query... some litte changes an they'll work fine with PHP 😃

I'am using phpMyAdmin and Access - the CC has much less functions than the MS-SQL-Enterprise-Manager...