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

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.