using mySQL

  • Thread starter Thread starter Phil Townsend
  • Start date Start date
P

Phil Townsend

Most of my life as a developer has been spent working in Microsoft
shops, but recently I have been asked to explore a little into the open
source world, PHP and mySQL.

Can anybody recommend tools for mySQL, that allow for some GUI
administration of the DB, such as Enterprise Mgr does for SQL Server?
Also, are there any good IDEs available for PHP? Thanks!
 
Phil said:
Can anybody recommend tools for mySQL, that allow for some GUI
administration of the DB, such as Enterprise Mgr does for SQL Server?

Hi Phil,
Have a look at MySQL Administrator and MySQL Query browser - you can download
them both from http://dev.mysql.com/downloads/ - they work on MySQL 4.1 (not
earlier): they're not as powerful as their MS counterparts, but you get the job
done...

You may also want to look at the .NET connector, an assembly that lets you
program against a MySQL database using classes similar to ADO.NET - very helpful
for a smooth transition...
Also, are there any good IDEs available for PHP? Thanks!

No idea about that - sorry!

Ciao - FM
 
Komodo from activestate.com is a very nice ide for php, perl, tcl and some
others; visual debugging and some intellisense and a useful cgi mode that
allows input of variables as if they came from a submitting form. Remote
debugging is theoretically possible but I've not been able.
I've used several mysql clients and the only one fully functional so far is
Navicat. Expensive but I've gotten 4 upgrades for free. Its query analyzer
works great and it has a very nice, one button backup utility that allows me
to extract the entire database with the data to sql and store all on my
local computer.
r
 
Back
Top