Loading an existing database in WWW SQL Designer?

I used WWW SQL Designer several times to design databases for applications. Now I am responsible for working with an application with a large number of tables (100+ mysql tables), and I would be interested to look at the relationship between the tables as WWW SQL Designer suggests. It seems that it contains provisions that allow you to connect to the database and present a diagram of its structure, but I have not yet been able to determine exactly how to do this.

+3
source share
6 answers

http://code.google.com/p/database-diagram/

This takes an SQL structure (SQL dump) and shows a chart :)

+1
source

, , ( ): backend/php-mysql/index.php . , , - , .

function setup_import() {
    define("SERVER","localhost");
    define("USER","");
    define("PASSWORD","");
    define("DB","information_schema");
}
+2

SQL-, , WWW SQL Designer? ...

+1

, , PHP/MySQL, " " "/".

+1

VISIO , .

0

btw, have you tried SchemaBank ? They are web based and support MySQL pretty well. It eats your sql dump and generates tables and relationships for you.

0
source

Source: https://habr.com/ru/post/1697351/