Use forward engineering to export your schema design to a MySQL server.

Select the schema that you wish to forward engineer and then choose Database, Forward Engineer ... option from the main menu.

The first page to be displayed is Catalog Validation (validation is only available in the Standard Edition):

Figure 7.28. Catalog Validation

Click Run Validations to validate the catalog.

Click the Next to continue.

The next page allows you to set options for the database to be created. These options are as described in Section 7.5.10.1.1, “Creating a Schema”:

Figure 7.29. Options

Select the required options and then click Next.

The next page allows you to select the objects to forward engineer:

Figure 7.30. Select Objects to Forward Engineer

To select a subset of objects to forward engineer use the Show Filter/Hide Filter button, and then select specific objects. Once you have selected your objects click Next to continue

On the Review Script page you may review and edit the SQL script that will be executed:

Figure 7.31. Review Script

Click Next to continue if you are satisfied with the generated script.

The next step of the process is to connect to a MySQL server in order to create the new database schema. This page allows you to use a previously stored connection, or enter the connection parameters:

Figure 7.32. Set parameters for connecting to a DBMS

Once the connection parameters have been set click Execute. The next page of the wizard displays the results of the forward engineering process:

Figure 7.33. Set parameters for connecting to a DBMS

You can confirm the creation of the schema by connecting to the target MySQL server and issuing the SHOW DATABASES; command.