[cazzoot]

Although I like Phpmyadmin so much and definitely not ready to pay for another application, I would still like to recommend a software named Navicat, http://www.navicat.com

I didn't encounter this software until I read this article: http://www.geocities.com/mchuthor/review.html

Cazz

[Puno]

Navicat is nifty looking and very intuitive to use. Plus it has a GREAT tool called data transfer to move entire DBs or partially directly from any server to any other server.
Produces sql dumps of whole DBs or tables, etc, handles users perfectly and can migrate from Excel, Access etc.
BUT it chokes big time on large DBs (large= 50MB .sql dump or >60K entries of decent size). So if you don´t have large DBs pay heed to cazzoot and check this soft out.

mySQL control center has given me lots of trouble trying to reconfig users (doesn´t fulsh or something) "other than that" just fine

For large transfers I go to console: mysqldump --opt ....

Speaking of which,
do any GUIs you use handle large DB transfers?
php my admin works great since it is server side but i find it flaky sometimes.

And BEST site ever: Dark Freak speaks the truth:
http://www.w3schools.com/

[unklsanya]

Originally Posted by darkfreak

This is one of my favorite pages. It contains short, good quality tutorials on many topics - on SQL as well. Absolutely worth of visiting at least for the beginners.

http://www.w3schools.com/

spent two hours on this site last night, most productive two hours since i began study of html, thank you very much!

[rameshs]

MySQL SNMP Agent and Web Console

http://www.adventnet.com/products/mysql_agent/

Provides out-of-the-box ability to monitor and manage the various components of MySQL database such as users, queries, performance, logs, etc. Comes with a Web console for remote monitoring and an SNMP interface to integrate with HP OpenView, IBM Tivoli, etc.

[thedevshop]

Tool that generates PHP pages for your mySQL database... actually generates your choice ASP or PHP and works with most databases. A real time saver, and good tutor too.

dbQwikSite www.dbQwikSite.com

[kevincheung]

I have tried most of the IDE suggested above, however, none of them provide a good Import functionality that let me import my Access database to MySQL.

I came across a program called Navicat, http://www.navicat.com and downloaded a trial version. This GUI offers a feature-rich import/export wizard and other advanced database admin options.

I am still evaluating other features of Navicat. Apparently, it seems the best MySQL GUI in the market.

If you haven't tried it before, I suggest you to check out a review by O'Reilly.
http://www.onlamp.com/pub/a/onlamp/2...2/navicat.html

[adaml]

You forgot MySQL Administrator and MySQL Query Browser. Aswell as the MySQL Manual!

[ptesone]

Hello,

Check this mysql manual is the best for mysql 5 features :
http://www.mysqldevelopment.com

Check the new GUI MySQL Turbo Manager 3.4 , support all mysql 5 features like triggers, stored procedures and views.
http://www.mentattech.com

Check the new MySQL Server 5.0.12.
http://dev.mysql.com/downloads/mysql/5.0.html


Enjoy

[greatnuker]

Hey guys, I came across this awesome plugin chat for phpnuke sites, check it out if you have a chance! http://www.userplane.com/webchat/

[ptesone]

Hi,

New resources for MySQL 5 server :


Database 5

http://dev.mysql.com/downloads/mysql/5.0.html

GUI'S
MySQL Turbo Manager
http://www.mentattech.com

SQLyog
http://www.webyog.com

Papers

Stored Procedures
http://dev.mysql.com/tech-resources...procedures.html
Triggers
http://dev.mysql.com/tech-resources...l-triggers.html
Views
http://dev.mysql.com/tech-resources...ysql-views.html

BOOKS

Pro MySQL from
http://www.apress.com/book/bookDisplay.html?bID=433

The Definitive Guide to MySQL 5
http://www.apress.com/book/bookDisplay.html?bID=10011

Regards,