[dmurfitt]

Hi

I just wondered if anyone knew of a good free/open source MySQL management program to run under Windows? I have phpmyadmin, but I would like a windows based one to run regular backups.

[Rockn]

MySQL Admin
http://www.mysql.com/products/tools/administrator/

[coachdan32]

Rockn,

Is there a tutorial you know of that walks through setting up a mySQL database on your website? I was considering an Access db, but would prefer mySQL or SQL Server. I don't have any experience with mySQL.

[etaf]

http://www.awtrey.com/tutorials/dbeweb/
http://www.thescripts.com/serversidescripting/php/
http://www.wampserver.com/en/index.php
http://dev.mysql.com/doc/
http://www.freewebmasterhelp.com/tutorials/php/

[coachdan32]

etaf,
Thanks for the links. I didn't have time to read them all, but I bookmarked them and will this weekend. It looked like they were all in the scope of PHP; is mySQL an option for ASP as well? I have no experience with PHP whatsoever. Can you run PHP on a Windows webserver?

[brendandonhu]

Yes, and yes.

[Sequal7]

A really good MySql database admin tool is dbtools, I use it and love it. It is free (freeware editions), but not open source. Works with windows for local or remote connections.

http://www.dbtools.com.br/EN/downloads/

[Rockn]

You could also use MSDE as an alternative to Access

Also FREE:
http://www.microsoft.com/sql/edition...s/default.mspx

[coachdan32]

That sounds great Rockn, I will check it out.

[dmurfitt]

Thanks everyone

[Bert_2]

http://www.phpmyadmin.net I like this one, it works great and it's part of xampp :P

[dmurfitt]

Do you know of any mysql admin program that can manage the tables and data rather than just the database/server?

Thanks

[Rockn]

What do you mean "manage the tables and data"?

[dmurfitt]

Like phpmyadmin does, add tables, add data etc.

Like this: http://www.navicat.com/detail.html

Is there an open source solution like this?

[Rockn]

Most admin programs are not an interface to add data other than import and export functions. Admin programs like MySQL Admin can create and manage tables, users, etc.