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

6.5.1 Table Data Export and Import Wizard

This wizard supports import and export operations using CSV and JSON files, and includes several configuration options (separators, column selection, encoding selection, and more). The wizard can be performed against local or remotely connected MySQL servers, and the import action includes table, column, and type mapping.

Note

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

The wizard is accessible from the object browser's context menu by right-clicking on a table and choose either Table Data Export Wizard or Table Data Import Wizard.

Figure 6.14 Table Data Wizards: Open

Table Data Wizards: Open

Table Data Export Wizard

Export table data to either a JSON or CSV file. The following example exports the sakila.actor table to a CSV file.

Figure 6.15 Table Data Export: Source

Table Data Export: Source

Figure 6.16 Table Data Export: CSV Configuration

Table Data Export: Configuration

Figure 6.17 Table Data Export: Results

Table Data Export: Results

Table Data Import Wizard

Import table data from either a JSON or CSV file. The following example imports the sakila.actor table from a CSV file.

Figure 6.18 Table Data Import: CSV Source

Table Data Import: CSV Source

Figure 6.19 Table Data Import: Destination Table

Table Data Import: Destination Table

Figure 6.20 Table Data Import: CSV Configuration

Table Data Import: CSV Configuration

Note

The Encoding field should correspond with your CSV file.

Figure 6.21 Table Data Import: Results

Table Data Import: Results


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