Use MySQL Workbench to export the MySQL database relationship diagram, workbenchmysql

Use MySQL Workbench to export the MySQL database relationship diagram, workbenchmysql

1. Click Create EER Model From Existing Database under Data Modeling in the middle of MySQL Workbench;

2. In Stored Connection, select the Connection for which the graph is to be generated;

3. Click Next twice and select the database for which the graph is to be generated;

4. Click "Next" until "Finish". The graph is generated. However, all tables overlap;

5. Drag the table to see the clear relationship diagram.

How to Use workbench to export the mysql database Relationship Diagram

1. Open mysql workbench and select "Create EER Model From Existing Database" in the middle of the homepage "Data Modeling ";
2. In "Stored Connection", select "Manage Stored Connections ...";
3. Select "New" in Manage DB Connections to create a connection, and enter the database information you want to connect to in the input box on the left;
4. Test the database Connection. After the Connection is successful, the interface 2 is returned. In "Stored Connection", select the new Connection;
5. Click "next" twice in sequence. In "select schemata to reverse engineer", select the name of the database to be located and click "next ";
6. All Tables in the exported database relationship diagram overlap. You need to manually drag the table to the corresponding position.

MYSQL: How can I use Workbench to import and export database content?

PhpMySQLAdmin directly has the export/export option.