Creating the actual database

Hi,

I see all these wonderful tools for generating the website pieces required for online catalogues etc. but I was wondering if there were any tools to help. Me create the actual database. I just don't understand what is going on with MySQL. I come from a FileMaker Pro background. I can visually create fields and add code within the DB to edit and format content. I think use FMStuidio to connected to the database and create record sets and dynamic pages that pull content from the Fikemaker database using PHP.

Does MySQL work similar or is is a completely different animal? The extra hosting costs for FileMaker make it too expensive for my smaller clients.... And most of my clients are small. I host my client websites on 1and1.com

So what I am really after is if WA has any tools to help create the MySQL database or is there some sort of visual tool I can use on my Mac that will help be create all my tables and fields required for a custom MySQL DB that I can access with DataBridge?

Any help would be greatly appreciated.

If anyone is interested in teaming up on a few tests that would be great.

The type of stuff I am currently building can be seen here...

Http://www.swissmar.com
Http://www.harwoodmotors.com
Http://www.swissmilitary.ca
Http://www.vintagemotorcarsusa.com

These all use FileMaker on the back end... Hosted internally at my office.

Thanks.

There are a number of Differant GUI Tools for MySQL.

Probably the most common is phpMyAdmin which is usually offered through your hosting provider,, it is a web based MySQL GUI Tool.

MySQL Workbench is another GUI Tool created by the people that created MySQL:
http://www.mysql.com/products/workbench/

On my Mac I Use Sequel Pro:
http://www.sequelpro.com/

On my Windows system I use Heidi SQL:
http://www.heidisql.com/

Navicat is another popular GUI Tool and is available for both Win and Mac OS:
http://www.navicat.com/products/navicat-for-mysql

I watched a few videos on MySQL and it really doesn't look like it is up my alley at all. I may be better off working with a local programmer and then using the WA tools to bring it to life online.

If your familiar with File Maker, MySQL should not be too different.

The main difference between the two is that MySQL is a relational Database, whereas file maker is more of a Flat file.

We Offer a free MySQL eCommerce Database that you can use as a starting point:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=101

and also a Database Getting started guide that should be helpful:
http://www.webassist.com/community/tutorials/view_tutorial.php?tid=104