Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Exporting only table structure using mysqlworkbench

Can anybody tell whether it possible for exporting only the table structure using MySQL workbench

like image 1000
user3275044 Avatar asked Mar 11 '14 05:03

user3275044


People also ask

How do I export only data from MySQL workbench?

From menu select Server->Data export , then choos your schema from left pane and then tables from right pane. From drop down menu select Dump Data Only . Click on Start Export button to export your data.


1 Answers

To get an individual table's creation script:

  • just right click on the table name and click Copy to Clipboard > Create Statement.

To enable the File:

  • Forward Engineering SQL_CREATE Script.. option and to get the creation script for your entire database:

    1. Database > Reverse Engineer (Ctrl+R)
    2. Go through the steps to create the EER Diagram
    3. When viewing the EER Diagram click File > Forward Engineering SQL_CREATE Script... (Ctrl+Shift+G)
like image 194
Mark Avatar answered Oct 14 '22 10:10

Mark