MySQL Workbench Manual  /  ...  /  SQL Data Export and Import Wizard

6.5.2 SQL Data Export and Import Wizard

Use this wizard to either export or import SQL generated from MySQL Workbench or with the mysqldump command.

Access these wizards from either the Navigator panel, or by selecting Server from the main menu, and then either Data Import or Data Export.

Note

This wizard only exports/imports the MySQL SQL format. For an overview of the data export and import options in MySQL Workbench, see Section 6.5, “Data Export and Import”.

Data Export

This tab allows you to export your MySQL data. Select each schema you want to export, optionally choose specific schema objects/tables from each schema, and generate the export. Configuration options include exporting to a project folder or self-contained SQL file, optionally dump stored routines and events, or skip table data.

Note

Alternatively, use Export a Result Set to export a specific result set in the SQL editor to another format such as CSV, JSON, HTML, and XML.

Select the Database objects to export, and configure the related options.

Note

Click Refresh to load the current objects.

Figure 6.22 Navigator Management: Data Export: Object Selection

Navigator Management: Data Export: Object Selection

Optionally open the Advanced Options tab that allows you to refine the export operation. For example, add table locks, use replace instead of insert statements, quote identifiers with backtick characters, and more.

Figure 6.23 Navigator Management: Data Export: Advanced Options

Navigator Management: Data Export: Advanced Options

Click Start Export to begin the export process:

Figure 6.24 Navigator Management: Data Export: Export Progress

Navigator Management: Data Export: Export Progress

This functionality uses the mysqldump command.

Data Import/Restore

Restore exported data from the Data Export operation, or from other exported data from the mysqldump command.

Choose the project folder or self-contained SQL file, choose the schema that the data will be imported to, or choose New to define a new schema.

Figure 6.25 Navigator Management: Data Import: Import From Disk

Navigator Management: Data Import: Import From Disk

Note

You may only select specific data objects (tables) to import if the data export operation used project folders instead of a self-contained SQL file.

Click Start Import to begin the import process:

Figure 6.26 Navigator Management: Data Import: Import Progress

Navigator Management: Data Import: Import Progress


User Comments
Sign Up Login You must be logged in to post a comment.