MySQL Design Tool

[wieman01]

Is there any free (open source) design tool available for MySQL? I want to create a database design using a graphical tool that allows me to export SQL code... Anything you would know of? For Linux please.

[mike_g]

I use phpMyAdmin for creating MySQL databases but AFAIK it does not export SQL code tho.

If theres better tools around I would be interested to hear about them.

[wieman01]

One I found is Navicat, but it is free for trial on (30 days) and comes with Wine, so it's basically a Windows program. It's pretty nice, but only for 30 days I guess.

[cpetercarter]

phpMyAdmin allows you to export your database in a number of different formats, including SQL. I back up my website database (when I remember!) in this format. phpMyAdmin is available in the repositories (though you can equally easily download it direct from the website and install it where you wish on your computer.)

[wieman01]

phpMyAdmin allows you to export your database in a number of different formats, including SQL. I back up my website database (when I remember!) in this format. phpMyAdmin is available in the repositories (though you can equally easily download it direct from the website and install it where you wish on your computer.)

But you still have to generate the SQL code by hand when you create your database design, right? I don't want that because it consumes to much time and is prone to error.

[bruce89]

But you still have to generate the SQL code by hand when you create your database design, right? I don't want that because it consumes to much time and is prone to error.

No, everything is GUI.

[cpetercarter]

No - you can create new databases, new tables, new columns, amend or drop any of these, edit data etc all from the GUI. You don't much if any SQL to set up the database.

[wieman01]

Mmm... That sounds tempting then. Thanks, cpetercarter & bruce89. I will give it a go and report back.

[bruce89]

Only snag with phpMyAdmin is that it needs the whole LAMP stack as it's Web-based.

[essexboyracer]

something like this...

http://www.fabforce.net/dbdesigner4/screenshots.php

On the flip side, if you already have something in another DB language, try http://kettle.pentaho.org/ to convert the data to mysql