Help Center > > User Guide> MySQL Database Management> Database Management> Exporting the Database Structure

Exporting the Database Structure

Updated at:Mar 20, 2020 GMT+08:00

Prerequisites

You have logged in to the DAS console.

Scenarios

This section introduces two methods to export the database structure.

  • Method 1

    You can right-click the DB instance in the navigation tree to export the database structure as required.

  • Method 2

    You can directly right-click table, view, or trigger objects in the target database in the navigation tree to export its structure.

Method 1

  1. In the navigation tree on the left, right-click the DB instance and choose Export Database Structure from the shortcut menu.
  2. On the displayed tab, select the target object type or the target database, tables, views, and triggers and set whether to contain CREATE DATABASE statements.

    • You can click Export to export the database structure and view the export results on your local PC.
    • You can also click Preview to preview the database structure before exporting it.

Method 2

  1. In the navigation tree on the left, right-click the target database and choose Export Database Structure from the shortcut menu.
  2. On the displayed tab, select the target object type or the target tables, views, and triggers and set whether to contain CREATE DATABASE statements.

    • You can click Export to export the database structure and view the export results on your local PC.
    • You can also click Preview to preview the database structure before exporting it.

  • If you select Table, View, and Trigger for Object Type, all tables, views, and triggers in the database will be exported, and the number of objects to be exported is not limited.
  • If you select tables, views, or triggers one by one in the object list, a maximum of 1000 objects can be selected.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel