Recommended Servers for MySQLThe world's most popular open source database
Selecting , , will start the Forward Engineer SQL Script wizard. The first page of the wizard is:
The SQL Export Options displays the following facilities:
Output SQL Script File
You can enter the name of your output file by entering it into the Output SQL Script File text box, or by using the button to select a file. If this text box is left blank you will be able to view the generated script, but it will not be saved to a file.
Generate DROP Statements Before Each CREATE Statement
Omit Schema Qualifier in Object Names
Generate Separate CREATE INDEX Statements
Choosing this option creates separate statements for index
creation instead of creating indexes as part of a
CREATE TABLE statement.
Add SHOW WARNINGS after every DDL statement
Do Not Create Users. Only Export Privileges
To update the privileges of existing users as opposed to
creating new users, select this check box. Exporting privileges
for nonexistent users will result in errors when you execute the
CREATE script. Exporting users that already
exist, will also result in an error.
Generate INSERT Statements for Tables
If you have added any records to a table using the Insert tab of the MySQL Table Editor, choose this option. For more information about inserting records see Section 8.3.9, “The Inserts Tab”.
Clicking takes you to the SQL Object Export Filter page where you can select the objects you wish to export.
Precise control over the objects to be exported can be fine tuned by clicking the button. Once the objects to be exported have been selected it is possible to reduce the expanded panel by clicking the same button, now labelled .
Having selected the objects you wish to export you can click the button to review the script that has been generated:
The button saves the script file and exits. You may return to the previous screen using the button.
You can then use the saved script to create a database.